Title: Sr BI Modeler
Duration: 6+ Months
Location: Deerfield Beach, FL (Hybrid 3/2)
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.