The Data Engineer designs, builds, maintains and optimizes the data analytics infrastructure, ensuring 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.
- 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.
- 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.
- Designs and builds ETL/ELT pipelines to move data from various sources to target systems.
Other
- Regular and reliable attendance is required as an essential function of this position.
- 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.
- 5 years’ experience in data analytics and reporting.
