Data Analytics Engineer

Job Description

<p><b>EXL</b> is building a Sports Analytics & Engineering Practice, and we’re hiring an <b>Analytics Data Engineer </b>to support client delivery across sports, media, and fan engagement platforms.</p><p><br></p><p>This role focuses on transforming client data into trusted, analytics-ready assets that power dashboards, insights, and decision-making. You’ll work within EXL delivery teams while collaborating directly with client analytics, product, and BI stakeholders.</p><p><br></p><p>You will own the analytics layer of client data platforms, building DBT-based transformations and dimensional models that serve as the single source of truth across reporting and analytics.</p><p><br></p><p>What You’ll Do</p><ul><li>Build and maintain analytics transformation pipelines using SQL, DBT, and Jinja on client data platforms</li><li>Design dimensional data models that support dashboards, KPIs, and self-service analytics</li><li>Own and enhance the DBT analytics layer, including models, macros, tests, and documentation</li><li>Work directly with client stakeholders to understand requirements, align on metric definitions, and validate outputs</li><li>Ensure semantic consistency across client dashboards and reports</li><li>Implement data quality checks and governance-aligned transformations</li><li>Optimize SQL and DBT models for performance in Amazon Redshift environments</li><li>Follow software engineering best practices (version control, CI/CD, peer reviews)</li><li>Support Agile delivery and collaborate with offshore teams to review and maintain high-quality analytics code</li></ul><p><br></p><p>What You Bring</p><ul><li>5+ years of experience in analytics-focused data engineering</li><li>3+ years of hands-on experience with DBT, including advanced models and macros</li><li>Strong expertise in dimensional modeling and data warehousing</li><li>Advanced SQL performance optimization skills</li><li>Experience working in client delivery or consulting-style environments</li><li>Experience with Amazon Redshift or modern cloud data platforms</li><li>Familiarity with Python and/or Jinja templating</li></ul><p><br></p><p>Why EXL</p><ul><li>Work on real-world sports analytics use cases for enterprise clients</li><li>Be part of a growing Analytics & Engineering practice with room to shape standards</li><li>Balance hands-on technical ownership with meaningful client collaboration</li><li>Gain exposure to multiple data platforms and analytics problems, not just one internal stack</li><li>Canada-based role with long-term growth and stability</li></ul><p><br></p><p>Base Compensation is between $110,000-$120,000.</p>