Data Reporting Analyst

Job Description

Our client operates at the crossroads of energy and home services, fueled by the vision of a smarter, cleaner future. Committed to developing groundbreaking solutions, they aim to streamline their customers' lives by providing energy, protection, and smart services for their homes and businesses.

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.

Essential Duties / Responsibilities :

• Developing reports using SQL queries / logic to extract data from Oracle databases, using application tools like SQL developer
• 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
• Assimilate information from various environments and develop queries or reporting solutions to fulfill business needs. Recognize data anomalies to analyze and troubleshoot to determine cause.
• 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.
• Prepares documentation on business and functional processes in support of reporting activities.
• Interact and consult with other areas / departments regarding Reporting issues and activities.

Qualifications :

Additional Knowledge, Skills, and Abilities :

Working Conditions :