|
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
Work Experience
|