Associate Director, Data Operations

Summary

Join Braeburn as the Associate Director, Data Operations and partner with stakeholders to design and build analyses for commercial initiatives and brand optimization. Your primary focus will be developing and managing Braeburn's data warehouse in AWS Redshift, supporting report and analytics development in AWS QuickSight. You will translate business rules into SQL using dbt, build analyses using Python and SQL, and ensure data quality. This role requires strong SQL, dbt, and data warehouse experience. The position is a hybrid role based in Plymouth Meeting HQ or remote.

Requirements

• Have hands-on experience with dbt
• Have hands-on experience with analytical data warehouses (Redshift or Snowflake)
• Possess a Bachelor's degree or equivalent industry experience
• Have 7+ years of data warehouse or analytics engineering experience with at least 2 years of pharmaceutical Commercial Operations experience
• Have experience with common pharmaceutical industry data sources (such as IQVIA, Symphony Health, Specialty Pharmacies, Specialty Distributors)

Responsibilities

• Work comfortably with SQL, Git, dbt, and the command line
• Translate business rules into SQL to be used via dbt to build the data warehouse
• Use Python and SQL to build new analyses and support existing ones
• Ensure data quality and integrity within the data warehouse and downstream systems
• Maintain inbound and outbound data pipelines
• Drive change in the organization through surfacing of data insights to stakeholders

Preferred Qualifications

• Have hands-on experience with AWS
• Be familiar with dimensional data modeling (Kimball)
• Possess attention to detail with the ability to perform critical review of various types of data
• Have clear and direct communication skills about complex, technical topics
• Have a track record of working autonomously and asynchronously
• Have experience with machine learning