Data Engineer I

About the Role

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 data analytics infrastructure, systems, and solutions.

Key Responsibilities

• 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.
• Other Duties/Responsibilities:
• Specializes 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.

Requirements & Tech Stack

• 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.

Qualifications

• Education Or Formal Training Required:
• BA/BS in Computer Science or related field, or equivalent training and experience.
• Industry relevant certifications (e.g., 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 DevOps, Microsoft Visual Studio.
• Experience in SQL (TSQL, DB2), Python (pyspark), DAX/MDX expressions.
• Experience with Bicep, Terraform, PowerShell is a plus.