Director, Data Engineering

Director, Data Engineering

Reports to: AVP or higher
Years Experience: 8+ years
Department: Data Solutions & Analytics
Location: Virtual First

What is Virtual First? At BPD we believe in the balance of the digital and the physical. Our virtual first approach means that we lean into the digital connections - Slack, Zoom, e-mail - as the primary means for getting the job done. It also means that we understand the importance of in-person connection for moments of celebration, collaboration, and education in our physical offices locations in Boca Raton and Nashville. The right balance of digital and physical will vary by role. 

The Position:

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.

The Responsibilities:

Includes, but not limited to the following:

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

• 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

• Ensure the integrity, accuracy, and security of data across all systems and platforms

• Implement ETL (Extract, Transform, Load) processes to ensure data is accurately transformed and loaded into the data warehouse

• Works to streamline, evolve and improve the effectiveness of our marketing firm’s approach to data structure

• Adopt service grouping frameworks to client consumer healthcare encounter data sets

• Manage data clean room environments, ensuring secure data collaboration, and facilitating privacy-preserving data analysis across multiple parties 

Data Warehouse Management:

• Oversee the management and optimization of the Snowflake data warehouse

• Develop and maintain ETL processes to support data extraction, transformation, and loading

Data Integration, Analysis & Quality:

• Integrate data from diverse sources and develop data models to support analytical and reporting needs, ensuring consistency and accuracy

• Collaborate with data scientists and analysts to develop and implement data-driven solutions

• Monitor and maintain data quality by implementing data validation and cleansing processes

• Lead all client requirement meetings and provide solutions to stakeholders for data integration workflows

Data Governance and Compliance:

• Oversee the implementation and maintenance of data governance and security best practices in conjunction with data governance stakeholders

• Monitor and manage data privacy and security, particularly in relation to PHI & PII

Innovation and Optimization:

• Stay current with emerging technologies and industry trends, continuously seeking opportunities to improve data systems and processes

• Optimize data infrastructure for scalability and performance

• Provide recommended enhancements to existing processes and systems

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 for data processing and automation

• Dataflow for stream and batch processing

• Agile project management tools such as JIRA or Workamajig 

• Evaluate and integrate additional tools as needed to support evolving business needs

The Essentials:

Insert the non-negotiable skills & experience needed.

• Bachelor’s or master’s degree in computer science, data engineering, data science, or a related field

• 8+ years of experience in data engineering within the digital marketing industry

• Proven experience with the tools and technologies listed above

• Strong understanding of data architecture, ETL processes, data transformation, data integration and data governance

• Knowledge of relational databases and ability to design efficient data models (e.g., star schema, snowflake schema)

• Strong programming skills in Python for data manipulation, scripting, and automation

• Expert with SQL for querying and data transformation

• Deep experience and understanding of digital marketing data processes and infrastructure

• Proficiency in creating dashboards using tools like Tableau and Sisense

• Snowflake, Google Data Cloud or Salesforce certifications preferred, but not required

• Excellent communication and interpersonal skills

• Ability to work in a fast-paced, dynamic environment and manage multiple priorities

• Strong problem-solving skills and attention to detail

• Excellent analytical skills and a high degree of business acumen

• Outstanding verbal and written communication abilities, combined with exceptional presentation skills

• Proven ability in handling concurrent projects with attention to detail and accuracy

• Curious and interested in solving multi-dimensional problems

• Ability to contribute individually and participate in cross-functional teams with a positive attitude

• Exceptional interpersonal skills and ability to create great working relationships at all levels of the agency and with clients

• Motivated by the role we play in helping healthcare organizations improve the lives of people they serve

The Vision:

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 www.bpdhealthcare.com.

At BPD, our work is rooted in understanding people of all races, ethnicities, gender expressions, sexual identities, abilities, and life experiences. To enable these authentic connections, we cultivate a culture of one-ness that:

1. Celebrates our diversity;
2. Unites us in Purpose; and
3. Leads to the creation of inclusive work that contributes to health equity for all.

We lean into the honest conversations that teach us to recognize that the pursuit of diversity, equity and inclusion is never done and that it is essential to igniting greatness inside our walls and across the healthcare landscape. So we commit to this endeavor not only because it is right and just, but because it is the foundation of brilliant, resonant work for our clients.  

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.