ETL Developer - RJLA

We are seeking experienced ETL Developers to design, build, and maintain data integration solutions for our clients across multiple locations. You will move and transform data between enterprise systems, ensure data quality and reliability, and work closely with data teams, analysts, and client stakeholders. Key Responsibilities

• Design, develop, test, and deploy ETL/ELT processes and data pipelines
• Extract data from multiple sources (databases, flat files, APIs, legacy systems) and load it into data warehouses and data marts
• Analyze business and data requirements and translate them into technical mapping and transformation specifications
• Write and optimize complex SQL queries, stored procedures, and scripts
• Monitor, troubleshoot, and tune ETL jobs for performance and reliability
• Implement data validation, cleansing, and quality checks, along with error handling and logging
• Schedule and automate data workflows and support production batch processing
• Ensure data handling meets security requirements and applicable government standards
• Collaborate with data architects, DBAs, BI developers, and client stakeholders
• Document data flows, mappings, source-to-target specifications, and operational procedures

• Proven experience supporting government clients (federal, state, or local agencies)
• 5+ years of professional ETL development experience
• Strong hands-on experience with ETL tools such as Informatica, SSIS, Talend, DataStage, or similar
• Advanced SQL skills and solid experience with relational databases (SQL Server, Oracle, PostgreSQL)
• Strong understanding of data warehousing concepts, including dimensional modeling and star/snowflake schemas
• Experience with data profiling, data quality, and data migration projects
• Familiarity with secure data handling and compliance frameworks (e.g., NIST, FISMA, CJIS, HIPAA)
• Strong analytical, troubleshooting, communication, and documentation skills
• Ability to work independently on-site or hybrid at assigned locations

Preferred Qualifications

• Scripting experience (Python, PowerShell, or shell scripting)
• Experience with cloud data platforms and services (AWS Glue, Azure Data Factory, Snowflake, Redshift)
• Experience with BI/reporting tools (Power BI, Tableau, SSRS) and workflow schedulers (Control-M, Airflow)
• Relevant certifications (e.g., Informatica, Microsoft, AWS/Azure Data Engineer)
• Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent experience)
• Ability to obtain a government security clearance or pass a background check