Data & Analytics Engineer

US Diversity Job Search; Bristol (VA); On-site; USD 85,000 - 110,000; Full time

Job summary

Electro-Mechanical, LLC is seeking a Data & Analytics Engineer to design, build, and maintain a scalable data platform in Bristol VA. You will establish the data foundation using Microsoft Fabric, Power Platform, and leading visualization tools including Power BI and Tableau.

The role focuses on data architecture, integration, governance, and advancing analytics across the enterprise while mentoring teammates and driving innovation in cloud analytics.

Qualifications

• Bachelor's degree in CS or related field and 3–5 years in data engineering or BI.
• Strong SQL and data pipeline development experience in production.
• Experience with Fabric, Azure, Snowflake, or Databricks.
• Knowledge of data warehousing concepts and dimensional modeling.
• Experience with data governance, security, and compliance practices.

Responsibilities

• Design, develop, and maintain a scalable enterprise data platform using Microsoft Fabric and related Azure services.
• Build and optimize ETL/ELT pipelines across ERP, CRM, and other data sources.
• Develop enterprise dashboards and semantic models using Power BI and Tableau.
• Implement data governance, metadata management, lineage, and security controls.
• Mentor teammates and contribute to the data strategy and roadmap.

Skills

Microsoft Fabric

Data warehousing

SQL

ETL/ELT design

Power BI

Power Platform

Data integration

Data governance

Git/CI-CD

Education

Bachelor's degree in Computer Science or related field

Tools

Azure Synapse

Databricks

Snowflake

OneLake

Job description

Data & Analytics Engineer

This position requires a highly skilled Data & Analytics Engineer to design, build, and maintain a modern, scalable, and secure enterprise data platform. This role, based in Bristol VA, is responsible for establishing the organization's data foundation using Microsoft Fabric, Power Platform, and leading visualization technologies including Power BI and Tableau.

Primary Responsibilities

Data Platform & Architecture

• Design, develop, and maintain a scalable enterprise data platform leveraging Microsoft Fabric capabilities, including:
• OneLake
• Data Factory
• Data Engineering
• Data Warehouse
• Real-Time Analytics
• Lakehouse architecture
• Establish and manage data ingestion, transformation, and orchestration pipelines from multiple internal and external data sources.
• Develop and implement data models that support enterprise reporting, analytics, AI, and operational decision-making.
• Build reusable data products and semantic models that promote consistency and scalability across the organization.

Data Engineering & Integration

• Design and implement ETL/ELT processes using Microsoft Fabric and related Azure technologies.
• Integrate ERP, CRM, operational systems, cloud applications, APIs, and third-party data sources.
• Ensure data quality, reliability, and performance through monitoring, validation, and optimization.
• Implement data governance, metadata management, lineage, and security controls.

Business Intelligence & Analytics

• Develop enterprise dashboards, scorecards, and analytical solutions using Power BI and Tableau.
• Create scalable semantic models and datasets that support self-service analytics.
• Optimize visualization performance and user experience.
• Establish reporting standards, KPIs, and data definitions across business functions.
• Collaborate with business stakeholders to translate requirements into actionable analytics solutions.

Data Governance & Security

• Establish best practices for data management, access controls, privacy, and compliance.
• Define and maintain enterprise data standards and governance frameworks.
• Implement role-based security and data access policies within Microsoft Fabric and reporting platforms.
• Support audit, compliance, and regulatory requirements.

Continuous Improvement & Innovation

• Evaluate emerging technologies and best practices in cloud analytics, data engineering, and AI.
• Drive adoption of modern data architecture principles and analytics capabilities.
• Mentor team members and promote data literacy across the organization.
• Contribute to roadmap planning and strategic data initiatives.

Technical Skills

• Microsoft Fabric architecture and services
• Data warehousing and dimensional modeling
• SQL and advanced query optimization
• ETL/ELT design and implementation
• Power BI development and administration
• Power Platform (Power Apps, Power Automate, Dataverse)
• Data integration and API development
• Data governance and master data management
• Git/version control and CI/CD practices

Education and Experience 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 experience developing 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.

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

Salary

$85,000-110,000/year

EMC Guiding Principles

EMC expects that every team member will be guided by EMC's Guiding Principles.

About Electro-Mechanical, LLC

Electro-Mechanical is a privately held, growth-oriented manufacturer of electrical distribution equipment serving customers across multiple markets. With a legacy of engineering excellence and innovation, we deliver high-quality solutions that power progress in communities, industries, and infrastructure.

Disclaimer

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.