10240

3Core Systems, Inc; Deerfield Beach (FL); On-site; USD 120,000 - 170,000; Full time

Job summary

3Core Systems, Inc. in Deerfield Beach, FL is seeking a Senior BI Modeler to design, develop, and optimize enterprise semantic models and data products across the Microsoft platform.

You will bridge business users and the data platform, ensuring trusted, performant analytics. Focus areas include semantic modeling, self-service analytics enablement, data pipelines, Lakehouse/Warehouse design, and data product development, collaborating with data engineers, analysts, and stakeholders to deliver

Qualifications

• Proven experience building and optimizing Power BI data models in an enterprise environment.
• Ability to design dimensional models using star-schema concepts and conformed dimensions.
• Strong knowledge of DAX, Power Query, and data modeling principles.
• Experience with Microsoft Fabric or Azure Synapse and cross-platform work.

Responsibilities

• Collaborate with stakeholders to gather requirements and identify data-solutions opportunities.
• Design, develop and optimize scalable semantic models for reporting and analytics.
• Optimize data structures for accuracy, reliability, and certification of data assets.
• Apply best practices to enhance Power BI modeling and dataset performance.
• Support data platform modernization and governance initiatives.
• Assist with data engineering activities including pipelines, lakehouse/warehouse design, and data products.

Skills

Power BI

Data Modeling

DAX

SQL

Python

PySpark

Microsoft Fabric

Azure Synapse

CI/CD

Data Governance

Tools

Not specified

Job description

Deerfield Beach, United States

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 roleserves as the bridge between business users and the underlying data platform,ensuring data is trusted, performant, and accessible for analytics anddecision-making. It requires deep expertise in Power BI, data modeling, andperformance tuning, as well as a strong understanding of data engineering, governanceand agile development practices.

The role primarily focuses on semantic modeling, business intelligence, andself-service analytics enablement while also supporting data engineeringactivities such as data preparation, transformation, pipelines, Lakehouse andWarehouse design, and data product development. This position partners closelywith other Data Engineers, Architects, Analysts, BI engineers and reportdevelopers and business stakeholders to deliver scalable analytics solutions.

CORE BI MODELING & DATA PRODUCT RESPONSIBILITIES:

• Collaborate with business stakeholders to gather requirements and identifyopportunities for new data solutions.
• Partner with data engineers, solution developers, and analysts to design,develop and optimize scalable semantic models supporting reporting andanalytics needs.
• Optimize data structures and ensure the accuracy, reliability, andcertification of data assets.
• Apply best practices and innovation to enhance Power BI modeling and datasetperformance.
• Contribute to the evolution of the data ecosystem within the Business Unitand JM Family.
• Support and provide input to Power BI and Power Platform Centers ofExcellence (COEs) to improve data practices and tool adoption.

SUPPORTING DATA ENGINEERING RESPONSIBILITIES:

• Design, build and support data pipelines and notebooks supporting analyticsworkloads from various sources into Data Lakehouse or Warehouse to supportsemantic models.
• Create curated Lakehouse and Warehouse structures optimized for reportingconsumption.
• Perform necessary data profiling, data cleansing, aggregations, andnormalization to deliver data products that are available for end-userconsumption.
• Implement data quality checks and validation processes to ensure theaccuracy, consistency, and completeness of data, based on guidelines set bystakeholders or downstream data and analytics systems. Detect and address dataanomalies and errors.
• Participate and support deployment, release management, CI/CD, and sourcecontrol processes.
• Support automation and monitoring of analytics data products.
• Contribute to platform modernization initiatives including Microsoft Fabricadoption.

QUALIFICATIONS:

Proven experience building and optimizing Power BI data models in an enterprise environment withability to design dimensional models using star-schema principles, conformeddimensions, and appropriate data granularity.

• Strong understanding of DAX, Power Query(M), and data modeling principles.
• Strong SQL skills.
• Experience with Microsoft Fabric or AzureSynapse, 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 datasolutions.
• Familiarity with data governance, data quality, and certification processes.
• Experience working in Agile environments andcollaborating 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 withPower BI/Power Platform COEs is a plus.