Sr. Data Engineer

About the Role

Key Responsibilities

• Design, build and own production data pipelines with tools such as Apache Airflow, Matillion and SSIS, ensuring robust orchestration, auto scaling and fault tolerance
• Integrate data across heterogeneous systems (ERP, CRM, e-commerce, IoT and third-party APIs) using REST/GraphQL, Kafka, CDC tools, SFTP and event-streaming patterns
• Develop and evolve data foundation architectures (Redshift, SQL Server) for both batch and real-time use cases
• Collaborate with Analytics, BI and Data Science teams to deliver reusable semantic models powering Qlik, Power BI and Excel
• Champion engineering excellence through CI/CD for data code, infrastructure-as-code (Terraform/CDK), Git-based workflows and peer code reviews
• Perform root-cause analysis and optimization of SQL, Python and integration workflows
• Partner with platform, security and DevOps teams to align on governance, cost control and compliance
• Ensure reliability and performance of data pipelines by monitoring workflows, conducting root cause analysis of failures, and implementing alerts and recovery strategies

Requirements

• 5+ years of hands-on data engineering experience, including ownership of mission-critical pipelines in production
• Experience designing dimensional and domain-driven data models to support BI and self-service analytics
• Deep expertise with SQL (T-SQL, Redshift SQL) and performance tuning for large-scale analytics workloads
• Hands-on experience with Git for version control and GitHub Actions for CI/CD automation
• Demonstrated ability to lead projects, influence cross-functional stakeholders and elevate engineering standards
• Proficiency with modern ETL/ELT and orchestration frameworks (Airflow, AWS Glue, Matillion, SSIS) and at least one cloud platform (AWS preferred)
• Strong understanding of integration patterns-batch, streaming, CDC-and technologies such as Kafka, Kinesis, Debezium or Azure Event Hubs
• Proficiency in Python (Pandas, PySpark) for data transformation and automation; familiarity with Scala or Java is a plus
• Solid grounding in data security, privacy and governance (encryption, IAM, RBAC, PII handling, GDPR/CCPA awareness)

Nice to Have

• Familiarity with Scala or Java
• Experience with cloud platforms other than AWS

Qualifications

• Relevant experience supporting mission-critical data pipelines in production

Benefits & Perks

• Salary range between $102,500 - $143,500 depending on experience and skillset
• Bonus eligibility
• Paid leave for new parents
• Medical/dental and vision coverage (EPO, PPO, HSA)
• 401(k) retirement plan with company contribution
• Flexible benefits
• On-site preschool for employees' children
• On-site employee gym
• Generous employee discount
• Casual dress code