Senior ETL Software Engineer

Company: Synectics for Management Decisions Inc
Location: Alexandria
Posted on: April 14, 2025

Job Description:

We are seeking a Senior ETL Software Engineer to support a federal program in Alexandria, VA. Ideal candidate must be able to design, develop, and maintain ETL processes, ensuring data accuracy and performance for analysis and reporting, often with a focus on data warehousing and data lake architectures. Hybrid work is required for this position and must be able to work onsite as necessary.Key Responsibilities and Skills:

• ETL Process Design and Development:--- Design, develop, and maintain ETL processes for extracting, transforming, and loading data from various sources.--- Develop and document ETL mappings and workflows.--- Ensure data accuracy, consistency, and quality throughout the ETL process.
• Data Modeling and Architecture:--- Experience in data modeling for data warehousing and data lake architectures, both on-prem and in the cloud.--- Manage all aspects of the data architecture, including models, data staging, and ETL framework.
• Technical Expertise:--- Proficiency in SQL and other programming languages relevant to ETL development.--- Familiarity with various ETL tools and technologies, such as Informatica, Talend, and Apache NiFi.--- Experience with database management systems (RDBMS) and NoSQL databases.
• Collaboration and Communication:--- Collaborate with business stakeholders to understand their needs and requirements.--- Work with other IT personnel and cross-functional teams.--- Provide technical guidance and mentorship to junior team members.
• Problem Solving and Leadership:--- Ability to identify and resolve complex technical issues.--- Lead the design, implementation, and development of ETL processes.--- Stay informed about industry trends and best practices in ETL and data management.
• Other Responsibilities:--- Implement and monitor data quality checks.--- Optimize ETL processes for performance and scalability.--- Adhere to secure coding practices.--- Participate in code reviews and knowledge sharing.Experience Requirements:
• 8 years of ETL experience. Extensive ETL and data-pipeline experience using tools such as Alteryx and AWS Glue.
• Excellent coding skills using standard Data Science tools, including Python, R, Linux/Unix Command Line, and Shell Scripting.
• Bachelor's degree in Engineering, Data Science, Information Technology, or related field of study.
• Experience working with external clients.
• Experience working on federal government IT programs and projects.
• Must be able to communicate effectively.
• Must be able to work independently and work well on teams.Clearance Requirements:--- Must have a Public Trust Clearance.Desired Skills:

• Master's Degree in Computer Science, Engineering, Data Science, Mathematics, Physics, or another quantitative discipline.Synectics is an Equal Opportunity Employer. We offer a competitive salary and an impressive full benefits package that includes employee medical and dental, 401k, company-paid life and short/long-term disability insurance, and paid leave. We also provide an environment that supports professional development and growth.
  #J-18808-Ljbffr

Keywords: Synectics for Management Decisions Inc, Bethesda , Senior ETL Software Engineer, IT / Software / Systems , Alexandria, Maryland