Analytics Engineer (Contract)

Job Description Join us as an Analytics Engineer in our growing Data Division team! 🚀 Role Details 👋 Title: Analytics Engineer 📍 Location: Remote — United States (EST working hours) 💸 Compensation: $90,000–$105,000 USD annualized 📄 Contract: Full-time fixed-term through December 2026 ✈️ Travel: Occasional visits to client HQ (Washington, DC) for important planning sessions, and potential client site visits At Alliants, we're on a mission to transform every customer engagement into something exceptional. We believe in working smart together to push the boundaries of company culture and create future-proof customer experiences. Are you passionate about creating meaningful customer experiences and helping organizations deliver on their brand promises? Role Focus & Operating Context This is a production, operations-focused Analytics Engineer role embedded with a client team. The primary mandate is stability, reliability, and continuity of an existing analytics and BI environment — not greenfield development. What you’ll work on and own You’ll be accountable for the day-to-day health and performance of the client’s analytics environment, including: • Azure Data Factory (ADF) reliability: monitor, diagnose, and resolve failures across a fragmented, non-standardized legacy environment • BAU pipeline support: build, debug, fix, and maintain pipelines in the legacy environment until migration is complete, prioritizing reliability and continuity • Production support & prioritization: own inbound tickets, triage effectively, manage stakeholder expectations, and communicate status/timelines clearly • Power BI support (maintenance & reliability): maintain and troubleshoot existing reports, datasets, and refresh processes to ensure accurate, trusted outputs • Operational documentation & standards: create and maintain runbooks, troubleshooting guides, and clear documentation in an environment where this is currently lacking Job Requirements What you’ll bring • 5+ years in analytics engineering / data engineering, with a strong emphasis on supporting and maintaining production data environments. • Expert-level SQL (primarily SQL Server) used routinely to investigate issues, validate outputs, and troubleshoot failures in live systems. • Hands-on Azure Data Factory (ADF) experience diagnosing and resolving failures across existing, non-standardized pipelines in a legacy environment. • Power BI (support/maintenance) experience troubleshooting refresh failures, data discrepancies, and performance issues in existing reports and datasets. • Python used day-to-day for ingestion, transformation, automation, and pipeline support (not ML- or research focused). • Experience working in a regulated environment, with strong understanding of data privacy/security expectations and disciplined handling of production data. • Strong documentation and operational discipline, including creating and maintaining runbooks, troubleshooting guides, and clear standards in low-documentation environments. To thrive in this role, you’ll be someone who: • Has a service-oriented mindset: treats business users as primary customers; accountable for restoring trust and reliability when issues arise. • Is a methodical problem solver: diagnoses complex issues with attention to detail and follows through to prevention, not just short-term fixes. • Takes operational ownership: thrives in BAU/support work; self-sufficient, highly organized, and effective at managing priorities in a remote, embedded environment. • Communicates clearly and proactively: sets expectations, communicates trade-offs, and provides crisp status updates to both technical and non-technical stakeholders. Job Responsibilities • Own BAU intake and prioritization: manage the incoming queue of data/reporting requests, triage effectively, and align priorities directly with client stakeholders while keeping Alliants informed as needed. • Maintain ADF pipeline reliability: monitor, diagnose, and resolve Azure Data Factory pipeline failures across a fragmented, non-standardized legacy environment; perform root-cause analysis and implement pragmatic fixes to prevent recurrence. • Build and maintain legacy pipelines (as required): develop and support pipelines in the existing environment (including common API ingestion patterns such as pagination), prioritizing continuity and reliability over refactor or redesign. • Troubleshoot across the data stack (SQL Server + Azure services): investigate data quality issues, validate outputs, and resolve production failures end-to-end—from source through transformation to downstream consumption. • Power BI support (maintenance & reliability): support the stability of existing reports/datasets by resolving refresh failures, data availability issues, and performance problems that impact business users. Job Benefits Who are Alliants and what do we do? Alliants, established in 2009, is dedicated to producing customer engagement technologies and services that pave the way for a more human, sustainable, and promising future for hospitality. At Alliants, we are all in for our people and our industry. What’s in it for you? We Know We All Work Better In An Autonomous, Collaborative, Diverse And Equitable Space. To Support You In Becoming The Best Version Of Yourself, We Offer You ⚖️ Remote-first flexibility Work remotely within Canada (EST working hours), with support for flexible working and occasional in-person collaboration when it adds value. ✈️ Travel opportunities Occasional visits to client HQ (Washington, DC) for planning sessions and alignment, with additional client site visits as required. 🌍 Nomad-friendly working Flexibility to work remotely from different locations, in line with Alliants’ contractor and client requirements. 🧠 High autonomy & trust A role designed for independent operators, with clear ownership, minimal micromanagement, and direct impact on day-to-day delivery. 🎉 Inclusive team culture Contractors are treated as core contributors and included in team communications, collaboration, and social connection where appropriate. 🌳 A warm welcome To celebrate you joining Alliants, we’ll plant a Great Oak tree in your honor. Alliants celebrate diversity and are committed to creating an inclusive environment for all employees.