BI Architect/Developer with the State of CO (Hybrid)

Overview

Hybrid
$75 - $85
Contract - W2
Contract - Independent
Contract - 4 Month(s)

Skills

Azure
Azure Blob
Azure Data Factory
Azure SQL
BI Architect
Blob
Business Intelligence
Collaborate
ETL
Power BI
Python
SQL
SQL Server
Tableau
computer science
data architecture
data lake
data modeling
data pipelines
data processes
information systems
maintain documentation
problem - solving
problem - solving skills
software engineering

Job Details

Job Title: BI Architect/Developer with the State of CO (Hybrid & Candidate must be local to CO)

Last Date for Submission: 27th Sep 2024

Max Submissions: 2

Duration: 10/28/2024 - 01/31/2025

Position is open only to Colorado residents. Interviews will be done virtually, but work will be hybrid. We have a flexible work week (ex. four 10s, five 8s).

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

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, Google Cloud Platform)
    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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.