Director, Data Engineering (Virtual First)

Job Description

BPD is looking for a dynamic and experienced Director, Data Engineering to join our growing Data Solutions & Analytics team. The role will lead the data integration process across products and systems, playing a critical role in designing, developing, and maintaining complex data pipelines and driving technical innovation. Responsibilities include defining technical vision and data integration strategy, and ensuring the efficient execution of our data pipelines on our data warehouse (Snowflake) and other platforms including Sisense and Tableau. The ideal candidate will have proven experience in leading data engineering for a marketing or advertising firm, and a passion for healthcare marketing. You will collaborate cross-functionally with project management, product strategy, analytics, and account teams to ensure the success of our data solutions & analytics products, operating as a core team lead. The role will manage a small team, fostering growth across all department roles, and will operate for many tasks as an individual contributor. In addition, the role will manage third-party consultants and vendor relationships with critical data partners.

Required Skills & Experience

Responsibilities

1. Data Infrastructure Management:
   Design, implement, and maintain data architectures and pipelines to integrate and process data from various sources, including advertising campaigns, consumer databases, health claims data, and raw data sets from healthcare systems.
2. Utilize a range of technologies including, but not limited to Python and SQL to design, develop and maintain complex data integrations with clients and third-party partners, including digital marketing platforms, and CRM systems.
3. Ensure the integrity, accuracy, and security of data across all systems and platforms.
4. Implement ETL (Extract, Transform, Load) processes to ensure data is accurately transformed and loaded into the data warehouse.
5. Work to streamline, evolve and improve the effectiveness of our marketing firm’s approach to data structure.
6. Adopt service grouping frameworks to client consumer healthcare encounter data sets.
7. Manage data clean room environments, ensuring secure data collaboration, and facilitating privacy-preserving data analysis across multiple parties.

1. Data Warehouse Management:
   Oversee the management and optimization of the Snowflake data warehouse.
2. Develop and maintain ETL processes to support data extraction, transformation, and loading.

1. Data Integration, Analysis & Quality:
   Integrate data from diverse sources and develop data models to support analytical and reporting needs, ensuring consistency and accuracy.
2. Collaborate with data scientists and analysts to develop and implement data-driven solutions.
3. Monitor and maintain data quality by implementing data validation and cleansing processes.
4. Lead all client requirement meetings and provide solutions to stakeholders for data integration workflows.

1. Data Governance and Compliance:
   Oversee the implementation and maintenance of data governance and security best practices in conjunction with data governance stakeholders.
2. Monitor and manage data privacy and security, particularly in relation to PHI & PII.

1. Innovation and Optimization:
   Stay current with emerging technologies and industry trends, continuously seeking opportunities to improve data systems and processes.
2. Optimize data infrastructure for scalability and performance.
3. Provide recommended enhancements to existing processes and systems.

1. Tooling and Technologies:
   Manage and optimize the use of existing data engineering tools and platforms including:
   Snowflake and Big Query for data warehousing and analytics,
   ETL technologies such as SuperMetrics,
   Python or similar programming language for data processing and automation,
   Dataflow for stream and batch processing,
   Agile project management tools such as JIRA or Workamajig.
2. Evaluate and integrate additional tools as needed to support evolving business needs.

Requirements:

1. Bachelor’s or master’s degree in computer science, data engineering, data science, or a related field.
2. 8+ years of experience in data engineering within the digital marketing industry.
3. Proven experience with the tools and technologies listed above.
4. Strong understanding of data architecture, ETL processes, data transformation, data integration and data governance.
5. Knowledge of relational databases and ability to design efficient data models (e.g., star schema, snowflake schema).
6. Strong programming skills in Python for data manipulation, scripting, and automation.
7. Expert with SQL for querying and data transformation.
8. Deep experience and understanding of digital marketing data processes and infrastructure.
9. Proficiency in creating dashboards using tools like Tableau and Sisense.
10. Snowflake, Google Data Cloud or Salesforce certifications preferred, but not required.
11. Excellent communication and interpersonal skills.
12. Ability to work in a fast-paced, dynamic environment and manage multiple priorities.
13. Strong problem-solving skills and attention to detail.
14. Excellent analytical skills and a high degree of business acumen.
15. Outstanding verbal and written communication abilities, combined with exceptional presentation skills.
16. Proven ability in handling concurrent projects with attention to detail and accuracy.
17. Curious and interested in solving multi-dimensional problems.
18. Ability to contribute individually and participate in cross-functional teams with a positive attitude.
19. Exceptional interpersonal skills and ability to create great working relationships at all levels of the agency and with clients.
20. Motivated by the role we play in helping healthcare organizations improve the lives of people they serve.

Company Description

BPD is the home for healthcare’s leading brands. From the nation’s largest, most complex health systems to academic institutions and industry disruptors, BPD ignites greatness with our clients to bring better health to more people. Together, BPD’s more than 160 experts provide innovative solutions and capabilities in brand building, service line promotion, data-driven marketing, strategic communications, and more. For more information on BPD, visit

BPD is proud to be an Equal Opportunity employer. BPD recruits qualified applicants without regard to race, color, religion, gender, age, ethnic or national origin, protected veteran status, physical or mental disability, sexual orientation, gender identity, marital status, or citizenship status.