MMD Services
This range is provided by MMD Services. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.
$100,000.00/yr - $110,000.00/yr
Our client is a fast-growing leader recognized by both consumers and industry professionals.
They foster a dynamic, collaborative culture where high performers thrive in a fast‑paced, hands‑on environment. Although the company has over 60 years of history, they are entering a powerful new chapter of expansion, innovation, and transformation. Their people are their greatest asset—driven, engaged, and motivated by purposeful work.
Our client is seeking a Sr. Business Intelligence Analyst & Data Infrastructure Developer to design, build, and maintain a unified data architecture within
Microsoft Fabric
to support enterprise-wide reporting and analytics. This role blends advanced data engineering, SQL development, and Power BI expertise to integrate multiple data sources into a single, trusted reporting layer. The ideal candidate will build ETL pipelines, optimize semantic models, and partner closely with finance and business stakeholders to deliver scalable, accurate, decision‑driving insights.
What You Will Do:
Design and implement a unified enterprise data model by consolidating seven existing semantic models into a single Microsoft Fabric–based architecture.
Analyze legacy datasets and define optimal integration, migration, and consolidation strategies.
Develop and manage facts, dimensions, measures, and metadata aligned to business needs.
Define partitioning, refresh strategies, and performance optimization approaches.
ETL/ELT Development & Maintenance:
Build, enhance, and troubleshoot ETL/ELT pipelines using
SSIS
and
Microsoft Fabric Dataflows .
Determine when data should be materialized in the warehouse versus exposed through views.
SQL Development:
Write, debug, and optimize complex SQL, including stored procedures, CTEs, unions, and dynamic SQL.
Maintain and evolve SQL views supporting downstream reporting, dashboards, and analytics.
Partner with finance, operations, and executive teams to scale customized financial and operational reporting solutions.
Translate reporting requirements into scalable technical data models.
Facilitate discussions across business and technology teams to align on long‑term data architecture strategy.
Build, maintain, and optimize Power BI semantic models and datasets.
Deploy BI solutions via
VS Code ,
Tabular Editor , and
Azure DevOps
pipelines.
Support Power BI paginated reports and advanced DAX calculations.
What You Will Bring:
5–7 years of experience in business intelligence, data architecture, and ETL/ELT development.
Strong SQL expertise (CTEs, stored procedures, dynamic SQL, query optimization).
Intermediate to advanced
DAX
skills for performance tuning and model optimization.
Experience integrating data from major ERP systems (Syspro experience is a plus).
Deep expertise with
Power BI
(certification preferred).
Familiarity with AI/ML concepts, including agent‑based or predictive modeling.
Experience with
Microsoft Fabric , Azure Data Services, or similar cloud data platforms.
Education & Qualifications:
Bachelor’s degree in Data Science, Analytics, IT, or a related field; finance or accounting knowledge is strongly preferred.
Master’s or MBA is a plus.
Power BI certification preferred.
Microsoft Fabric certification preferred.
Proven ability to collaborate with senior finance and business leaders.
Seniority Level: Mid-Senior level
Employment Type: Full-time
Job Function: Information Technology
Industries: Retail and Chemical Manufacturing
Medical insurance
Vision insurance
401(k)
#J-18808-Ljbffr
$100,000.00/yr - $110,000.00/yr
Our client is a fast-growing leader recognized by both consumers and industry professionals.
They foster a dynamic, collaborative culture where high performers thrive in a fast‑paced, hands‑on environment. Although the company has over 60 years of history, they are entering a powerful new chapter of expansion, innovation, and transformation. Their people are their greatest asset—driven, engaged, and motivated by purposeful work.
Our client is seeking a Sr. Business Intelligence Analyst & Data Infrastructure Developer to design, build, and maintain a unified data architecture within
Microsoft Fabric
to support enterprise-wide reporting and analytics. This role blends advanced data engineering, SQL development, and Power BI expertise to integrate multiple data sources into a single, trusted reporting layer. The ideal candidate will build ETL pipelines, optimize semantic models, and partner closely with finance and business stakeholders to deliver scalable, accurate, decision‑driving insights.
What You Will Do:
Design and implement a unified enterprise data model by consolidating seven existing semantic models into a single Microsoft Fabric–based architecture.
Analyze legacy datasets and define optimal integration, migration, and consolidation strategies.
Develop and manage facts, dimensions, measures, and metadata aligned to business needs.
Define partitioning, refresh strategies, and performance optimization approaches.
ETL/ELT Development & Maintenance:
Build, enhance, and troubleshoot ETL/ELT pipelines using
SSIS
and
Microsoft Fabric Dataflows .
Determine when data should be materialized in the warehouse versus exposed through views.
SQL Development:
Write, debug, and optimize complex SQL, including stored procedures, CTEs, unions, and dynamic SQL.
Maintain and evolve SQL views supporting downstream reporting, dashboards, and analytics.
Partner with finance, operations, and executive teams to scale customized financial and operational reporting solutions.
Translate reporting requirements into scalable technical data models.
Facilitate discussions across business and technology teams to align on long‑term data architecture strategy.
Build, maintain, and optimize Power BI semantic models and datasets.
Deploy BI solutions via
VS Code ,
Tabular Editor , and
Azure DevOps
pipelines.
Support Power BI paginated reports and advanced DAX calculations.
What You Will Bring:
5–7 years of experience in business intelligence, data architecture, and ETL/ELT development.
Strong SQL expertise (CTEs, stored procedures, dynamic SQL, query optimization).
Intermediate to advanced
DAX
skills for performance tuning and model optimization.
Experience integrating data from major ERP systems (Syspro experience is a plus).
Deep expertise with
Power BI
(certification preferred).
Familiarity with AI/ML concepts, including agent‑based or predictive modeling.
Experience with
Microsoft Fabric , Azure Data Services, or similar cloud data platforms.
Education & Qualifications:
Bachelor’s degree in Data Science, Analytics, IT, or a related field; finance or accounting knowledge is strongly preferred.
Master’s or MBA is a plus.
Power BI certification preferred.
Microsoft Fabric certification preferred.
Proven ability to collaborate with senior finance and business leaders.
Seniority Level: Mid-Senior level
Employment Type: Full-time
Job Function: Information Technology
Industries: Retail and Chemical Manufacturing
Medical insurance
Vision insurance
401(k)
#J-18808-Ljbffr