Cloud Data Engineer

Join S&N Infrastructure as a Cloud Data Engineer and help design, build, and support Azure data pipelines and Power BI solutions for ERP cloud migration. This hybrid role in Louisa, VA offers a competitive salary of USD 95,000 per year and a benefits package that includes 401(k), 401(k) matching, dental, health, life, paid time off, and vision coverage. You will deliver reliable data infrastructure, scalable semantic models, and executive-ready reporting to empower informed decisions across the business.

Benefits

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Life insurance
• Paid time off
• Vision insurance

Responsibilities

• Build and scale the cloud data foundation that powers enterprise reporting and analytics.
• Design and manage robust data pipelines linking ERP and other critical systems with emphasis on reliability, maintainability, and performance.
• Own data ingestion, transformation, storage, and orchestration across the platform.
• Maintain a reliable, high-performing environment that can grow with the business.
• Serve as a key technical contributor on the ERP cloud migration.
• Oversee administration and evolution of the Power BI environment including workspace architecture, deployment governance, security, and performance tuning.
• Build, optimize, and maintain datasets, dataflows, models, and critical reports.
• Partner with stakeholders to translate reporting needs into actionable insights.
• Establish scalable semantic models, DAX measures, and data layers that support informed decisions.
• Maintain governance standards and secure user access across the Power BI environment.
• Set the standard for data quality, consistency, and trust across the platform.
• Develop and maintain data dictionaries, lineage documentation, and metadata as the organization scales.
• Monitor platform health, resolve issues promptly, and implement proactive alerting.
• Collaborate with business teams to improve data accuracy and confidence in reporting.
• Work with business leaders to understand priorities and shape reporting solutions that matter.
• Translate business questions into intuitive data models, dashboards, and visual insights.
• Enable adoption through training, guidance, and documentation for Power BI users.
• Partner with software development and IT teams on application and data integration needs.
• Help guide data-related priorities and roadmap discussions alongside IT leadership.

Requirements

• Hands-on experience with Microsoft Azure, including Azure Data Factory, Azure Data Lake Gen2, and Azure Synapse Analytics (serverless SQL).
• Configuring, deploying, and monitoring Self-Hosted Integration Runtime (SHIR), including heartbeat alerting.
• Strong knowledge of Change Data Capture (CDC) on SQL Server for near real-time inserts, updates, and deletes.
• Proven experience building and supporting ADF incremental pipeline patterns in production, including LSN watermark logic from on-premises SQL to Azure.
• Familiarity with Delta Parquet / Delta Lake architecture and raw-to-curated layer design.
• Building unified analytical views with Azure Synapse serverless SQL.
• Deep Power BI experience across administration and development, including DirectQuery, composite models, governance, datasets, dataflows, DAX, and semantic layers.
• Platform monitoring with Azure Monitor, SQL Agent alerts, SHIR heartbeat, and Power BI freshness dashboards.
• Strong ETL / ELT pipeline development with ADF, including incremental loads, watermarking, and orchestration.
• Advanced SQL and T-SQL for data modeling, transformation logic, and cross-database analytics.
• Implementing and managing Change Data Capture (CDC) on SQL Server 2016 or newer.
• Designing data lake architectures using raw-to-curated Delta format patterns.
• Python or PySpark for data processing and transformation.
• Experience integrating ERP data into reporting and analytics environments.
• 5+ years in data engineering or BI development.
• Ability to work independently, make sound technical decisions, and own critical deliverables with limited oversight.
• Comfortable in a growing, multi-entity environment with evolving priorities.
• dbt or other SQL-based transformation framework experience in a modern analytics stack.
• Azure DevOps and CI/CD experience for data pipelines, release management, and environment promotion.
• Implementing Power BI governance standards, deployment pipelines, row-level security, and usage monitoring.
• Microsoft Fabric, Power Automate, or broader Azure ecosystem experience.
• Experience in acquisition-heavy, multi-entity, or fast-scaling organizations with complex reporting needs.
• Prior experience supporting ERP modernization, cloud migration, or enterprise reporting transformation.

Technologies

• Azure Data Factory
• Azure Data Lake Gen2
• Azure Synapse Analytics (serverless SQL)
• Self-Hosted Integration Runtime (SHIR)
• Change Data Capture (CDC) on SQL Server
• Delta Parquet
• Delta Lake
• Azure Synapse serverless SQL
• Power BI
• DirectQuery
• DAX
• Dataflows
• SQL Server
• Python
• PySpark
• dbt
• Azure DevOps
• Microsoft Fabric
• Power Automate
• SQL Agent
• Azure Monitor