Senior Data Engineer

Summary

Join Ceros' dynamic Ops Engineering team as a Senior Data Engineer and take ownership of our data warehouse, ETL processes, and data integrations. You will build and maintain scalable, efficient data pipelines integrating data from multiple business systems. This role requires strong expertise in SQL, AWS Redshift, and ETL pipeline development using AWS Glue, Matillion, or similar tools. You will collaborate with AI engineers and business stakeholders to enhance data accessibility and reporting. The position offers a competitive salary, remote work flexibility, and excellent benefits. We prioritize scalability, performance, and automation to streamline data operations and support informed decision-making.

Requirements

• 5+ years of experience in data engineering, focusing on AWS Redshift and ETL pipeline development
• Strong expertise in SQL performance tuning, schema management, and query optimization
• Experience designing and maintaining ETL pipelines using AWS Glue, Matillion, or similar tools
• Proficiency in JavaScript/TypeScript, with experience building custom ETL workflows and integrations
• Hands-on experience with Python for data automation and scripting
• Strong understanding of data warehousing best practices, ensuring high-quality, scalable data models
• Experience with data monitoring and alerting tools such as AWS CloudWatch and New Relic
• Ability to work independently in a fast-paced environment, collaborating across teams to support data-driven initiatives

Responsibilities

• Own and lead the management of AWS Redshift, ensuring optimal performance, disk usage, and cost efficiency
• Design and maintain scalable ETL pipelines using AWS Glue, Lambda, and Matillion to integrate data from Mixpanel, CRM platforms, and customer engagement tools
• Optimize SQL-based data transformations and Redshift queries to improve performance and reliability
• Automate data offloading and partition management, leveraging AWS services like S3 and external schemas
• Ensure version control and documentation of all Redshift queries, ETL processes, and AWS configurations through a centralized GitHub repository
• Develop monitoring and alerting for data pipelines using CloudWatch and other observability tools to ensure high availability and early issue detection
• Implement and maintain data quality checks and governance processes to ensure accuracy and consistency across foundational tables
• Collaborate with AI engineers and business stakeholders to enhance data accessibility and reporting for internal teams
• Maintain and optimize BI dashboards in Metabase and HubSpot, ensuring accuracy and efficiency of business reporting
• Manage key integrations between Redshift and external platforms, including Mixpanel, HubSpot, and Census, optimizing data accessibility and performance
• Administer AWS infrastructure supporting Redshift, ensuring efficient resource utilization, IAM security, and cost management
• Automate repetitive data tasks using Python and scripting to enhance data processes and improve team efficiency

Preferred Qualifications

• Experience integrating customer data platforms (e.g., Mixpanel, Segment) and CRM tools
• Familiarity with BI and visualization tools (Looker, Tableau, or similar)
• Knowledge of event-driven architectures and streaming data solutions
• Background in supporting AI-driven automation through data engineering

Benefits

• Stock options
• Premium health insurance*
• 401K matching*
• Paid parental leave: 16 weeks for primary caregivers, 4 weeks for secondary caregivers
• Flexible vacation days
• Paid Sick days
• Stipend for your home office setup
• Excellent gear (Macbook Air, external monitor, etc.)
• Stipend towards experiences in which Cerosians can collaborate, educate, and create social connections with one another
• Unlimited access to co-working spaces around the globe