Senior Data Engineer (Information Technology)

Senior Data Engineer (Information Technology)

Our Data Engineering team has an open Senior Data Engineer position! The team maintains a variety of data engineering platforms and systems, including Azure, Microsoft Fabric, Power BI, dbt, Git, and ION ETL (Pentaho). 

This Data Engineering role supports data-driven decision making and machine learning to help improve business processes and, ultimately, Colorado Springs Utilities' ability to deliver safe, reliable, and competitively priced utility services. If you have experience with data engineering and implementing and maintaining enterprise data management systems, preferably in an information technology setting, we want to hear from you!

Please note that upon successfully completing probation (six months), this position offers a hybrid working arrangement (two days remote and three days onsite per week).  You must live in the state of Colorado for this role.

What Else Will You be Doing?

• Implementing and maintaining data engineering systems using Azure, Microsoft Fabric, Power BI, dbt, Git, and ION ETL (Pentaho)
• Developing Fabric pipelines, dbt projects, spark jobs, and copy tasks for providing data, and semantic models for analytics
• Define/implement compliant data models supporting business needs
• Define/implement monitoring/alerting for data quality, load performance, and capacity management
• Leveraging advanced, cloud-scale tools to ingest and prepare enterprise data for reporting, alerting, machine learning, and data science
• Maintaining source code management repositories for supported systems
• Writing technical documentation and process flows for supported systems
• Providing technical expertise to examine, troubleshoot, and repair problems within supported systems
• Analyzing and researching new technologies applicable to data engineering
• Engaging in requirements gathering through understanding business processes and end user needs
• Translating functional requirements into technical solutions, and communicating and documenting solutions as needed
• Creating standard operating procedures and implementing process improvements as needed

Who You Are

• Demonstrated Data Engineering experience is required
• Experience working with data independent of applications and preparing it for analytics and data science is required
• Knowledge and proficiency with Fabric, Power BI, ION ETL (Pentaho), and/or Azure is valued
• Experience developing automated data validation and testing routines is valued
• 3 years’ experience in data engineering supporting analytics is valued
• Bachelor's Degree in Information Technology, Computer Science, Software Engineering, Data Science, or a related field is valued

The military job codes/duty codes most closely related to this role are: 25A, 25B, 25D, 25U, 25Z, 250N, 251A, 254A, 255N, 255S, 255Z, 17C0, 17D1, 17D2, 17DX, 33S1, 33S2, 33S4, 33SX, 6420, 6423, 6425, 6427, IT 2502, 4002, 4010, 5970, 9628, 9646, 9975, 9985, 9634, 9934, 9975, 9985

PHYSICAL REQUIREMENTS/WORKING CONDITIONS:
-  Exerting up to 10 pounds of force occasionally (1/3 of the time), and/or a negligible amount of force frequently (1/3 to 2/3 of the time) to lift, carry, push, or pull objects. Sedentary work involves sitting most of the time but may involve walking or standing for brief periods of time. Jobs are sedentary only if walking and standing are required only occasionally and all other criteria are met.
-  Positions in this class typically require talking, hearing, seeing and repetitive motions within an office working environment

Who We Are...
Colorado Springs Utilities, a four-service utility provider with a 100-year reputation of integrity, gives you an experience unmatched by other utility companies. We continuously strive to stay ahead of the business curve with our established priority to update and incorporate state-of-the-art technology and provide a work culture dedicated to innovation, collaboration, and synergy. In fact, we were recently awarded the Diamond Designation from the American Public Power Association (APPA), recognizing our utility for having some of the highest ratings in reliability, safety, workforce development, and system improvements among the more than 2,000 public utilities in the nation. 

Nestled at the base of the Rocky Mountains, Colorado Springs is the perfect blend of mountain and city living. With over 300 days of sunshine a year, you will enjoy nature at its finest while residing in one of the most desirable places to live in the United States (according to U.S. News & World Report, 2021).

Our Commitment to Our Employees…
Our people are the heart and soul of Colorado Springs Utilities.  They keep the lights on, gas flowing, water coming in, and wastewater leaving.  We don't just say people are important – we prove it!  That’s why we are honored to invest in protecting the health and financial security of our employees and their families through our rich benefits program.

Time Off to Recharge

• Vacation – Start with 13 days annually, increasing to 24 days with tenure
• Personal Leave –3 days per year
• Paid Holidays –12 paid holidays per year
• Sick Leave – 12 days per year for personal or family health needs
• Vacation Buy – Option to purchase up to 40 additional hours annually

Health & Wellness – Benefits elected are effective the first of the following month

• Medical Plans: Three comprehensive options, including a $0 premium High-Deductible Health Plan (HDHP) with Health Savings Account (HSA) eligibility
• Zero Health: Access to hundreds of medical services at no cost
• Dental & Vision: Two dental plans and one vision plan
• Family Building-Benefits: Support for fertility, preservation, adoption, and surrogacy
• Wellness Program: A voluntary program that rewards you for prioritizing self-care! If you're enrolled in a our medical plan, you and your spouse can earn up to $600 in HRA or HSA contributions by completing healthy activities
• Flexible Spending Accounts (FSA): Pre-tax contributions for healthcare and dependent care expenses
• Health Savings Account (HSA): Available with HDHP

Financial & Retirement Security

• Pension Plan: Colorado PERA provides retirement benefits and peace of mind
• Supplemental Retirement Plans: PERAPlus 401(k), MissionSquare Roth IRA, and 457 plans
• Disability Coverage: Short-Term and Long-Term Disability insurance available
• Life Insurance: Employer-paid coverage with optional supplemental plans

Additional Support

• Employee Assistance Program (EAP): Confidential support for mental health, stress, legal, financial, and work-life balance
• Tuition Reimbursement: Up to $5,250  annually to support continued education
• Public Service Loan Forgiveness: As a qualifying employer, your student loan payments may be eligible for loan forgiveness