Job Overview
This role involves architecting robust data solutions and creating insight-driven dashboards using Power BI. It requires direct interaction with end users for requirements, testing, and implementation, focusing on transforming complex data into actionable intelligence.
Responsibilities
- Create sophisticated Power BI dashboards and reports to drive business decisions, including advanced DAX calculations and intuitive interfaces with interactive features.
- Design, build, and maintain scalable data pipelines and ETL/ELT processes using Power Query, Dataflows, and Azure Data Factory.
- Develop and optimize data models using star schema, snowflake schema, and dimensional modeling techniques.
- Implement and manage data warehouses and data lakes using Azure Synapse Analytics, SQL Server, or similar platforms.
- Write and optimize complex SQL queries, stored procedures, and database functions for performance and efficiency.
- Establish data governance frameworks, including data quality checks, validation rules, and documentation standards.
- Configure and manage Power BI workspaces, deployment pipelines, and version control.
- Implement row-level security and object-level security for data protection.
- Optimize report performance through query optimization, data model refinement, and DAX tuning.
- Integrate Power BI with various data sources including SQL databases, APIs, SharePoint, Excel, and cloud platforms.
- Automate data refresh schedules and monitor gateway configurations.
Qualifications
- 3+ years of hands-on experience with Power BI development (Desktop, Service, and Report Server).
- Expert-level proficiency in DAX and Power Query (M language).
- Strong SQL skills with experience in database design, query optimization, and performance tuning.
- Solid understanding of data warehousing concepts, dimensional modeling, and ETL principles.
- Experience with data visualization best practices and UI/UX design principles.
- Proficiency in Azure data services (Azure SQL Database, Synapse Analytics, Data Factory, or Fabric).
- Deep understanding of data modeling techniques and relationships (one-to-many, many-to-many, bi-directional).
- Strong grasp of statistical concepts and analytical methodologies.
- Ability to translate complex business requirements into technical data solutions.
- Experience with data quality assessment and data profiling.
- Proven ability to create visually compelling, executive-level dashboards and reports.
- Strong problem-solving skills.
