Associate Director, Data Engineering (BioPharm Communications LLC, New Hope, PA)
Use analytic tools, such as SAS, Python and R, to analyze large data sets and summarize key findings in writing and by visualizing with tables, charts and graphs to illustrate important patterns of health, cost and utilization and their trends over time; Conduct secondary research on the topic being investigated and summarize findings to provide context and information from other sources to add support and explanation for the data findings; Execute ad-hoc analysis in a fast-paced business environment; Provide subject matter expertise on mathematical and statistical methodologies; Proficiently use healthcare claims data, Rx data, and promotional activity data (personal detailing, multichannel marketing, media) using state-of-the-art methods to estimate returns on investment for multichannel promotional campaigns; Identify data sources and build out the company’s data warehouse with third party sources of information; Lead the automation of Daily Data Integrity Checks in Snowflake and Oracle databases using the Talend ETL Tool and create notifications in the form of emails when an automation fails and if there is data discrepancy; Lead and supervise downloading data sets from various sources like Amazon S3, Google Analytics, Trade Desk and external SFTP locations etc. using Talend ETL development tool; Lead development of APIs with cloud services like Veeva Timeline and SFMC; Develop concise, complete, and accurate written information to create analytics plans which define the background, objectives, and methods for upcoming analytic projects; Identify actionable business insights and summarize key implications to business strategy; Organize and coordinate work to manage multiple mid-size projects to meet interim and final deadlines; Provide clear and timely updates to management to communicate progress and status; Coordinate programming documentation including plans, specifications, development, validation, and output finalization associated with analysis datasets, tables, and reports; Work closely with CRM, Account Solutions, Strategic Planning and Creative teams to plan, execute and evaluate a broad range of strategic marketing initiatives and programs; Apply knowledge of data governance best practices; Lead cloud-based projects, including Snowflake & MySQL Data Lakes/Warehouses in AWS, Azure or Oracle; Support and manage advanced analytics projects by applying SCRUM techniques and agile framework; Research on broad knowledge emerging technologies, such as WebAR, AI/ML and its application to our business needs; Hire, evaluate, and supervise data engineer(s); Provide guidance and training as necessary to develop the team; Set performance standards, review performance, and make informed decisions in accordance with all applicable Human Resources policies and procedures. Telecommuting is permitted from anywhere in the U.S. Salary: $120,000 – $136,000 per year.
MINIMUM REQUIREMENTS: Master’s degree or U.S. equivalent in Computer Science, Electrical Engineering, Analytics, Mathematics, Statistics, or a related field plus 5 years of professional experience performing data engineering and statistical analysis of pharmaceutical data (including prescription and medical claims).
Must also have the following: 3 years of professional experience utilizing analytic tools (including SAS, Python and R) to analyze large data sets and summarize key findings in writing; 5 years of professional experience creating tables, charts and graphs to illustrate important patterns of health, cost and utilization and their trends over time; 5 years of professional experience executing ad-hoc analysis and implementing mathematical and statistical methodologies; 3 years of professional experience working with healthcare claims data, Rx data, and promotional activity data (including personal detailing, multichannel marketing, and media) to estimate returns on investment for multichannel promotional campaigns; and 3 years of professional experience working with link tracking, Google Analytics, and marketing attribution.