What are the responsibilities and job description for the Business Intelligence Architect/Developer position at Lorven Technologies Inc.?
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
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.
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.
- 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
- 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
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.
