• 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.

Role Description New England Life Care is seeking a qualified Data Warehouse Developer to support the design, development, and ongoing maintenance of the organization’s enterprise data warehouse and analytics infrastructure. The Data Warehouse Developer will play a key role in building scalable data warehouse architecture, dimensional data models, and data integration pipelines that support enterprise reporting, analytics, and operational decision-making. - Work closely with business stakeholders, analysts, and application teams to transform data from multiple operational systems into reliable and accessible information for business intelligence platforms. - Possess strong SQL development skills, ETL experience, and expertise in dimensional modeling (star and snowflake schemas) to support reporting and analytics initiatives across the organization. Qualifications - Bachelor’s degree in computer science, information systems, engineering, or other related discipline and/or equivalent combination of education and relevant experience. - 3+-7+ years of experience in data warehouse development. - Strong experience with Microsoft SQL Server or other enterprise relational databases. - Experience developing ETL pipelines using SSIS, Azure Data Factory, or comparable ETL tools. - Demonstrated experience designing and implementing dimensional data models. - Strong experience designing fact tables, dimension tables, surrogate keys, and slowly changing dimensions (SCD). - Advanced SQL development and query optimization skills. - Experience working with large datasets and complex data transformations. - Experience supporting business intelligence and reporting platforms such as Power BI, Tableau, or similar tools. Requirements - Knowledge of HIPAA Privacy and Security requirements. - Working knowledge of federal/state fraud and abuse laws required. - Valid driver’s license with excellent driving record required. Benefits - Health Insurance - Dental Insurance - Vision Insurance - Generous employer-matched 403b savings program - Company paid: Life insurance, Short- and long-term disability insurance - Paid Time Off - And much more! Additional Job-Related Duties - Follow New England Life Care policies and procedures in the normal conduct of company business. - Maintain a strong understanding of software development lifecycle (SDLC) and data engineering best practices. - Ensure professional practices comply with HIPAA Privacy and Security regulations and the organization’s Corporate Compliance Program. - Build strong working relationships across departments and collaborate effectively with business and technical teams. - Demonstrate strong problem-solving skills by identifying data issues, diagnosing root causes, and implementing effective solutions. - Participate in the company Performance Improvement Program and provide recommendations for improvements based on data insights. - Assist in training or mentoring staff on data warehouse concepts, reporting tools, or data access processes as needed. - Participate in ongoing professional development through departmental meetings, technical training, and industry learning opportunities. - Perform additional duties or special projects as assigned by the direct supervisor. - Travel to remote sites as needed.