MMD Services

Compensation

Full Description

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.