PHM is the leading health media agency in the US. We are designed for—and dedicated to—delivering best-in-class solutions that connect people with meaningful health and wellness solutions every day. Guided by our genuine passion for health and wellness, our work across the entire media ecosystem helps real patients navigate the most pivotal moments of their healthcare journeys.

At PHM, we sit squarely at the intersection of Publicis Health, the largest Healthcare Communications network in the world, and Publicis Media, the number one buyer of media in the US. This gives us access to talent, technology and data to help us deliver the market-leading solutions that give our clients true competitive advantage. 

While we have grown to be the No. 1 agency in our industry, at heart we’re still a startup. It’s that energy and spirit of innovation that allows us to create bold and meaningful “health media firsts” for our clients, and to do it all with #phmlove.

At Publicis Health, we are united around one purpose: to create a world where people are equipped and motivated to take control of their health. We transform healthcare marketing and communications into healthcare engagement. We believe healthcare marketing is healthcare, fostering healthy conversations, healthy behaviors and healthy people.

A Data Engineer will be responsible for the design, development, implementation and on-going support in building platforms to support growing demands for data-driven solutions. Must be able to work in a fast-paced environment on multiple projects simultaneously, including both enhancements as well as new project development. The candidate must be a self-starter with a sense of urgency and a commitment to quality and professionalism.

Your day to day will include:

·       Maintain professional relationships with internal (PHM) and external (client team, partner agencies/consulting groups) stakeholders by communicating effectively and delivering on all data needs

·       Analyze business requirements and partner with Business Intelligence (BI) team to provide a strategic solution

·       Collaborate with Senior Data Architects / Engineers to assess data management and architecture demands, identify functional requirements to ensure systems are designed, developed, and implemented to solve for business challenges and opportunities in the most efficient and cost-effective way.

·       Advanced database administration and development including stored procedures, user defined functions, triggers and ETL packages as well as security and roles

·       Optimization and tuning of existing SQL stored procedures to improve performance

·       Troubleshoot database issues, identify root causes, and implement optimal solutions

·       Extract, transform, and load data from multiple data sources using ETL tools

·       Design, Build, Test, Debug, Monitor, and Troubleshoot ETL and software processes

·       Recommend solutions to existing or anticipated issues

·       Follow implementation standards

·       Serve as an escalation point for any issues that may arise

·       Develop documentation and transfer of knowledge

This roll will support:

·       As we execute on the behalf of the client, manage and ensure the accuracy of the many internal data sources and (where applicable) third-party vendors/data streams that comprise our custom measurement platform while keeping workstreams on task within the established timelines and delivery dates

·       The Business Intelligence (BI) team’s ability to synthesize data available into insights/recommendations about the success of our programs in transforming the behavior of our target audience (most likely healthcare professionals, patients/prospects or a combination of the two) while identifying opportunities for program optimization and enhancement

·       BI Senior Leadership to utilize the aforementioned insights/recommendations as the foundation for presentations, reports, assorted client deliverables in either a face-to-face setting or via WebEx/teleconference

·       Creating novel new product and analytical offerings in coordination with BI and Publicis Health leadership teams

• Minimum Bachelor’s Degree in Computer Science, Information Technology, or its equivalent

Data Engineering: 

• Create and execute scalable, automated, cloud-based data pipelines linking diverse data sources and performing ETL. Examples of data sources are flat files from SFTP, relational data warehouses (MS SQL Server, AWS Redshift, Snowflake) and data lakes (flat files and Parquet). 
• Advanced knowledge of Data wrangling on Big Data through Python, Pandas. Working knowledge of Apache Spark (Databricks) a plus. 
• Hands on experience of ETL/ELT on public clouds (AWS, Azure, GCP). 
• Azure SQL advanced querying, creating stored procedures, Indexes etc.
•  

Additional skills:

• Knowledge of data architecture and modeling (schemas, ERDs)
• Knowledge of producing and consuming Restful APIs. Ability to define API contracts.
• Strong Client management skills

Bonus skills: 

• Data Visualization through Tableau and PowerBI
• Knowledge of data warehousing on Snowflake
• Knowledge of media and advertising industry

All your information will be kept confidential according to EEO guidelines.