Apply on Employer Site

Alliants · 22 hours ago

Analytics Engineer (Contract)

Washington, DC

Contract

Hybrid

Mid, Senior Level

$90K/yr - $105K/yr

5+ years exp

Alliants is on a mission to transform customer engagement and is seeking an Analytics Engineer to join their Data Division team. The role focuses on maintaining the stability and reliability of existing analytics and BI environments, ensuring operational continuity, and supporting data pipelines and reporting tools.

AndroidConsultingInformation TechnologyiOSMobileSoftware

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

Qualification

Azure Data FactorySQLPower BIPythonData privacy/securityOperational ownershipDocumentationProblem solvingCommunication

Required

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