Principal Data Engineer - Data Platform & Ingress

As a Principal Data Engineer, you will help drive the direction of our Data Warehouse and Hybrid Data Lake Infrastructure. You will be hands-on with teammates across all departments, enabling them to access the data and empowering teams to make data-driven decisions about the direction of our business. You will play a pivotal role in owning the infrastructure and code for our data pipelines within our Data Platform, with a focus on handling data at scale. You will be responsible for designing, implementing, and optimizing ingestion pipelines, enabling seamless extraction and loading of data from various sources such as customer warehouses, business systems, and event messaging buses. Movable Ink collects campaign data resulting from billions of requests served each day—come and help us manage and make sense of the massive amount of data we’re ingesting!

Responsibilities:

• Partner with internal operations teams to identify, collect, and integrate data from various business systems, ensuring comprehensive and accurate data capture.
• Design, implement, and maintain robust batch and real-time data pipelines, leveraging tools like Apache Airflow, Apache Flink, and Terraform for IaC.
• Build and optimize Hybrid Data Lake / Data Warehouse infrastructure with solutions like Apache Iceberg for scalable and cost-effective storage.
• Ensure data pipelines adhere to best practices and are optimized for performance, scalability, and reliability.
• Conduct thorough testing of data pipelines to validate data accuracy and integrity.
• Monitor data pipelines, implement telemetry and alerting, troubleshoot any issues that arise, and proactively improve system reliability.
• Establish and track SLAs for data processing and delivery, ensuring timely and reliable access to data for all users.
• Become a mentor for less experienced team members and establish patterns and practices that increase the quality, accuracy, and efficiency of solutions produced by the team.
• Design and implement Change Data Capture (CDC) solutions to support real-time data replication and point-in-time data queries.
• Work with other teams to ensure secure data access and compliance with regulatory requirements (e.g., GDPR, CCPA, etc.).

Qualifications:

• 12+ years of professional experience in data engineering, software engineering, database administration, business intelligence, or related fields, with 8+ years as a Data Engineer focused on cloud-based Data Warehouses(Redshift, Snowflake, Firebolt, BigQuery). We currently use Redshift.
• Deep experience working with multi-petabyte, mission-critical databases, optimizing for high availability, performance, and reliability, informed by a strong understanding of database internals.
• Expert proficiency with Python and SQL, and significant experience building robust data pipelines with these languages.
• Expert proficiency in deploying and managing data pipeline orchestration frameworks such as Apache Airflow or Prefect. We currently use Apache Airflow.
• Significant experience with Infrastructure-as-Code (Terraform) and automating cloud infrastructure management.
• Significant experience with stream processing technologies such as Apache Flink, Apache Kafka, or Apache Pulsar.
• Significant experience in building telemetry, monitoring, and alerting solutions for large-scale data pipelines.
• Significant experience in implementing Hybrid Data Lake / Data Warehouse architectures, with a focus on Apache Iceberg or similar technologies.
• Significant experience in designing and implementing solutions that comply with regulatory requirements such as GDPR and CCPA.
• Experience in Agile/Scrum environments, working with technical managers and product owners to break down high-level requirements into actionable work.
• Excellent communication skills, with the ability to effectively collaborate across technical and business teams.