Data Architect

3 weeks ago

Evergreen, Colorado, United States Apex Informatics Full time
Business Intelligence Architect/Developer

We are seeking an experienced Analytics Engineer to join our team at Apex Informatics. As a key member of our Business Innovation & Technology department, you will play a crucial role in designing and implementing effective data architecture to support business intelligence and analytics reporting across Jefferson County, Colorado.

Key Responsibilities:

  • Create and champion 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, 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

Requirements:

  • 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 (e.g., 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 (e.g., Tableau, Looker, etc.)
  • Experience using Python in developing analytics solutions
  • Microsoft Azure or Power BI Certifications

About Us:

Apex Informatics is an award-winning, nationally recognized team that brings new and improved services to the community. We are committed to delivering high-quality solutions that enable county staff to make data-driven decisions about their operations and services.

  • Business Intelligence Architect/Developer

    3 weeks ago

    Evergreen, United States Apex Informatics Full time

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