Senior Power BI Developer

Culligan•Rosemont, IL

About The Position

The Senior Power BI Developer leads the design, development, and optimization of the enterprise reporting and analytics platform supporting the Americas business. The role owns semantic models, dashboards, and paginated reports used by leadership and operational teams, and partners with the data warehouse team to maintain accurate, governed, and performant data. The primary focus is advanced Power BI and Microsoft Fabric development, with junior-level data warehouse responsibilities that include building Azure Data Factory pipelines, deploying through Azure Pipelines, and performing entry-level transformation work in Azure Databricks under the direction of senior data engineering staff. This hands-on role offers the opportunity to grow from reporting expertise into broader data engineering capability. The position works with business stakeholders and outside consultants to deliver analytics solutions on time and on budget. It also supports analysts developing self-service content on certified models, documents reporting and data architecture, and performs other duties as assigned.

Requirements

Bachelor's degree in Information Technology, Computer Science, Analytics, or a related field.
Five or more years of business intelligence development experience, including at least three years dedicated to Power BI.
Expert-level Power BI skills across advanced DAX, Power Query and M, data modeling, performance optimization, row-level security, and Power BI Service administration.
Working knowledge of Microsoft Fabric, including lakehouse and warehouse items, dataflows Gen2, OneLake, and deployment pipelines.
Practical experience building and scheduling ingestion and transformation pipelines in Azure Data Factory; junior-level proficiency is acceptable.
Exposure to Azure Databricks and Apache Spark notebooks for data preparation, and interest in developing deeper engineering capability.
Experience deploying analytics assets through Azure Pipelines or Azure DevOps, including Git source control and automated release management.
Proficiency writing and optimizing Microsoft SQL queries, stored procedures, and views, with hands-on use of SQL Server Management Studio (SSMS) for development, query analysis, and troubleshooting.
Experience with NetSuite reporting, including saved searches, report builder, and extracting NetSuite data for downstream analytics.
Working knowledge of the Power BI Gateway, including installation, data source configuration, credential management, and troubleshooting scheduled refresh against on-premises sources.
Strong SQL and dimensional modeling fundamentals, including star schemas and slowly changing dimensions.
Working proficiency in Python for data transformation tasks.
Strong oral and written communication skills, including the ability to explain data concepts to non-technical stakeholders.

Nice To Haves

Microsoft certification such as PL-300, DP-600, or DP-203.
Reporting experience against SAP S/4HANA or IFS.
Familiarity with Unity Catalog, Azure Synapse Analytics, Power Platform integration, and Agile delivery methods.

Responsibilities

Design, build, and maintain interactive Power BI dashboards and paginated reports for finance, supply chain, service, and commercial stakeholders across the Americas.
Develop and tune enterprise semantic models, including advanced DAX measures, Power Query transformations, incremental refresh, row-level security, and composite and DirectQuery models.
Build and administer Microsoft Fabric solutions, including lakehouses, warehouses, dataflows, notebooks, and OneLake shortcuts, applying workspace, capacity, and deployment pipeline governance.
Establish and enforce reporting standards for data definitions, certified datasets, visual design, accessibility, and performance benchmarks.
Build and maintain Azure Data Factory ETL and ELT pipelines to ingest data from SAP S/4HANA, IFS, NetSuite, and other source systems into the Azure data platform.
Deploy datasets, reports, and pipeline artifacts through Azure Pipelines in accordance with CI/CD, source control, and release approval practices.
Perform entry-level Azure Databricks development by writing SQL and Python notebooks to cleanse and shape data for reporting under senior data engineers’ guidance.
Contribute to dimensional modeling, including star schemas and fact and dimension tables, and assist with query tuning, indexing, and partitioning of reporting tables.
Administer the Power BI Gateway, monitor scheduled refreshes and pipeline runs, troubleshoot failures, and escalate persistent data quality issues to the data warehouse team.
Apply data governance and security practices, including workspace access models, sensitivity labeling, and role-based permissions aligned with corporate policy.
Document semantic models, data flows, and report logic, and produce architecture diagrams showing data movement from source systems to published reports.
Partner with business stakeholders and outside consultants to deliver analytics solutions on time and on budget.
Mentor analysts building self-service content on certified models.
Perform other duties as assigned.