Data & Analytics Engineer

Electro-Mechanical Corporation offers an onsite Data & Analytics Engineer opportunity in Bristol, VA with a competitive salary range of $85,000–$110,000 per year. This role places you at the forefront of our data strategy, enabling you to design, build, and maintain a scalable enterprise data platform using Microsoft Fabric, Power Platform, and industry-leading visualization tools. Expect a collaborative environment that values mentorship, governance, and strategic impact as you partner with stakeholders to unlock data-driven decisions across the organization.

Responsibilities

• Design, develop, and sustain a scalable enterprise data platform leveraging Microsoft Fabric capabilities including OneLake, Data Factory, Data Engineering, Data Warehouse, Real-Time Analytics, and Lakehouse architecture.
• Establish and manage data ingestion, transformation, and orchestration pipelines from multiple internal and external sources.
• Develop data models supporting enterprise reporting, analytics, AI, and operational decision making.
• Build reusable data products and semantic models to promote consistency and scalability across the organization.
• 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.
• Develop enterprise dashboards, scorecards, and analytical solutions with Power BI and Tableau.
• Create scalable semantic models and datasets to 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.
• 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.
• Evaluate 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 combinations of education and experience considered.
• 3–5 years of experience in data engineering, analytics engineering, business intelligence, or related roles.
• Proven track record designing, developing, and supporting data pipelines and analytical solutions in production.
• Strong SQL skills with experience crafting 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, 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