Title: Business Intelligence Architect/Developer
Location: Golden Colorado 80401
Client: Jefferson County
Note: Position is open only to Colorado residents. Interviews will be done virtually but work will be hybrid. We have a flexible work week. 2 days onsite and 3 days remote
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 & Technology department at Jefferson County. We are an awardwinning nationally recognized team that brings new and improved services to the community. The business intelligence solutions we build allow county staff to make datadriven 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 cloudbased 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 problemsolving skills balanced with a creative mindset
Preferred Knowledge and Skills:
- Experience in data lake or lake house 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 fulltime data analytics role or equivalent using Microsoft technologies. Prefer a major in computer science information systems
If you are: bright motivated skilled a differencemaker able to get things done work with minimum direction enthusiastic a thinker able to juggle and multitask communicate effectively and lead then we would like to hear from you. We need exceptionally capable people for this role for our client so get back to us and tell us why you think you are a fit.
About Us:
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