ETL Developer

About the role

You will assist in the design and implementation of enterprise-level backend and frontend solutions within a modernized Azure-based data ecosystem. This role emphasizes scalability, security, and integration with advanced analytics and data-sharing tools. You will help integrate analytical and AI solutions within existing system architectures and workflows, working alongside senior engineers to build and maintain mission-critical data infrastructure.

Responsibilities

• Assist in designing and implementing backend and frontend components for enterprise data solutions on Azure.
• Build and maintain data pipelines using Azure Data Factory (ADF), including complex pipelines, triggers, parameterization, monitoring, and error handling.
• Support development and optimization of Azure Synapse Analytics SQL pools, Spark pools, and data warehousing solutions.
• Assist in the organization, security, and performance tuning of Azure Data Lake Storage (ADLS Gen2).
• Support implementation of ETL/ELT patterns following medallion architecture principles.
• Configure and troubleshoot Self-hosted Integration Runtime including setup, scaling, networking, and security.
• Utilize Azure DevOps for CI/CD pipelines (YAML), build/release automation, repository management, branching strategies, and code reviews.
• Maintain code quality and adhere to established engineering standards and practices.
• Track and manage technical issues using Azure DevOps, GitHub, or other federal Agency-approved tools.
• Assist with Azure networking configurations including VNET, private endpoints, and firewalls.
• Support implementation of security controls aligned with Zero Trust principles and federal security requirements.
• Integrate analytical and AI/ML solutions into existing federal agency system architectures.
• Work collaboratively in Agile teams, participating in sprint planning, stand-ups, reviews, and retrospectives.
• Contribute to technical documentation including design documents, current/future state diagrams, and user guides.
• Communicate progress and issues clearly to teammates and project managers.

Requirements

• 2+ years of professional software development experience.
• Solid understanding of data warehousing and ETL/ELT patterns.
• Experience with Microsoft Azure, including ADLS Gen2, Azure Synapse Analytics, Azure Data Factory, and Self-hosted Integration Runtime.
• Strong foundational skills in SQL and Java.
• Familiarity with Azure networking including VNET, private endpoints, and firewalls.
• Knowledge of medallion architecture principles.
• Proficiency with Azure DevOps for CI/CD pipelines (YAML), build/release automation, repository management, branching strategies, and code reviews.
• Bachelor’s degree in Computer Science, Information Technology, or related field, or equivalent practical experience.

Preferred Qualifications

• Knowledge of Azure networking and advanced security configurations.
• Experience with CI/CD and DevOps practices in cloud-native environments.
• Exposure to AI/ML integration within enterprise data pipelines.
• Azure certifications or formal training in cloud development.
• Public sector or federal consulting experience.

Skills

• Strong analytical and problem-solving skills with attention to detail.
• Excellent communication skills and ability to work effectively in a distributed team environment.
• Eagerness to learn and grow in a federal consulting environment with mentorship from senior engineers.
• Highly organized, self-motivated, and proactive in identifying and resolving issues.

Must be able to pass a federal agency background check and obtain a government-issued ID badge prior to starting work.