Overview
The Data Analytics Consultant will be responsible for developing a comprehensive reporting capability that ensures accuracy and controlled access to operational services data. This role requires collaboration with business users to refine reporting needs, leveraging expertise in Power BI and SQL for effective data visualization and decision-making. Successful candidates will enhance the organization’s operational insight by integrating various data sources into clear, actionable reports.
Responsibilities
- Develop Power BI solutions to create reporting capabilities for operational services.
- Collaborate with business users to clarify and define reporting requirements.
- Utilize SQL for data extraction from relational sources.
- Design dashboards and visualize data following best practices.
- Implement row-level security and governed self-service reporting measures.
- Manage deployment pipelines and data gateways for operational data reports.
- Ensure accuracy and lineage in reporting solutions across operational datasets.
- Incorporate Azure data services as needed to enhance data management.
Requirements
- Must hold active Security Clearance (SC).
- Extensive experience with Power BI, including development, DAX, and Power Query.
- Strong proficiency in SQL and working with relational data sources.
- Proven skills in dashboard design and data visualization best practices.
- Experience handling complex operational datasets.
- Familiarity with row-level security and deployment pipelines in reporting.
- Knowledge of Azure data services is a plus.
- Ability to work effectively with non-technical users to improve reports.