Senior Software Engineer (Python, ETL)

TL;DR

Senior Software Engineer (Python, ETL): Developing and scaling Master Data Management (MDM) and ETL ecosystems with an accent on high-performance data pipelines and data quality rules. Focus on optimizing PostgreSQL queries, implementing AWS Glue jobs, and mentoring junior developers to ensure architectural excellence.

Location: Hybrid; must be based in or near Irving, TX or Stamford, CT

Salary: $100,000 - $154,000

Company

A global research and advisory firm that provides objective business and technology insights to enterprise leaders worldwide.

What you will do

• Lead the development and deployment of complex data pipelines using AWS Glue, Python, and SQL.
• Act as the primary technical expert for Ataccama, configuring advanced matching, merging, and data quality rules.
• Provide daily guidance and conduct deep-dive code reviews for junior developers to ensure best practices.
• Proactively identify and resolve bottlenecks in PostgreSQL queries and Glue jobs to optimize cloud costs.
• Manage operational resilience during critical zones such as environment refreshes and tool upgrades.

Requirements

• 5+ years of experience in Data Engineering, with a strong focus on ETL and AWS Cloud.
• Expertise in AWS Glue (Spark), SQS, and Lambda.
• Advanced SQL and PostgreSQL skills, including the ability to optimize complex stored procedures.
• Proficiency in Python for data manipulation and automation.
• Strong experience with Git (Bitbucket) workflows and CI/CD pipelines.
• Bachelor’s degree in Computer Science or a related technical field.

Nice to have

• Hands-on experience with Ataccama or similar MDM tools (Informatica, Reltio).

Culture & Benefits

• Hybrid work environment combining home flexibility with office collaboration.
• Competitive compensation including a 401K corporate match and Employee Stock Purchase Plan.
• Comprehensive medical, dental, and vision insurance plans.
• Generous paid time off (20+ days) plus holidays and floating holidays.
• Extensive professional development through leadership courses, technical certifications, and tuition reimbursement.