Data Jobs in Louisa, VA

1 job found

Include remote jobs

Today

Cloud Data Engineer

S&N Infrastructure Louisa, VA

Louisa, VA

Today

$95k+/yr Full time Cloud Data Data Engineer

Apply Now

Job Description

S&N Infrastructure is seeking a Cloud Data Engineer to architect, build, and sustain Azure-based data pipelines and Power BI solutions as part of an ERP cloud migration. This role focuses on delivering a robust data foundation, scalable semantic models, and executive-ready reporting to support strategic decisions. The position is hybrid and based in Louisa, Virginia, offering the chance to collaborate across multiple entities as the organization scales.

Responsibilities

Develop and scale the cloud data foundation that underpins enterprise reporting and analytics.
Design and operate reliable data pipelines linking ERP and other business-critical systems with an emphasis on reliability, maintainability, and performance.
Own end-to-end data ingestion, transformation, storage, and orchestration across the data platform.
Maintain a dependable, high-performing environment that can grow with the business.
Serve as a key technical contributor on the ERP cloud migration project.
Lead governance and evolution of the Power BI environment, including workspace structure, deployment standards, security, and performance optimization.
Create, optimize, and maintain datasets, dataflows, models, and business-critical reports.
Collaborate with stakeholders to translate reporting needs into actionable insights.
Develop scalable semantic models, DAX measures, and data layers to support informed decision-making.
Uphold governance standards and manage secure user access across the Power BI platform.
Set and enforce standards for data quality, consistency, and trust across the platform.
Build and maintain data dictionaries, lineage documentation, and metadata that scale with the organization.
Monitor platform health, troubleshoot issues promptly, and implement proactive alerting.
Collaborate with business teams to improve data accuracy and confidence in reporting.
Engage with business leaders to understand priorities and shape reporting solutions that matter.
Translate business questions into intuitive data models, dashboards, and visual insights.
Foster adoption through training, guidance, and documentation for Power BI users.
Work with software development and IT teams on application and integration data needs.
Support 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).
Experience configuring, deploying, and monitoring Self-Hosted Integration Runtime (SHIR), with heartbeat alerting.
Strong knowledge of Change Data Capture (CDC) on SQL Server for near real-time inserts, updates, and deletes.
Proven track record 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, including raw-to-curated layer design.
Experience building unified analytical views with Azure Synapse serverless SQL.
Deep Power BI experience across administration and development—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+.
Designing data lake architectures using raw-to-curated Delta format patterns.
Python or PySpark for data processing and transformation.
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.
Comfort working 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.
Experience implementing Power BI governance standards, deployment pipelines, row-level security, and usage monitoring.
Experience with Microsoft Fabric, Power Automate, or broader Azure ecosystem.
Background 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

Benefits

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

Pay

From USD 95,000 per year

Location

Louisa, VA 23093 (hybrid)

View full job page →

Get Job Alerts

New jobs delivered to your inbox.