Role Description We are looking for a Mid/Senior Data Engineer to join our Data Engineering practice and help clients build modern data foundations on Databricks and AWS. - Design and build data pipelines that extract from enterprise ERP systems, transform through medallion architectures, and deliver governed, AI-ready data products. - Work directly with client subject-matter experts to understand business domains, validate data models, and ensure the platform is production-grade from day one. - Current engagements involve regulated manufacturing environments where data governance, quality management, and traceability are essential. - This is a fully remote role with collaboration across distributed teams and daily overlap with the US Eastern Time Zone. Qualifications - 4–7+ years of experience as a Data Engineer or in a closely related role. - Strong programming skills in Python, including PySpark. - Solid SQL skills including complex analytical queries against large enterprise databases. - Hands-on experience with Databricks: Delta Lake, Unity Catalog, Databricks Workflows, and SQL Warehouse. - Working knowledge of AWS core services: S3, IAM, VPC, and networking fundamentals. - Experience building ETL/ELT pipelines that extract from enterprise ERP or transactional systems (Oracle, SAP, Microsoft Dynamics, or similar). - Strong understanding of data modeling, medallion architectures, and dimensional design. - Experience with data quality frameworks: validation rules, anomaly detection, and exception handling. - Experience using AI and LLM tools to accelerate engineering workflows — including deriving data contracts, mapping specifications, and schema documentation from database metadata and limited business context. - Comfortable collaborating directly with business stakeholders and subject-matter experts, not just engineering teams. - Ability to participate in technical discussions, code reviews, and architectural decisions with confidence. - Reliable high-speed internet and ability to work effectively in a remote-first environment. - Daily overlap with US Eastern Time Zone. Requirements - Familiarity with Oracle E-Business Suite table structures and data patterns (INV, PO, BOM, WIP modules). - Exposure to manufacturing domain concepts: bills of material, work orders, production routing, inventory management. - Experience with dbt for data transformation and data product development. - Hands-on experience with data governance and catalog tooling (Unity Catalog, AWS Glue/Datazone, Apache Atlas, or similar). - Multi-system data integration or ERP consolidation experience, reconciling different source schemas into a unified canonical model. - Spec-driven or contract-driven development methodology, YAML specifications, schema validation, data contracts. - Experience in medical device, pharmaceutical, or other regulated manufacturing environments. - Databricks Asset Bundles and CI/CD automation for data platform deployments. - Familiarity with Apache Iceberg or Delta Lake UniForm for open table format interoperability. - Experience supporting AI/ML workflows in production: feature engineering, model serving integration, or AI-ready data product design. Benefits - Building data foundations that power AI, analytics, and operational decision-making for manufacturing enterprises. - Working directly with domain experts to understand how real businesses operate, not just pushing data through pipes. - Solving multi-system integration challenges where no two ERPs store data the same way. - Designing platforms with governance, observability, and data quality built in from the outset. - Contributing to a reusable platform accelerator that will be deployed across multiple client engagements. - Raising the bar for how data engineering is done: spec-driven, tested, version-controlled, and production-grade.

• Build and operate production-grade ingestion pipelines from core clinical, operational, and third-party systems into our Databricks lakehouse • Develop and maintain dbt models that turn raw data into clean, well-documented, analytics-ready datasets • Establish data quality, testing, and monitoring practices that make pipelines reliable and trustworthy • Help shape ingestion patterns and architecture standards alongside the Principal Data Engineer • Enable company-wide metrics for care outcomes and operations • Collaborate with cross-functional leads to develop and iterate on a suite of core operational dashboards, ensuring teams have the self-service tools they need to track company metrics and outcomes. • Design, build, and operate production data pipelines across clinical, operational, and third-party systems using API-based ingestion, Change Data Capture (CDC), and event- or webhook-driven patterns • Build and maintain transformation layers in dbt, including tests, documentation, and reusable models • Develop and refine core analytical and longitudinal data models used across the company • Implement testing, monitoring, and observability to ensure data quality, pipeline reliability, and system performance • Apply strong engineering fundamentals to improve the scalability, performance, and cost-efficiency of data systems on AWS and Databricks • Partner with Product to support metric definitions, outcome measurement, and reporting needs • Contribute to engineering standards, code review, and a culture of knowledge sharing and continuous improvement • Partner with business, product, and engineering stakeholders to design and build intuitive data visualizations and dashboards that drive actionable insights and program visibility.

• Design and build the CDP from scratch: data ingestion, identity resolution, unified profile, activation. • Establish a multi-tenant architecture with data isolation by client and by state. • Build the AI enrichment layer: segmentation, predictive models (CLV, churn, propensity, next-best-product), and LLM-based preference enrichment. • Ensure privacy-by-design and compliance in a regulated vertical. • Work cross-functionally with product, engineering, marketing, and clients.

Role Description This exciting role will give you breadth of experience across the data activation and digital analytics landscape. In this role you will be responsible for applying audience strategies to paid media campaigns, transforming performance data into actionable insights that inform targeting, optimisation, and commercial outcomes. This includes measuring and analysing activated audiences, supporting paid media optimisation, and managing financial processes related to audience activation and billing. Responsibilities - Data & Audience Strategy - Work with planning teams to turn campaigns into targetable audiences using best-in-class platforms. - Apply audience strategies to paid media campaigns across platforms. - Support activation of first‑, second‑, and third‑party audiences in alignment with campaign objectives. - Translate audience performance insights into optimisation recommendations for planning and activation teams. - Ensure audience strategies are effectively implemented and measured across paid media executions. - Report on outcomes to ensure audience strategies meet and exceed client objectives and goals. - Finance Process & Invoicing Support - Support financial processes related to audience activation within paid media campaigns. - Track activated audience volumes, usage, and delivery to ensure accurate billing inputs. - Assist with preparation, validation, and reconciliation of invoices related to activated audiences. - Partner with finance, operations, and activation teams to ensure alignment between audience delivery, campaign performance, and invoicing. - Investigate and resolve discrepancies related to audience activation costs or billing. - Maintain clear documentation and reporting to support financial accuracy and audit requirements. Qualifications - Graduate of a university or college‑level media, marketing, advertising, or related program. - Strong numerical and analytical skills with an interest in data‑driven media activation. - Ability to interpret campaign and audience performance data and translate it into action. - Effective written and verbal communication skills. - Ability to cope under pressure and deliver to tight deadlines autonomously. - Nice‑to‑Haves: - Experience with or knowledge of paid media platforms, ad servers, or audience activation tools. - Familiarity with ad operations and ad‑tech platforms. - Exposure to audience data, segmentation, or targeting strategies. - Exposure to financial reconciliation, invoicing, or operational processes within media environments. Requirements - Accuracy of audience performance and financial reporting. - Effective application of audience strategies to paid media campaigns. - Improved efficiency in reporting and invoicing processes. - Quality and actionability of insights and optimisation recommendations. - Improved paid media and audience activation performance. Benefits - Work Your World program enabling you to experience working from anywhere in Canada or overseas for up to 6 weeks a year. - Extended long weekends throughout the year with an additional day off each long weekend. - Wellness & Tech benefits to support what’s most important to you. - Birthday leave. - Extensive Learning & Development opportunities, including more than 15,000 learning programs via our online learning platform as well as a Professional Development Allowance. - Local and Global Mobility within the Publicis Groupe network.