Data Platform Engineer

Eagle-River-Water-; Vail (CO); Remoto; USD 109.000 - 163.000; Tempo pieno

Vantaggi offerti da questo lavoro

Housing stipend

Comprehensive medical, dental and view

Paid holidays and PTO

Tuition reimbursement

Relocation assistance

Descrizione del lavoro

Eagle River Water and Sanitation District is seeking a Data Platform Engineer to own the databases, pipelines, and integrations behind our Microsoft and Azure data platform. You will lead data migrations, design scalable ETL/ELT pipelines, and ensure reliable data feeds for CIS, billing, and reporting.

The role emphasizes hands-on data engineering, system-to-system integrations, and platform operations using Python, PowerShell, and Git-based workflows, with a remote-friendly setup and occasional

Competenze

• Bachelor’s degree or two additional years of relevant experience.
• 5+ years building and operating production data pipelines (7+ years without a degree).
• Strong T-SQL and SQL Server design and performance tuning.
• Hands-on system-to-system integration experience.
• Experience with at least one major system replacement or data migration.

Mansioni

• Design, build, and maintain ETL/ELT pipelines on SQL Server, SSIS, and Azure Data Factory.
• Engineer and maintain data interfaces between CIS and vendors.
• Lead data migration projects; profile source data, mappings, and conversions.
• Automate data tasks and manage pipeline code under GitLab.

Conoscenze

T-SQL

SQL Server

Python

Azure Data Services

Git-based version control

Formazione

Bachelor’s degree in Information Systems, Computer Science, or a related technical field

Strumenti

SSIS

Azure Data Factory

GitLab

CI/CD for data pipelines

Descrizione del lavoro

Every meter read, work order, and utility bill in the Vail Valley runs on data. We are looking for a Data Platform Engineer to join our Digital Intelligence & Automation team and own the databases, pipelines, and integrations behind our Microsoft and Azure data platform. It’s an exciting time to join: the District is replacing its customer information system (CIS), finance system, and other core platforms, and this role will be the data lead on those migrations. This role is a fit for a hands-on engineer who has moved data out of a legacy system into a new one, knows what can go wrong, and builds pipelines that others can understand and support.Why work for us? The data you move supports reliable water and wastewater service and accurate billing for our community. Not to mention our excellent health benefits, housing program, and ample opportunities for training and development.Day to Day:DATA PIPELINES: Design, build, and maintain ETL/ELT pipelines on SQL Server, SSIS, and Azure Data Factory that feed the District’s central data environment. Build the schemas, views, stored procedures, and incremental extract patterns that keep large datasets current without full reloads. Monitor load jobs, troubleshoot failures to root cause, and set up alerting, data quality checks, and documentation so problems are caught before users notice and others can support the pipelines.INTEGRATIONS: Engineer and maintain data interfaces between our CIS and vendors such as payment processing, meter data management, and bank file exchange, including file formats, schedules, validation, and exception handling. Build and support connections among the CIS, Cityworks, Esri ArcGIS, operational historian data, and financial systems. Evaluate API, file, and database options with vendors, recommend the durable approach, and design integrations that limit exposure of customer data.SYSTEM REPLACEMENTS: Serve as data lead on upcoming replacements, starting with CIS and finance. Profile source data, define mappings, build and run conversion pipelines, and reconcile results. Build the staging environments and validation reporting that prove a migration before go-live, support cutover, and rebuild downstream pipelines as source systems change.PLATFORM OPERATIONS: Automate data tasks with Python, PowerShell, and Power Automate, and manage pipeline code and database objects in GitLab under the team’s change practices. Administer the Azure data services the platform runs on. Deliver curated, well-documented datasets to the analytics team: you own the pipelines, and they own the semantic models and reports.Required QualificationsBachelor’s degree in Information Systems, Computer Science, or a related technical field, or two (2) additional years of relevant professional experience.Five (5) or more years building and operating production data pipelines (seven (7) years without a degree), including T-SQL and SQL Server database design and performance tuning, SSIS and/or Azure Data Factory, Python (pandas or similar), and Azure data services.Hands-on system-to-system integration experience (file exchange, APIs, or database-to-database)At least one major system replacement or data migration, including profiling, mapping, conversion, and reconciliationGit-based version controlAbility to document and explain technical trade-offs clearly.Preferred QualificationsUtility, municipal, or public-sector experience, especially with a customer information or billing system, Cityworks, or Esri ArcGIS.Experience with SCADA historian data (iHistorian or similar) or AMI meter data.PowerShell, Power BI semantic models, and CI/CD for data pipelines.PowerShell scripting.Power BI and an understanding of how semantic models consume data.SSAS Tabular, data lake, or other Microsoft data platform experience beyond SQL Server and Data Factory.CI/CD for data pipelines or database projects.The ScheduleThis role can be entirely remote but should be able to come to our Eagle County, CO office locations occasionally for team events, training and development, and meetings.Pay RangeThe overall pay range for this role is $108,804.80 to $163,196.80. The starting range depends on qualifications but generally falls within the minimum and midpoint of the pay range.BenefitsAt ERWSD, we value life-work balance and are leaders in the industry with our holistic benefits package, which includes but is not limited to:Comprehensive medical, dental and vision coverageEmployee housing or $559 monthly housing stipendWellness programRetirement savings plans (414h and 457) - We are a social security exempt organization13.5 Paid HolidaysPaid Time Off (PTO)Paid Parental Leave$800 Annual Recreation BenefitTuition ReimbursementLoan programs for: Ski Passes, Electric Vehicles, and ComputersRelocation Assistance (if applicable)Click this link to learn more and view our full Benefits Guide.All District employees must submit to a pre-employment drug screen and extensive background check including an educational verification and reference check. For a full position description including work environment and physical demands, email [e-mail]. All applicants must apply online at www.erwsd.org by November 13, 2026.We are an Equal Opportunity EmployerWe do not discriminate based on race, color, religion, national origin, sex, age, disability, sexual orientation, marital status, genetic information or any other status protected by law or regulation. It is our intention that all qualified applicants be given equal opportunity and that selection decisions are based on job-related factors.