Senior Power BI Developer

Culligan International•Rosemont, IL

17h•$120,000 - $140,000

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 ensure underlying data is accurate, governed, and performant. The primary focus is advanced Power BI and Microsoft Fabric development, with junior-level data warehouse responsibilities. The role builds and maintains Azure Data Factory pipelines, deploys assets through Azure Pipelines, and performs entry-level transformation work in Azure Databricks under the direction of senior data engineering staff. It is a hands-on position for someone seeking to grow from reporting expertise into broader data engineering capability.

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, with an 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, plus working proficiency in Python for data transformation tasks.
Strong oral and written communication skills, with 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 ETL and ELT pipelines in Azure Data Factory 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, following established CI/CD, source control, and release approval practices.
Perform entry-level development in Azure Databricks, 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 to corporate policy.
Document semantic models, data flows, and report logic, and produce architecture diagrams showing how data moves 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, and perform other duties as assigned.