Business Intelligence Architect/Developer

Job Description:Description:The ideal candidate will have experience working with directly with stakeholders to deliver advanced analytics and reporting solutions.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, 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.