Data & Analytics Engineer

Data & Analytics Engineer responsible for designing, building, and maintaining a scalable enterprise data platform using Microsoft Fabric, Power Platform, and leading visualization tools (Power BI and Tableau), based in Bristol, VA.

Responsibilities

• Build and sustain a scalable enterprise data platform using Microsoft Fabric components, including OneLake, Data Factory, Data Engineering, Data Warehouse, Real-Time Analytics, and Lakehouse architecture.
• Create and operate data ingestion, transformation, and orchestration pipelines from diverse internal and external sources.
• Design data models to support enterprise reporting, analytics, AI, and operational decision-making.
• Develop reusable data products and semantic models to ensure consistency and scalability across the organization.
• Architect and deploy ETL and ELT workflows using Microsoft Fabric and related Azure technologies.
• Integrate ERP, CRM, operational systems, cloud applications, APIs, and third-party data sources.
• Maintain data quality, reliability, and performance through monitoring, validation, and optimization.
• Establish data governance, metadata management, lineage, and security controls.
• Develop enterprise dashboards, scorecards, and analytics solutions using Power BI and Tableau.
• Build scalable semantic models and datasets that enable self-service analytics.
• Improve visualization performance and user experience.
• Set reporting standards, KPIs, and data definitions across business functions.
• Partner with stakeholders to translate requirements into actionable analytics solutions.
• Define best practices for data management, access controls, privacy, and compliance.
• Define and maintain enterprise data standards and governance frameworks.
• Enforce role-based security and data access policies within Microsoft Fabric and reporting platforms.
• Support audit, compliance, and regulatory requirements.
• Assess emerging technologies and best practices in cloud analytics, data engineering, and AI.
• Promote adoption of modern data architecture principles and analytics capabilities.
• Mentor team members and advance data literacy across the organization.
• Contribute to roadmap planning and strategic data initiatives.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, Statistics, or a related field; equivalent combination of education and relevant experience may be considered.
• 3-5 years of experience in data engineering, analytics engineering, business intelligence, or related roles.
• Experience designing, developing, and supporting data pipelines and analytical solutions in a production environment.
• Strong SQL skills with the ability to develop complex queries, views, stored procedures, and data transformations.
• Experience building and maintaining ETL/ELT pipelines.
• Experience with modern cloud data platforms such as Fabric, Snowflake, Databricks, or Azure Synapse.
• Knowledge of data warehousing concepts, dimensional modeling, and data architecture best practices.
• Experience with enterprise integrations, middleware, APIs, and data migration methodologies.
• Experience with Microsoft Azure, AWS, or Google Cloud Platform.
• Understanding of data quality frameworks, monitoring, and validation processes.
• Experience implementing data governance, metadata management, and master data practices.
• Knowledge of security, privacy, and compliance considerations related to enterprise data.
• Experience supporting Finance, Supply Chain, Manufacturing, or Commercial analytics.
• Experience in manufacturing, distribution, industrial, private equity-backed, or multi-site organizations.

Technologies

• Microsoft Fabric, OneLake, Data Factory, Data Warehouse
• Power BI, Tableau, Power Apps, Power Automate, Dataverse
• Git, SQL, Snowflake, Databricks, Azure Synapse
• Microsoft Azure, AWS, Google Cloud Platform
• Python, Spark, PySpark
• Azure DevOps, Power Platform, API development

Preferred Skills

• Microsoft Azure Data Services
• Python, Spark, or PySpark
• Azure DevOps
• DataOps and MLOps concepts
• Real-time analytics and streaming architectures
• AI/ML integration within Microsoft Fabric
• Enterprise ERP and CRM integrations

Preferred Certifications

• Microsoft Certified: Fabric Analytics Engineer Associate
• Microsoft Certified: Power BI Data Analyst Associate
• Microsoft Certified: Azure Data Engineer Associate

Compensation

Salary: USD 85,000 - 110,000 per year