Senior Data Analyst – Department of Human Services

Job Summary

El Paso County Department of Human Services (EPCDHS) is seeking a detail-oriented data professional with strong critical thinking skills, a passion for process improvement, and expertise in data visualization and analytic tools. In this role, you'll help advance data modernization for the department as a member of the Data Analytics team, which delivers high-quality data products and consultative support to department programs and community partners, empowering data-driven decisions and streamlining the delivery of services to the public.

This position offers opportunities to grow, learn new tools, and collaborate across the department and with external stakeholders, all while contributing to meaningful programs and initiatives.

The Department of Human Services (DHS) strives to protect our most vulnerable citizens while providing efficient access to the services provided by local, state, and federal governments. We aim to keep families together and help them to become self-sufficient. We work closely with community organizations to stretch the safety net we provide even further. From food, medical, and cash assistance to child welfare and adult protective services, El Paso County Department of Human Services strives to improve the well-being of the community by offering resources and support to those facing challenges.

We work diligently to ensure that all individuals have access to the help they need to thrive and succeed.

Hiring Range: $83,000.00 - $92,000.00 annually. This position has an anticipated work schedule of Monday – Friday, 8:00am – 5:00pm; hybrid schedule may be available upon successful completion of the initial evaluation period; subject to change.

Due to the sensitive nature of this role, additional background checks may be required, including a Government Program Fraud check and Child Welfare Abuse & Neglect database (TRAILS) check.

Please be advised this position may close without advance notice, should we receive a sufficient number of qualified applications. This senior-level position is responsible for analyzing, evaluating, documenting, and delivering on data requirements, as well as maintaining, analyzing, and transforming data into insights to guide strategy and inform program data, data systems, and software decisions, including data sourced from on-premises and cloud-based platforms.

Responsible for establishing data standards and modeling practices. Employment is subject to the terms, conditions, and policies detailed in the Personnel Policies Manual (PPM). This position requires regular in-person presence as an essential job function. This position may be subject to grant funding.

• Develops complex SQL queries and stored procedures, as well as queries and transformations across relational and cloud-based data platforms and services, for data analysis, quality control, data integrity, and reporting datasets.
• Designs, develops, and maintains data pipelines and data integration workflows to support data ingestion, transformation, and delivery from a variety of sources, including databases, APIs, and cloud-based platforms.
• Develops, enhances, and maintains reports and visualizations using Power BI and other Microsoft-based applications.
• Performs a variety of research, analysis, design, testing, integration, maintenance, support, and troubleshooting tasks.
• Collects, analyzes, interprets, and summarizes novel data from multiple sources, including databases, application interfaces (APIs), and cloud-based data services, and incorporates new attributes into new or existing datasets for reporting and visualization.
• Develops and serves as a subject matter expert regarding data management practices and contributes to increasing the data maturity by providing guidance and hands-on support.
• Responsible for leading and facilitating interview sessions with technical and business stakeholders to understand and document application, data, and reporting requirements. Guides stakeholders through data harmonization activities to enhance the quality and utility of business data.
• Communicates summary analysis and findings to stakeholders, both internal…