Data Analyst

Our client, a leading energy company, is actively looking for a Data Analyst to join their team in Houston, TX!

***This role is beginning as a 6-month contract with potential to extend/convert***

 

SUMMARY:

This job is responsible for producing various ad-hoc and recurring reports from the SAP billing system or data warehouse equivalent for Executive/management, Customer Operations, Account Management (i.e., customer requests), Marketing, ARM and Finance. In addition, this job is responsible for creating support tools to assist with daily business operations. The purpose of the team is to achieve an increase in the effectiveness of the reporting data being utilized across the organization by eliminating redundant data and consolidating reports where appropriate and reducing work required to push data to users by automating as many recurring reports as possible.

 

KEY RESPONSIBILITIES:

• Developing reports using Microsoft SQL Server Reporting Services (SSRS) and supporting other analysts who use SQL Server Data Tools
• Developing reports using Microsoft Power BI
• Knowledge of development and running reports in PC SAS and Unix SAS environments desired.
• Knowledge of automation tools like work soft, WinRunner would be an additional asset.
• Participate in development and implementation of appropriate methods for monitoring, analyzing, and preparing data for management reports and statistics.
• Helping to gather and/or clarify data and reporting requirements from business owners
• Developing and maintaining database stored procedures
• Utilize thorough knowledge of table structure and reporting environments to gather data to report metrics. Generate effective reports and manipulate data in reports to provide key metrics to business operations.
• Demonstrate proficiency in external systems to diagnose and correct failures and errors from a reporting perspective.
• Participate in developing and implementation of new processes and tools to streamline workflow.
• Provide innovative solutions. Document and communicate technical data requirements for development of system queries and reports to support ongoing root cause analysis.
• Interact and consult with other areas/departments regarding Reporting issues and activities.

BASIC QUALIFICATIONS:

• At least 2 years’ experience in: Microsoft SQL Server (which uses the T-SQL ANSI/SQL development standards), SSRS (SQL Server Report Services), SSIS/DTS package development, Visual Studio, VisualBasic.net. Microsoft SSAS, cube development, and .NET experience is a plus.
• At least 1 years of experience developing Microsoft PowerBI reports
• 2+ years’ experience in data mining, querying / accessing large data sets and developing key business reports and metrics.
• Experience writing stored procedures, T-SQL, functions, and SQL queries. Experience utilizing report writing best practices (optimization, use of joins and sub-queries)
• Experience with manual testing to include User Acceptance Testing (UAT)
• Experience pulling data from Microsoft SQL Server 2005/2008 R2/2012/2014, Oracle, text files, excel files, MS Access databases for report
• Experience with cubes and drill down/drill through reports
• Experience with SQL Server Data Tools (SSDT) SSRS/SSIS/SSAS, Visual Studio, and/or other (non-Microsoft) reporting platform
• A minimum of 1-4 years’ experience in working with billing and/or enrollment data is required
• Proficient with Microsoft Office Suite (Excel, Word, Power Point).

Applicants must be currently authorized to work in the United States on a full-time basis now and in the future

You will receive the following benefits:

• Medical Insurance - Four medical plans to choose from for you and your family
• Dental & Orthodontia Benefits
• Vision Benefits
• Health Savings Account (HSA)
• Health and Dependent Care Flexible Spending Accounts
• Voluntary Life Insurance, Long-Term & Short-Term Disability Insurance
• Hospital Indemnity Insurance
• 401(k) including match with pre and post-tax options
• Paid Sick Time Leave
• Legal and Identity Protection Plans
• Pre-tax Commuter Benefit
• 529 College Saver Plan

Motion Recruitment Partners (MRP) is an Equal Opportunity Employer. All applicants must be currently authorized to work on a full-time basis in the country for which they are applying, and no sponsorship is currently available. Employment is subject to the successful completion of a pre-employment screening. Accommodation will be provided in all parts of the hiring process as required under MRP’s Employment Accommodation policy. Applicants need to make their needs known in advance.