IXIS is seeking a senior-level Data Analytics Engineer to manage and evolve data ingestion, sanitation, and transformation pipelines, handling complex client data to create metrics and segments for data visualization products.
Requirements
- 3-5 years of experience building scalable, reliable data pipelines and data products in a cloud environment (AWS preferred).
- Deep understanding of ELT processes and data modeling principles.
- Strong programming skills in Python (or similar scripting languages).
- Advanced SQL skills and intermediate to advanced relational database design experience.
- Familiarity with joining large behavioral datasets like Adobe and GA4 clickstream data.
- Experience with dbt or other transformation-layer tools.
- Familiarity with Docker containerization and orchestration.
Responsibilities
- Build enterprise-grade batch and real-time data processing pipelines using AWS with a focus on serverless architectures.
- Design and implement automated ELT processes to integrate disparate datasets.
- Work across multiple teams to ingest, extract, and process data via Python, R, zsh, SQL, REST, and GraphQL APIs.
- Join and transform clickstream and CRM data into meaningful metrics and segments for visualization.
- Create automated acceptance, QA, and reliability checks for business logic and data integrity.
- Design appropriately normalized schemas and determine when to use SQL vs NoSQL solutions.
- Optimize infrastructure and schema design for performance, scalability, and cost.
Other
- This is a hands-on individual contributor (IC) role.
- You will be expected to lead by example through high-quality design, coding, and problem-solving and contribution to technical direction.
- You will be complementing an experienced team lead and will collaborate with other team members while contributing your own perspective and best practices.
- We are particularly interested in candidates who have seen different ways of doing things and can help us evolve by improving our data quality, scalability, and overall pipeline performance.
- This is a high-impact role where you’ll help shape our technical direction, improve existing systems, and introduce new tools and workflows to make our data products even better.
