Data Engineer I

Alpine Bank; Grand Junction, Rifle (CO, CO); Hybrid; USD 80,000 - 110,000; Full time

Job summary

Alpine Bank in Colorado seeks a Data Engineer to design, build, and maintain the enterprise data analytics infrastructure, ensuring accessible, secure, and high-performance data for analytics and operations. You will work with cross-functional teams to support data-driven initiatives in a hybrid work model.

Responsibilities include building data lakes/warehouses, ETL/ELT pipelines, data quality controls, and data modeling.

Qualifications

• BA/BS in Computer Science or related field or equivalent training and experience.
• Industry relevant certifications such as Azure DBA are preferred.
• Experience with Microsoft SQL Server stack (SSRS, SSIS, SSMS, SSAS) and data security practices.
• Ability to design and optimize data infrastructure for analytics.

Responsibilities

• Designs, builds, tests, and maintains databases, data lakes, and data warehouses.
• Monitors data system performance and ensures security and compliance.
• Develops and maintains ETL/ELT pipelines to move data across sources.
• Implements data quality checks and resolves data issues.
• Collaborates with analysts and stakeholders to model data and support reporting.
• Keeps up to date with emerging data engineering technologies.

Skills

SQL Server stack

ETL/ELT

Azure Data Factory

Power BI

Python (PySpark)

Critical thinking

Communication

Education

BA/BS in Computer Science or related field

Azure DBA certification

Tools

VS Code

Git

Azure Data Factory

Azure SQL databases

Power BI

Azure DevOps

Visual Studio

DB2

Terraform

Job description

COPS
400 7th Street South
Rifle, CO 81650, USA

COPS
400 7th Street South
Rifle, CO 81650, USA

Grand Junction
225 N. 5th Street
Grand Junction, CO 81501, USA

Grand Junction
225 N. 5th Street
Grand Junction, CO 81501, USA

This position designs, builds, maintains and optimizes the data analytics infrastructure, ensuring data is accessible and usable for analytics and operational purposes across the enterprise. Collaborates closely with cross-functional teams to ensure the availability, security, reliability and performance of our data analytics infrastructure, systems and solutions.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Data Infrastructure Management:
  • Designs, builds, tests, and maintains databases, data lakes, and data warehouses.
  • Ensures data storage solutions are secure and compliant with relevant regulations through collaborative work with security staff.
  • Monitors and manages the performance of data systems.
• Data Quality and Integrity:
  • Implements data quality checks and validation processes.
  • Troubleshoots data issues ensuring data accuracy and reliability.
  • Administers data security, privacy, and consistency across systems according to policy.
• Data Pipeline Design and Development:
  • Designs and builds ETL/ELT pipelines to move data from various sources to target systems.
  • Ensures data pipelines are scalable, reliable, and efficient.
  • Optimizes data flow and storage for performance and cost.
  • Works with SMEs to model data in line of business data domains and producing ERDs.
• Collaboration and Communication:
  • Works closely with data analysts, and other stakeholders to understand data requirements from importing to transforming and reporting.
  • Collaborates on data-driven projects and initiatives.
  • Communicates technical information clearly and concisely.
• Staying Updated on Emerging Technologies:
  • Keeps up to date with the latest trends and technologies in data engineering.
• Regular and reliable attendance is required as an essential function of this position.

Other Duties/Responsibilities

• Specialize on Alpine Bank specific data requirements.
• Contributes and documents data policies, procedures, and standards.
• Contributes to data strategies for monitoring, backup, recovery, accessibility, and security.
• Performs other duties as assigned.

Employees are held accountable for all duties of this job.

Job Qualifications

• Knowledge, Skills, and Ability:
• Working knowledge of data and database standard designs, theories, backup, recovery, security, and integrity along with end user application connections.
• Understanding of Microsoft SQL Service Stack, SSRS, SSIS, SSMS & SSAS and able to create and manage solutions using these tools.
• Working knowledge of VS code, git, code repositories, Azure data factory, Azure SQL databases
• ETL/ELT creation, modification, and monitoring.
• Able to perform work with a high degree of latitude.
• Ability to explain complex ideas in simple terms.
• Strong problem-solving and critical thinking.

Education or Formal Training Required:

• BA/BS in Computer Science or related field, or equivalent training and experience.
• Industry relevant certifications. i.e. MS Azure DBA
• Possession of, or ability to obtain, a valid State of Colorado Driver’s License is required.

Experience Required:

• 0-3 years’ experience in data analytics and reporting.
• Experience with Microsoft Fabric, Microsoft Power BI, Azure Dev Ops, Microsoft Visual Studio.
• Experience in SQL (TSQL, DB2), Python (pyspark), DAX/MDX expressions.
• Experience with Bicep, Terraform, PowerShell is a plus.

Working Conditions

This job operates in a professional office environment, that may have a hybrid schedule to include remote work and in office but can change at any time. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines. Minimal driving may be required for branch visits and in-person meetings.

Physical Activities:

These are representative of those which must be met to successfully perform the essential functions of this job.

This is largely a sedentary role. While performing the duties of this job, the employee is regularly required to talk or hear. Specific vision abilities required by this job include close vision, distance vision, color vision, and ability to adjust focus. May have to lift up to 25 lbs.

Note: This job description is not intended to be an exhaustive list of all duties, responsibilities, or qualifications associated with the job.

Starting Rate of Pay is from $80,000.00 to $110,000.00 per year, depending on experience.

Position anticipated to close September 30, 2026, or until filled.

Qualifications

Skills

Behaviors

Motivations

:

Education

Experience

Licenses & Certifications

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.