Senior BI Modeler- PowerBI, DAX, SQL, Azure

INSPYR Solutions; Deerfield Beach (FL); Hybrid; USD 96,000 - 103,000; Full time

Job summary

INSPYR Solutions is seeking a Sr. Power BI Modeler in Deerfield Beach, FL. Hybrid role (3 days onsite, 2 days remote). You will design and optimize enterprise semantic models and BI solutions on the Microsoft platform, bridging business users with the data platform.

The role emphasizes Power BI, data modeling, performance tuning, and data governance, with collaboration across data engineers, analysts, and BI developers to deliver scalable analytics. 6-month+ engagement with potential extensions.

Qualifications

• Proven experience building and optimizing Power BI data models in an enterprise environment using star schema concepts.
• Strong SQL skills and proficiency with DAX and Power Query.
• Experience with Microsoft Fabric or Azure Synapse; cross-platform workloads.
• Knowledge of data governance and CI/CD practices is a plus.

Responsibilities

• Collaborate with stakeholders to gather requirements and identify data opportunities.
• Design, develop, and optimize semantic models supporting reporting and analytics needs.
• Optimize data structures for accuracy and performance; ensure data assets are certified.
• Support data engineering activities: pipelines, Lakehouse/Warehouse design, and data product development.
• Participate in deployment, release management, and COEs for Power BI.

Skills

Power BI modeling

DAX

SQL

Python

PySpark

Agile

Data governance

Data pipelines

Data visualization

Power BI performance tuning

Tools

Azure Synapse

Microsoft Fabric

Job description

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: US Citizen, GC 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.

About INSPYR Solutions

Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients' business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com.

INSPYR Solutions provides 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. INSPYR Solutions complies with all applicable laws governing nondiscrimination in employment in every location in which the company has facilities.

Information collected and processed through your application with INSPYR Solutions (including any job applications you choose to submit) is subject to INSPYR Solutions' Privacy Policy and INSPYR Solutions' AI and Automated Employment Decision Tool Policy: https://www.inspyrsolutions.com/policies/. By submitting an application, you are consenting to being contacted by INSPYR Solutions through phone, email, or text.

26-159950