Leads the design, development, and delivery of Power BI reporting solutions and enterprise semantic models to support data-driven decision-making. Responsible for end-to-end data transformation using Power Query and DAX, building and maintaining reusable semantic models, and enforcing data quality and governance standards across the reporting environment. Serves as a technical lead for BI development while partnering with business stakeholders to ensure reports are accurate, consistent, and fit for purpose.
Key Responsibilities: - Design, develop, and maintain Power BI reports and dashboards that meet business requirements for accuracy, performance, and usability
- Build and maintain Power BI semantic models, including table relationships, calculated columns, measures, and row-level security configurations
- Develop and manage Power Query data transformation logic to clean, reshape, and integrate data from multiple source systems into consistent, analysis-ready datasets
- Partner with data engineering, IT, and business stakeholders to define source-to-report data flows and resolve upstream data issues affecting report reliability
- Define and enforce data quality rules, profiling standards, and validation checks to ensure reports reflect accurate and trustworthy data
- Establish and document data governance standards for the Power BI environment, including dataset ownership, naming conventions, certification processes, and access controls
- Monitor and maintain the health of published datasets and reports in the Power BI service, including refresh schedules, gateway configurations, and usage metrics
- Optimize report and dataset performance through query folding, incremental refresh, aggregations, and efficient DAX patterns
- Provide guidance and enablement to report consumers on Power BI navigation, filtering, and correct interpretation of metrics
- Present findings and recommendations to leadership in a clear, concise, and actionable manner
Qualifications:Experience:- 4+ years of experience in business intelligence, data analytics, or a reporting-focused role
- Demonstrated experience delivering Power BI reports and semantic models used in production environments
- Hands-on experience writing DAX measures and Power Query transformations for complex business reporting requirements
Preferred:- Experience working with data warehouses, lakehouses, or cloud data platforms (e.g., Azure Synapse, Fabric, Databricks) as Power BI data sources
- Experience with Tabular Editor, DAX Studio, or ALM Toolkit for model development and optimization
- Familiarity with Microsoft Fabric or Power BI Premium capacity management
Knowledge and Skills:Required:- Advanced proficiency in DAX for calculated columns, measures, and time-intelligence functions
- Strong proficiency in Power Query (M) for data transformation, cleansing, and integration across heterogeneous sources
- Deep experience with Power BI Desktop, Power BI Service, and semantic model design (star schema, relationships, hierarchies)
- Solid understanding of data quality concepts including profiling, validation, lineage, and issue triage across the data pipeline
- Proficiency in SQL for data extraction, transformation validation, and troubleshooting source data issues
- Ability to document data models, transformation logic, and governance policies clearly for both technical and non-technical audiences
Preferred:- Experience with Microsoft Dynamics, Dataverse, or other Power Platform data sources
- Familiarity with data governance frameworks such as DAMA-DMBOK or enterprise data catalog tools (e.g., Purview)
- Experience implementing row-level security (RLS) and object-level security (OLS) in Power BI semantic models
- Knowledge of version control practices for Power BI (e.g., PBIP format with Git integration) and deployment pipeline management
- Experience with Python or R for data preparation tasks that feed into Power BI datasets
Education Requirements:Minimum education credentials required for the role:
- Bachelor's degree in Data Science, Data Analytics, Computer Science, Information Technology, Engineering, Mathematics, Finance, or related field
- Equivalent combination of education and experience may be considered
Certificates/Licenses:- Microsoft Certified: Power BI Data Analyst Associate (PL-300) preferred; not required
Physical Requirements:Minimum physical requirements required to perform the duties of the job
Environment/Noise:Describe Work Environment (i.e. Office, Outside, Working with Machinery) and Noise Level
