Business Intelligence Architect/Developer

Job Title: Business Intelligence Architect/Developer

Location: Golden, Colorado, 80401 (Hybrid Job-1Day/week)

Duration: 3 Months Contract

Job Description

This position will work with the Business Intelligence team within the Business Innovation & Technology. The business intelligence solutions we build allow county staff to make data-driven decisions about their operations and services.

Essential Duties

• Create, champion and implement data modeling and architecture standards to support advanced analytics and reporting
• Collaborate with analysts and stakeholders to understand data requirements and deliver robust data models
• Design, develop, and maintain scalable data pipelines and ETL/ELT processes using Azure Data Factory, Azure Synapse Analytics, Fabric and other Azure services.
• Optimize and manage data storage solutions including Azure SQL Database and Azure Blob Storage
• Develop and maintain documentation for data processes, architectures, and workflows.
• Monitor and troubleshoot data pipelines and workflows to ensure optimal performance.
  
  

Required Knowledge And Skills

• Proven experience as an Analytics Engineer or similar role, with a strong focus on Azure and Power BI
• Experience developing and implementing data architecture within a cloud-based solution (ex Azure, Snowflake, AWS, GCP)
• Experience with Microsoft Azure including Azure SQL Database and Azure Synapse Analytics
• Experience with SQL, SQL Server, and DAX
• Strong analytical and problem-solving skills balanced with a creative mindset
  
  

Preferred Knowledge And Skills

• Experience in data lake or lakehouse development
• Experience with implementing solutions in Microsoft Fabric
• Experience in Power BI or other BI tools (ex Tableau, Looker, etc)
• Experience using Python in developing analytics solutions
• Microsoft Azure or Power BI Certifications
  
  

Qualifications

Bachelor’s degree and a minimum of five years’ experience in a full-time data analytics role or equivalent using Microsoft technologies. Prefer a major in computer science, information systems, information technology, software engineering, or related field of study.