Overview

We are seeking a highly motivated Data Analyst with strong SQL skills and experience in maintaining data integrity. The ideal candidate will be responsible for ensuring the accuracy and consistency of data sources, writing tests to validate data, and creating impactful Power BI dashboards. This role requires a detail-oriented individual who can work collaboratively with cross-functional teams to provide data-driven insights and ensure data quality.

Responsibilities

The Data Analyst will report to the Manager, Data Analytics and Insights, Power Sector and will have the following responsibilities:

• Maintain and ensure the accuracy, consistency, and reliability of data across multiple data sources and systems.
• Design and implement automated tests to ensure data integrity and identify potential issues before they impact reporting and analytics.
• Write, optimize, and maintain SQL queries to extract, manipulate, and analyze data from databases.
• Design, develop, and maintain interactive and visually appealing Power BI dashboards to provide actionable insights to stakeholders.
• Work closely with business units and IT teams to understand data requirements, resolve data-related issues, and ensure consistent data delivery.
• Document data models, data flow, and testing procedures to ensure clarity and knowledge sharing across teams.
• Identify opportunities to improve data processes and workflows, ensuring the efficiency and accuracy of data management practices.

Qualifications

• Strong proficiency in SQL for data extraction, manipulation, and analysis.
• Experience with Power BI for creating dynamic dashboards and reports.
• Knowledge of relational databases and data warehousing concepts.
• Understanding of automated data integrity testing.
• Strong analytical thinking and attention to detail.
• Problem-solving skills with the ability to work independently or in a team environment.
• Bachelor’s degree in Data Science, Computer Science, Information Systems, Statistics, or related field.
• Min 5+ years of experience as a Data Analyst or in a similar role.
• Prior experience on Python is preferred.
• Experience working with real-time systems and data connectivity is preferred.