Alpine Bank is seeking a Data Engineer to design, build, maintain, and optimize the data analytics infrastructure to ensure data is accessible and usable for analytics and operational purposes across the enterprise.
Requirements
- Excellent knowledge of data and database standard designs, theories, backup, recovery, security, and integrity along with end user application connections.
- In depth 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.
- 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.
Responsibilities
- Designs, builds, tests, and maintains databases, data lakes, and data warehouses.
- Implements data quality checks and validation processes.
- Designs and builds ETL/ELT pipelines to move data from various sources to target systems.
- Optimizes data flow and storage for performance and cost.
- Works with SMEs to model data in line of business data domains and producing ERDs.
- Monitors and manages the performance of data systems.
- Administers data security, privacy, and consistency across systems according to policy.
Other
- 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.
- Regular and reliable attendance is required as an essential function of this position.
- 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.
