Senior BI Modeler- PowerBI, DAX, SQL, Azure

Job Title: Sr. Power BI Modeler
Location: Deerfield Beach, FL (Hybrid 3 days onsite, 2 days remote)
Duration: 6 Months with anticipated extensions, could go long term.
Compensation: 70-75/hr
Work Requirements: , Holders or Authorized to Work in the U.S.

JOB SPECS

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.

CORE BI MODELING & DATA PRODUCT 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.

SUPPORTING DATA ENGINEERING RESPONSIBILITIES:

• 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.

QUALIFICATIONS:

• 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.
• Experience with Python and PySpark is a plus.
• Passion for data.
• Experience contributing to or working with Power BI/Power Platform COEs is a plus.