BPD Advertising
Director, Data Engineering (Virtual First)
BPD Advertising, Nashville, Tennessee, United States,
Required Skills & ExperienceResponsibilities
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.
Work 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.
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.
Requirements:
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.
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 www.bpdhealthcare.com.
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.
#J-18808-Ljbffr
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.
Work 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.
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.
Requirements:
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.
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 www.bpdhealthcare.com.
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.
#J-18808-Ljbffr