Design and maintain the enterprise analytics architecture using Microsoft Fabric (OneLake, Lakehouse, Warehouse, Data Factory, Synapse, Real-Time Analytics).
Define architectural patterns for batch, near-real-time, and historical analytics workloads.
Establish standards for performance, scalability, reliability, and cost optimization.
Enterprise Source System Integration
Architect and optimize data integration from core enterprise systems, including:
o SAP S/4HANA - including CDS View layers (Basic, Composite, and Consumption VDMs), BW extractors, ODP, SLT, and APIs - and legacy ECC systems
o Epicor ERP - including understanding of Epicor's data model, BAQ (Business Activity Queries), REST APIs, and extraction patterns for Manufacturing, Finance, and Supply Chain domains
o Salesforce, Workday, LIMS and other SaaS or on-prem systems.
Apply knowledge of S/4HANA Embedded Analytics and, where relevant, SAP Datasphere or BW/4HANA as complementary analytical layers alongside Microsoft Fabric
Apply understanding of Epicor's reporting and analytics layer to ensure seamless integration into the Fabric Lakehouse and semantic model
Define delta handling, reconciliation, and data validation strategies to ensure accuracy and trust.
Data Modeling & Semantic Layer
Design enterprise data models (dimensional, data vault, or hybrid) aligned with business domains.
Build and govern Power BI semantic models to ensure KPI consistency, reuse, and performance.
Standardize enterprise metrics across Finance, Supply Chain, Sales, Operations, and HR.
Power BI & Analytics Enablement
Define Power BI architecture standards (workspace strategy, dataset reuse, Direct Lake vs Import vs DirectQuery).
Enable self-service analytics while maintaining governance and data quality.
Partner with business teams to deliver executive dashboards, operational reporting, and analytical insights.
Governance, Security & Compliance
Implement data governance across Fabric and Power BI (data lineage, certification, sensitivity labels).
Define and enforce row-level and object-level security, especially for financial and HR data.
Ensure compliance with internal controls, audit requirements, and regional data regulations.
Collaboration & Technical Leadership
Act as a trusted advisor to business and IT leadership on analytics strategy and roadmap.
Provide architectural guidance to data engineers, BI developers, and integration teams.
Evaluate and recommend new capabilities within the Microsoft analytics ecosystem.
AI & Advanced Analytics Enablement
Embed AI-readiness into platform architecture, enabling Copilot integrations, ML pipelines, and AutoML within Microsoft Fabric as first-class capabilities.
Define standards and patterns for predictive analytics, forecasting, and anomaly detection across key business domains such as Finance, Supply Chain, and Operations.
Establish governance frameworks for responsible AI, model explainability, and AI output trust - ensuring AI-driven insights meet enterprise audit and compliance standards.
Design and enable LLM-powered analytics capabilities within the platform architecture, including natural language querying of enterprise data, AI-assisted report generation and summarization, and secure integration of Azure OpenAI and Microsoft Copilot services - with awareness of broader LLM services accessible via Azure AI Foundry - ensuring all LLMs are grounded on governed enterprise data sources with appropriate access controls and compliance guardrails.
What Experience and Education You Need
Bachelor's degree in computer science, Information Systems, Engineering, or equivalent experience.
10+ years of experience in data, analytics, or BI architecture roles.
Deep hands-on experience with Microsoft Fabric and Power BI in enterprise environments.
Strong hands-on experience with S/4HANA data architecture, including CDS Views (Basic, Composite, and Consumption VDMs
Additional Information
Job Description Summary
The Data Analytics Architect is a senior technical leader responsible for designing, governing, and evolving the enterprise analytics ecosystem with Microsoft Fabric and Power BI as the foundational platform. This role ensures data from core enterprise systems-primarily SAP, Salesforce, Epicor, Workday, LIMS and other operational platforms-is transformed into trusted, scalable, and business-ready insights.
The architect serves as the bridge between business stakeholders, data engineering teams, and analytics consumers, enabling consistent reporting, advanced analytics, and decision support across the organization.
How will you make an impact & Requirement
Primary Responsibility
Own the end-to-end analytics architecture-from data ingestion through semantic modeling and visualization-ensuring a scalable, secure, and governed analytics platform that supports enterprise reporting, self-service analytics, and future AI-driven use cases.
Resonantclinical · Buford, GA