Power BI Developer
Location: Virtual
Function: Analytics & Data Science
Key Responsibilities
Power BI Solution Development
- Design and develop Power BI dashboards, reports, and semantic models aligned to business requirements.
- Build efficient, reusable data models using dimensional (star schema) principles.
- Develop and optimize DAX measures to support advanced analytics and performance needs.
Data Preparation & Integration
- Transform, clean, and shape data using Power Query (M).
- Partner with data engineering and upstream teams to ensure reliable, well-structured data sources.
- Write and validate SQL queries as needed to extract and profile source data.
Performance, Security & Governance
- Optimize dataset and DAX performance for scale and usability.
- Implement and test Row Level Security (RLS) to ensure appropriate data access.
- Support deployment and lifecycle management across Power BI Service workspaces and apps.
- Adhere to Clorox data governance, security, and reporting standards.
Business Partnership & Enablement
- Translate business questions into clear KPIs, metrics, and analytical views.
- Partner with stakeholders to ensure dashboards are intuitive, trusted, and adopted.
- Document metrics, assumptions, and data definitions to support self-service and consistency.
- Support enablement efforts by sharing best practices and reusable patterns.
Required Skills & Qualifications
Education and Professional Experience
- Bachelor's or Master's degree in Analytics, Data Science, Computer Science, Engineering, or a related field
- 4+ years of hands-on experience in independently developing Power BI solutions as a lead Power BI Developer (senior-level experience welcomed)
- Microsoft Power BI certification (PL-300) or equivalent experience
Technical Skills
- Strong experience with Power BI Desktop and Power BI Service
- Advanced DAX (measures, context, time intelligence)
- Proven experience in data modeling (relationships, cardinality, filter behavior)
- Hands-on Power Query / M for data transformation
- Solid SQL skills for data extraction and validation
- Experience implementing Row-Level Security (RLS) is a plus
- Familiarity with Azure data platforms (e.g., Databricks, Azure SQL, Synapse, Data Lake)
- Exposure to Power BI governance, deployment pipelines, or Git integration
Analytics & Visualization
- Strong understanding of data visualization best practices
- Ability to translate complex data into clear, executive ready insights
- Experience building interactive dashboards (filters, drill through, tooltips)
Business & Collaboration
- Ability to work effectively with cross-functional teams
- Strong communication skills with technical and non-technical audiences
- Detail oriented, with a focus on accuracy, consistency, and usability
To apply for this position, please send your resume to hr@cmercury.com