Cloud Data Architect & Lead Engineer

Publicis Health Media; Philadelphia (Philadelphia County); On-site; USD 112,000 - 161,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

Disability insurance

401K

Parental leave

Tuition reimbursement

Flexible time off

Job summary

Publicis Health Media seeks a skilled data engineer to lead the design and implementation of scalable data architectures across cloud platforms (AWS, Azure) for analytics and AI use cases. You will architect end-to-end pipelines, govern data quality, and collaborate with BI teams to deliver reporting and dashboards.

The role requires deep SQL/ETL expertise, experience with Snowflake/Databricks, and strong knowledge of data warehousing principles.

Qualifications

• BS Degree in Computer Science, Information Technology or related field preferred
• Minimum of 5+ years of experience developing large scale complex database solutions
• Demonstrated experience with BI database design
• Ability to track and resolve database related incidents as well as requests
• Strong understanding of database structures, theories, principles, and practices
• Strong understanding of ETL and data warehouse principles
• Good interpersonal, written and oral communication skills
• Technical documentation skills
• Self-motivated and detail-oriented
• Ability to prioritize and execute tasks in a team-oriented, high-pressure environment

Responsibilities

• Design and implement scalable data architecture across cloud platforms (e.g., Snowflake, Databricks)
• Define enterprise data models, schemas, and standards to support analytics, reporting, and AI/ML use cases
• Architect end-to-end data pipelines for ingestion, transformation, and delivery of structured and unstructured data
• Oversee development and optimization of ETL/ELT processes using SQL, Python, and Spark
• Drive performance tuning across queries, pipelines, and storage to improve scalability and efficiency
• Establish best practices for database design, indexing, and query optimization
• Define and enforce data governance standards, including data quality, lineage, metadata, and access control
• Ensure data integrity, consistency, and compliance with security and privacy requirements
• Design and support scalable data products and reusable data assets aligned to business and client needs
• Partner with BI teams to enable reporting and dashboarding solutions (e.g., Tableau, Power BI, Datorama)
• Support AI and advanced analytics initiatives through well-structured, accessible data
• Partner with cross-functional teams to translate business requirements into technical solutions
• Provide architectural guidance and mentorship to data engineers and analysts
• Act as a key stakeholder in resolving complex data challenges and recommending improvements to the data ecosystem
• Establish monitoring and performance standards for data pipelines and platforms
• Ensure reliability of data processes, including handling failures and optimizing long-running jobs
• Define SLAs and operational best practices for data availability and performance
• Tools:Data Platforms: Snowflake, DatabricksLanguages: SQL, Python, Spark (PySpark), JavaETL / Integration: SSIS, APIsBI & Analytics: Tableau, Power BI, Datorama (MCI)Cloud: AWS, Azure

Skills

SQL

ETL

Data warehouse

JSON

XML

Parquet

REST API

Java

C#

R

Python

Big data

Education

BS Degree in Computer Science

Tools

Snowflake

Databricks

SSIS

APIs

Job description

Publicis Health Media seeks a skilled data engineer to lead the design and implementation of scalable data architectures across cloud platforms (AWS, Azure) for analytics and AI use cases. You will architect end-to-end pipelines, govern data quality, and collaborate with BI teams to deliver reporting and dashboards.

The role requires deep SQL/ETL expertise, experience with Snowflake/Databricks, and strong knowledge of data warehousing principles.