Azure Data Engineer

RIVAGO INFOTECH INC.

McLean, VA, United States

3 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

8 years minimum

Working hours

Regular working hours

Job source

dice.com

Tech stack

.NET Framework Microsoft Azure C Sharp (Programming Language) Computer Programming Continuous Integration Data Validation Data Integration Extract Transform Load (ETL) Data Security Relational Databases Database Development DevOps

+15 more

SQL Azure Query Optimization SQL Stored Procedures SQL Databases Freeform SQL Azure Data Factory Snowflake Indexer Backend Git Data Lakes Deployment Automation Star Schema Azure Synapse Analytics Data Pipelines

Job description

Design, develop, and maintain scalable data pipelines using Azure Data Factory / Azure Data Pipelines (ADT).
Build and optimize ETL workflows to extract, transform, and load data from multiple structured and unstructured sources.
Develop data integration services and backend components using .NET (C#).
Write and optimize complex SQL queries, stored procedures, and performance-tuned database solutions.
Implement data quality checks, validation frameworks, and monitoring dashboards.
Work with cross-functional teams (Data Analysts, Architects, DevOps) to understand data needs and deliver robust solutions.
Ensure data security, compliance, and governance across pipelines and storage layers.
Troubleshoot data pipeline issues and drive root-cause analysis and resolutions.
Contribute to architecture discussions and recommend improvements for performance, scalability, and cost efficiency.

Requirements

8+ years of professional experience as a Data Engineer or similar role.
Strong programming skills in .NET / C# for backend or data integration components.
Deep expertise in SQL including query optimization, indexing, stored procedures, and relational database concepts.
Proven experience building ETL pipelines and data workflows.
Hands-on experience with Azure Data Factory / Azure Data Pipelines (ADT) (heavy/advanced experience required).
Knowledge of Azure storage services such as Azure SQL DB, Synapse, Data Lake Storage (ADLS), Blob Storage.
Familiarity with CI/CD pipelines, Git, and deployment automation.
Understanding of data modeling concepts (star schema, snowflake, SCD, normalization).