Job Description
Job Description
Cloud Data Engineer
Remote (with potential travel to the Washington D.C. metro area area on special occasions)
Active Public Trust
Pay : $58.00 - $60.00 per hour
25-30748
Job Summary
The Cloud Data Engineer designs, builds, and maintains enterprise-scale data pipeline solutions supporting a Microsoft Azure–based analytics and reporting platform. This role translates business requirements into robust data engineering solutions, supports legacy SQL Server ETL operations, and leads the transition to modern cloud-native architectures. The ideal candidate is delivery-focused, customer-oriented, and comfortable solving complex technical challenges in regulated environments.
Job Responsibilities
-
Maintain and operate legacy ETL processes using Microsoft SSIS, SQL Server, SQL Agent, PowerShell, SSAS, .NET, and related technologies
-
Design, develop, and operate full lifecycle Azure cloud-native data pipelines
-
Collaborate with stakeholders and technical teams to gather data requirements and implement appropriate solutions
-
Design and implement data models and pipelines across relational, dimensional, data warehouse, data mart, lakehouse (medallion architecture), SQL, and NoSQL data stores
-
Develop high-performing pipelines using Azure Data Factory, Azure Synapse Pipelines, Apache Spark Notebooks, Python, SQL, and stored procedures
-
Migrate and modernize existing SSIS ETL processes to Azure Data Factory and Synapse
-
Prepare and transform data for analytics, visualization, reporting, and AI/ML use cases
-
Implement data migration, integrity, quality, metadata management, and security controls
-
Monitor, troubleshoot, and optimize data pipelines for availability and performance
-
Implement governance, CI/CD, deployment, and monitoring to automate platform operations
-
Support Agile DevOps practices, including Program Increment (PI) planning
-
Maintain strict versioning and configuration control to ensure data integrity
-
Continuously learn and adopt new tools and best practices
Job Requirements
-
Public Trust clearance required
-
Bachelor’s degree in Computer Science or related field with 8+ years of experience, or Master’s degree with 6+ years of experience
-
4+ years of experience developing and maintaining ETL solutions using Microsoft SSIS, SQL Server, SQL Agent, and PowerShell
-
4+ years of experience with scripting/programming languages such as SQL, T-SQL, Python, and/or PySpark
-
Strong experience with Microsoft data and BI tools including SQL Server, stored procedures, SSIS, SSRS, and SSAS
-
Experience designing and building data engineering solutions using Azure services such as Azure Data Lake, Azure Synapse, and Azure Data Factory
Education
-
Bachelor’s degree in Computer Science or related field required
Work Experience
-
6–8+ years of relevant data engineering or ETL experience depending on degree level
#ZR