Senior Data Engineer

Real ChemistryNew York, NY
2h$120,000 - $145,000Hybrid

About The Position

At Real Chemistry, making the world a healthier place isn’t just an aspiration—it’s our everyday reality. Our drive to transform healthcare is informed by our blend of deep scientific expertise, human-centred creativity, and AI-driven insights, fostering a unique environment where innovation thrives and our people are impact-obsessed. As a global agency, we provide a full suite of services across healthcare communications and marketing to our clients, including top players in the pharmaceutical and biotech industries. Our #LifeatRealChem culture is rooted in our people—we believe we are best together and are committed to excellence for both our clients and colleagues. Whether you're a seasoned professional or just starting your career, if you share our passion for healthcare and connection, we invite you to explore our opportunities. Discover your purpose. Embrace innovation. Experience #LifeatRealChem. Spring & Bond, a part of Real Chemistry, is a digital media agency and consultancy helping pharmaceutical and medical device manuf]acturers build robust, omnichannel-enabled media executions for both HCP and consumer audiences. Our focus is on client empowerment through services like customer journey planning, media strategy & activation, technology evaluation, in-house capability development, and training. We are looking for a Senior Data Engineer to help drive the design, build, and scale of our data infrastructure. This role will be responsible for architecting and maintaining multi-cloud data platforms, optimizing ETL pipelines, and ensuring data quality and availability across the organization. As a senior member of the Data Engineering team, you will notonly deliver hands-on technical solutions but also mentor junior engineers, guide best practices, and help shape the direction of our data engineering capabilities.

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.

Nice To Haves

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

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.

Benefits

  • Real Chemistry offers a comprehensive benefit program and perks, tailored to your region.
  • Globally, this includes offices in our key markets with free snacks to keep you running all day long, generous holiday and paid time off, options for private medical, dental, and vison plans, and support in saving for the future.
  • Other perks include mental wellness coaching and support and access to more than 13,000 online classes with LinkedIn Learning.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service