Sr. BI Analyst

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:

Lead Data Architecture Initiatives

• 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.
• Maintain data lineage, data dictionaries, and metadata documentation.

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.

Collaboration & Reporting

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

Semantic Model Management

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

MMD Services Inc. is an equal opportunity employer. All applicants are considered for all positions without regard to race, religion, color, sex, gender, sexual orientation, pregnancy, age, national origin, ancestry, physical/mental disability, medical condition, military/veteran status, genetic information, marital status, ethnicity, alienage or any other protected classification, in accordance with applicable federal, state, and local laws.