Note: The job is a remote job and is open to candidates in USA. Publicis Sapient is a leading digital commerce company, trusted by over 4,000 brands worldwide. They are seeking a Senior Analytics Engineer to own the transformation layer between data ingestion pipelines and the business intelligence platform, ensuring raw data is transformed into business-ready models.
Responsibilities
- Own the Transformation Layer
- Design, build, and maintain dbt models that transform raw source data into clean, well-documented, analytics-ready datasets
- Define and enforce dbt modeling standards, naming conventions, and testing practices across the team
- Serve as the primary owner of the transformation layer, creating clear handoffs with upstream ingestion engineers and downstream BI developers
- Proactively identify gaps in data coverage and work with sourcing teams to resolve them
- Accelerate Pipeline Delivery
- Reduce transformation backlogs by building scalable, reusable model patterns that others can extend
- Partner with Airflow/Dagster pipeline owners to ensure transformation DAGs are reliable, well-monitored, and efficient in BigQuery
- Identify and resolve performance bottlenecks in SQL transformations and BigQuery query patterns
- Bridge Engineering and Analytics
- Collaborate with BI developers and the Director of Business Intelligence to ensure Looker data sources are well-modeled and maintainable
- Translate business requirements from stakeholders into reliable data models without requiring BI developers to work around messy upstream data
- Help evolve manual QA processes toward automated dbt testing and data quality monitoring
- Mentor and Set Standards
- Mentor junior and mid-level team members on analytics engineering best practices
- Document data models, lineage, and transformation logic so the team can move faster and onboard new members with confidence
- Contribute to SQL and business logic standards in collaboration with the Director of Data Engineering
Skills
- 5+ years of professional experience in data engineering, analytics engineering, or a similar role
- Expert-level dbt skills including experience building and maintaining production dbt projects at scale including tests, documentation, and incremental models
- Strong SQL and data modeling skills, particularly in BigQuery or another columnar cloud data warehouse
- Experience working across the full data pipeline from raw ingestion to BI-ready models
- Comfort operating with a high level of ownership, autonomy, and accountability
- A natural sense of urgency with an ability to work quickly, efficiently, and accurately within tight deadlines and constantly-evolving project parameters, scope, and goals
- Flexible and adaptable with an ability to work successfully across multiple concurrent projects and competing priorities
- Highly collaborative but independently capable
- Exceptionally organized with a fanatical attention to detail
- Strong written and verbal communication skills, both with technical and non-technical audiences
- Prior experience working alongside the CPG, retail, and/or marketing industries
- Bachelor's degree in computer science, data analytics, information systems, or a related field
- Familiarity with ecommerce, CPG, digital shelf, or retail media network data sources and analytics
- Experience with Airflow or Dagster for pipeline orchestration and Python for data pipeline tasks
- Familiarity with Looker or LookML
- Experience and familiarity with data quality frameworks, automated testing, or observability tooling
Benefits
- Paid Family Care for parents and caregivers for 12 weeks or more
- Monetary assistance and support for Adoption, Surrogacy and Fertility
- Monetary assistance and support for pet adoption
- Employee Assistance Programs and Health/Wellness/Comfort reimbursements to help you invest in your future and work/life balance
- Tuition Assistance
- Paid time off that includes Flexible Time off Vacation, Annual Sick Days, Volunteer Days, Holiday and Identity days, and more
- Matching Gifts programs
- Flexible working arrangements
- ‘Work Your World’ Program encouraging employees to work from anywhere Publicis Groupe has an office for up to 6 weeks a year (based upon eligibility)
- Business Resource Groups that support multiple affinities and alliances
- The benefits offerings listed are available to eligible U.S. Based employees, are reviewed on an annual basis, and are governed by the terms of the applicable plan documents.
- You must be actively employed for 90 consecutive calendar days in order to be eligible for Publicis medical and voluntary benefits.
- You will also be eligible to participate in the Publicis 401(k) Plan after you complete 1,000 work hours in a consecutive 12-month period.
- Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met.
- Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met.
- For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off.
Company Overview