Senior BI Modeler- PowerBI, DAX, SQL, Azure
About The Position
The Senior BI Modeler is responsible for designing, developing, and optimizing enterprise semantic models, governed data products, and business intelligence solutions across the Microsoft platform. This role serves as the bridge between business users and the underlying data platform, ensuring data is trusted, performant, and accessible for analytics and decision-making. It requires deep expertise in Power BI, data modeling, and performance tuning, as well as a strong understanding of data engineering, governance and agile development practices. The role primarily focuses on semantic modeling, business intelligence, and self-service analytics enablement while also supporting data engineering activities such as data preparation, transformation, pipelines, Lakehouse and Warehouse design, and data product development. This position partners closely with other Data Engineers, Architects, Analysts, BI engineers and report developers and business stakeholders to deliver scalable analytics solutions.
Requirements
- Proven experience building and optimizing Power BI data models in an enterprise environment with ability to design dimensional models using star-schema principles, conformed dimensions, and appropriate data granularity.
- Strong understanding of DAX, Power Query (M), and data modeling principles.
- Strong SQL skills.
- Experience with Microsoft Fabric or Azure Synapse, with the ability to work across both platforms.
- Experience modernizing or migrating Synapse workloads to Microsoft Fabric.
- Working knowledge of Lakehouse & Warehouse Concepts, including experience building pipelines, notebooks, data integration patterns, Delta/Parquet file formats and CI/CD pipelines.
- Ability to translate business requirements into scalable and reusable data solutions.
- Familiarity with data governance, data quality, and certification processes.
- Experience working in Agile environments and collaborating across cross-functional teams.
- Excellent communication and stakeholder engagement skills.
- Passion for data.
Nice To Haves
- Experience with Python and PySpark is a plus.
- Experience contributing to or working with Power BI/Power Platform COEs is a plus.
Responsibilities
- Collaborate with business stakeholders to gather requirements and identify opportunities for new data solutions.
- Partner with data engineers, solution developers, and analysts to design, develop and optimize scalable semantic models supporting reporting and analytics needs.
- Optimize data structures and ensure the accuracy, reliability, and certification of data assets.
- Apply best practices and innovation to enhance Power BI modeling and dataset performance.
- Contribute to the evolution of the data ecosystem within the Business Unit and JM Family.
- Support and provide input to Power BI and Power Platform Centers of Excellence (COEs) to improve data practices and tool adoption.
- Design, build and support data pipelines and notebooks supporting analytics workloads from various sources into Data Lakehouse or Warehouse to support semantic models.
- Create curated Lakehouse and Warehouse structures optimized for reporting consumption.
- Perform necessary data profiling, data cleansing, aggregations, and normalization to deliver data products that are available for end-user consumption.
- Implement data quality checks and validation processes to ensure the accuracy, consistency, and completeness of data, based on guidelines set by stakeholders or downstream data and analytics systems. Detect and address data anomalies and errors.
- Participate and support deployment, release management, CI/CD, and source control processes.
- Support automation and monitoring of analytics data products.
- Contribute to platform modernization initiatives including Microsoft Fabric adoption.
Benefits
- Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, genetics, or any other protected status.
- Compliance with all applicable laws governing nondiscrimination in employment in every location in which the company has facilities.
- Reasonable accommodation during the application or interview process.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
