Associate Director, Data Engineering, Technology and Data

Associate Director, Data Engineering, Technology and Data

• Full-time

PHM is the leading health media agency in the US. We are designed for—and dedicated to—delivering 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 patients navigate the most important moments of their healthcare journeys.

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.

Overview of Job Responsibility:

Develop and support data products, this resource plays a critical role in the development and maintenance of data solutions and deliverables used by internal and external stakeholders. Design and develop big data solutions built on the Databricks and Azure technology stacks. You will help drive PHM data strategy, managing data pipelines, and ensuring the reliability and scalability of our data platforms. You will report to the Director, Data Engineering.

Responsibilities:

• Design, implement, and maintain scalable data pipelines and architectures using Databricks and Azure technologies
• Create high performance data products by monetizing warehouse and ETL solutions using python, sql and spark
• Build data flow automation to retrieve, transform and load data. Manage data warehouse structure and file storage rules
• Performance tuning and optimization of ETL and database structures. Optimize data infrastructure performance, reliability, and cost-efficiency
• Monitor long running transactions and improve query executions using best practices and methodologies
• Structured and unstructured data
• Real-time, on-demand, batch and varying timing schedules
• Collaborate with cross-functional teams to understand data requirements and deliver innovative solutions
• Develop and enforce data engineering best practices, standards, and policies
• Maintain best practices for handling, storing and using data
• Evaluate and implement new technologies and tools to support data engineering initiatives
• Drive continuous improvement and innovation in data engineering processes

Minimum Requirements:

• Bachelor's degree in Computer Science, Engineering, or a related field; advanced degree preferred
• 5 years experience in a data engineering leadership role, managing teams and complex projects
• Expertise in Databricks (Delta Lake, Apache Spark, Unity Catalog), Snowflake, Azure (Data Factory, Blob), SQL, and Python
• Expertise in Datorama, Tableau, PowerBI
• Strong understanding of data modeling, ETL processes, and data warehousing concepts
• Experience with cloud infrastructure and services, preferably Azure
• Excellent analytical and problem-solving skills
• Effective communication and collaboration skills with the ability to work across teams

Compensation Range: $106,500 - $150,000 annually. This is the pay range the Company believes it will pay for this position at the time of this posting. The Company anticipates the application deadline for this job posting will be 9/1/2024.