Logo
Crescens

Business Intelligence Architect/Developer

Crescens, Golden, Colorado, United States, 80401


Title: Business Intelligence Architect/DeveloperLocation: Golden, CO (Hybrid)Duration: 3+ MonthsType: Contract

Notes: Candidate Must Be Local.This is a hybrid position. Office is located at 3500 Illinois St., Suite 2500, Golden, CO 80401.Interviews will be done virtually, but work will be

hybrid. We have a flexible work week (ex. four 10s, five 8s).

Job description:

We are looking for an experienced Analytics Engineer to help design and implement effective data architecture to support business intelligence and analytics reporting across Jefferson County, Colorado. The ideal candidate will have experience working with directly with stakeholders to deliver advanced analytics and reporting solutions.This position will work with the Business Intelligence team within the Business Innovation and Technology department at Jefferson County. We are an award-winning, nationally recognized team that brings new and improved services to the community. The business intelligence solutions we build allow county staff to make data-driven decisions about their operations and services.Create, champion and implement data modeling and architecture standards to support advanced analytics and reportingCollaborate with analysts and stakeholders to understand data requirements and deliver robust data modelsDesign, 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 StorageDevelop and maintain documentation for data processes, architectures, and workflows.Monitor and troubleshoot data pipelines and workflows to ensure optimal performance.

Required Skills:

Proven experience as an Analytics Engineer or similar role, with a strong focus on Azure and Power BIExperience 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 AnalyticsExperience with SQL, SQL Server, and DAXStrong analytical and problem-solving skills balanced with a creative mindset

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