Senior Data Engineer

Real Chemistry is a global agency focused on transforming healthcare through deep scientific expertise and AI-driven insights. The Senior Data Engineer will design, build, and scale data infrastructure, ensuring data quality and mentoring junior engineers.

Responsibilities:

• Architect and optimize robust, scalable ETL pipelines and workflows to ingest, transform, and deliver data from multiple sources
• Ensure data integrity and governance through validation frameworks, schema design, and proactive monitoring
• Leverage advanced SQL and programming skills to extract, transform, and analyze data efficiently
• Develop automation using Python, Pandas, AWS Lambda, and related tools to improve operational efficiency
• Design and manage data platforms, including Snowflake, Athena, Redshift, BigQuery, and other cloud-based solutions
• Collaborate cross-functionally with analysts, strategists, and business leaders to translate business requirements into technical solutions
• Mentor and coach junior data engineers, setting standards for code quality, documentation, and best practices
• Lead vendor and partner integrations, ensuring seamless data delivery and alignment with internal standards
• Communicate effectively with both technical and non-technical stakeholders, providing clear insight and direction
• Drive innovation, identifying opportunities to improve performance, scalability, and usability of our data systems

Requirements:

• Bachelor's degree in Computer Science, Data Engineering, or related field—or equivalent experience
• 5–7+ years of experience in data engineering, with proven success building and scaling data systems
• Expert knowledge of SQL and Python, including performance optimization and data manipulation libraries (e.g., Pandas)
• Strong experience with AWS data products (S3, Redshift, Athena, Lambda) and familiarity with multi-cloud environments
• Deep understanding of data modeling, schema design, and best practices for large-scale data solutions
• Demonstrated ability to design secure, reliable pipelines and troubleshoot complex issues
• Experience leading projects and mentoring other engineers
• Excellent communication, critical thinking, and problem-solving skills
• Comfortable managing multiple priorities and delivering in a fast-paced environment
• Experience with data transformation and productivity tools (dbt, Jinja, etc.)
• Familiarity with Snowflake (Notebooks, Worksheets, VS Code plugin)
• Knowledge of data visualization platforms such as Looker Studio or similar BI tools
• Exposure to digital marketing analytics and measurement frameworks