Our client is seeking 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.
The position is open only to Colorado residents. Work will be hybrid. We have a flexible work week (ex. four 10s, five 8s).
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, 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.
Benefits:
Health, Dental, Vision, 401K
ABOUT ESG CONSULTING:
ESG Consulting is an award-winning national provider of diversified information technology consulting services to Fortune 1000, public sector entities, and emerging growth firms nationwide.
Founded in 1986, ESG offers more than 29 years of experience in the IT staffing, Engineering and consulting industry. While local to Atlanta we are headquartered in Santa Clara, we have opened offices nationwide and to this day are consistently re- evaluating and expanding our service offerings and geographic capabilities. Today, we serve most major metropolitan markets.
ESG is an equal opportunity company. Our flexible management culture believes in creating a business environment that fosters personal and professional growth and achievement. We make ESG a place where people are treated not as employees but as "partners".
