Senior Data Engineer

🌎 Location: Remote within the US/Canada

⬆ Reporting Into: VP, AI Operations

💰Compensation: $110,000-$130,000 base salary, based on qualifications and experience.

 

About Ceros

At Ceros, we believe that creating powerful digital experiences is essential for helping organizations tell their stories and differentiate their brands. In a world where buyers are inundated with endless digital noise, it’s critical for brands to deliver experiences that inspire, educate, and make a lasting impact on the audiences that matter most.

Our no-code content creation platform empowers businesses to transform the buying journey with rich, interactive experiences that capture the attention of buyers and drive enduring business outcomes. The platform makes it faster, easier, and more cost-effective to create premium digital experiences, allowing businesses to scale it across their go-to-market programs.

Today, Ceros powers some of the most engaging experiences on the web. In 2023 alone, interactive content created with Ceros — from websites to landing pages and pitch decks to case studies— was viewed more than half a billion times, with over 3 million comments added using MarkUp, our visual collaboration tool.

Working at Ceros means making an impact at scale. Our platform supports leading brands including Workday, Colliers, Getty, McKesson, and McKinsey. Ceros is backed by top-tier investors, including Sumeru Equity Partners, Grotech Ventures, and Greycroft.

The Role

Ceros is a dynamic and innovative organization focused on optimizing internal operations across Sales, Customer Success, and Finance through data-driven solutions. Our Ops Engineering team builds and maintains the data infrastructure and pipelines that power business intelligence, reporting, and automation.

We are a small but highly technical team with a strong foundation of experienced software and data engineers. As we expand our data capabilities, we are looking for a self-sufficient Senior Data Engineer to take ownership of our data warehouse, ETL processes, and data integrations.

This role will be responsible for building and maintaining scalable, efficient data pipelines that integrate data from multiple business systems. While this role will collaborate with our AI Ops software engineers, the primary focus will be on data infrastructure, ETL development, performance optimization, and governance to ensure our data is reliable, well-structured, and accessible for analysis and reporting.

We prioritize scalability, performance, and automation to streamline data operations and support informed decision-making across the company.

Key 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.

Practical stuff we anticipate you having

Must-Have:

• 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 work