Senior Analytics Engineer

Role Description

We are seeking a highly skilled and motivated professional to join our client's team, where you will transform raw internal data into trusted datasets, actionable insights, and executive-grade dashboards. This is an exceptional opportunity to own the end-to-end analytics stack, from data ingestion and modeling to pipeline engineering, semantic layer development, and dashboard delivery. You will be instrumental in migrating their analytics environment from a legacy system to a modern cloud platform, designing and building the next generation of data solutions. Your work will directly support operational and strategic decision-making, influencing audiences from frontline teams to senior leadership and board-level stakeholders. This role offers the chance to make a significant impact by delivering robust data products and fostering a data-driven culture.

What You Will Do

• Data Engineering & Platform Migration
  • Design, build, and operate data pipelines across both the current legacy environment and the target modern cloud platform.
  • Ensure data quality, lineage, freshness, reliability, and observability throughout the transition lifecycle.
  • Assess existing legacy workflows and define target-state architectures using modern cloud services for data transformation, orchestration, and related cloud services.
  • Lead incremental migration efforts with validation processes to ensure functional parity between legacy and modernized workflows.
• Data Modeling & Analytics Architecture
  • Design dimensional models, semantic layers, and reusable data marts within the modern cloud data warehouse.
  • Implement star-schema and medallion (Bronze/Silver/Gold) architectures to support scalable analytics and reporting.
  • Create reusable data assets that accelerate dashboard development and self-service analytics.
• Dashboard Development & Business Intelligence
  • Design and deliver production-grade dashboards using leading visualization tools.
  • Develop data models, advanced calculations, row-level security, drill-through experiences, and performance optimizations.
  • Publish and govern reporting solutions that provide executive-ready insights and operational visibility.
• Analytics & Insight Generation
  • Perform trend, cohort, time-series, and comparative analyses to uncover business insights.
  • Apply hypothesis testing, A/B test analysis, and lightweight predictive techniques where appropriate.
  • Translate data into clear narratives, recommendations, and actionable business outcomes.
  • Identify opportunities to unlock additional value from organizational data assets.
• Stakeholder Partnership
  • Serve as a subject matter expert for departmental data and analytics.
  • Partner with business and technical teams to define requirements, metrics, and reporting needs.
  • Resolve data inquiries and support critical business decisions with accurate analysis.
  • Build durable partnerships across functions and establish trusted advisor relationships.
• Documentation & Leadership Communication
  • Document requirements, data contracts, metric definitions, technical designs, and migration runbooks.
  • Create executive presentations and supporting materials for leadership and board-level discussions.
  • Promote reporting standards, reusable assets, and analytics best practices across the organization.

Qualifications

• Bachelor's or Master's degree in Computer Science, Information Systems, Engineering, Statistics, Mathematics, Economics, or a related quantitative field.
• 7+ years of experience in Analytics Engineering, Data Engineering, Business Intelligence, or a comparable role with demonstrated leadership responsibilities.
• Hands-on experience developing, maintaining, optimizing, and modernizing legacy data processing workflows.
• Proven experience translating complex business problems into scalable analytics solutions and actionable insights.
• Strong experience with a leading cloud data warehouse and its associated cloud data ecosystem.

Requirements

• Advanced SQL, including complex joins, window functions, CTEs, and cloud data warehouse optimization techniques.
• Proficiency in Python for analytics, automation, and data transformation.
• Strong knowledge of dimensional modeling, star-schema architecture, medallion architecture, data quality frameworks, data lineage, Git-based source control, and CI/CD for analytics and data engineering assets.
• Strong written and verbal communication skills.

Benefits

• Subsidized health, vision, and dental plans.
• Paid sick leave.
• Retirement plans with a match.

Company Description

Aquent Talent connects the best talent in marketing, creative, and design with the world's biggest brands. Aquent is an equal-opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics.