Senior Data Analyst - Department of Human Services

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. El Paso County Department of Human Services (EPCDHS) is seeking a highly skilled Senior Data Analyst with strong critical thinking abilities, a process-improvement mindset, and expertise in SQL, data integration, cloud data platforms, and data visualization. In this role, the analyst will support the department's data modernization efforts by developing pipelines, transforming complex datasets, and delivering high-quality insights that guide strategy and strengthen program operations. This position works collaboratively across technical and non-technical teams, facilitates data and reporting requirements, and contributes to data standards, modeling practices, and governance activities. The role offers opportunities to innovate, learn new tools and technologies, and make a meaningful impact on programs serving children, families, and the broader community. APPLY TODAY! ** Hiring Range: $83,000.00 - $92,000.00 annually** This position has an anticipated work schedule of Monday -- Friday, 8:00am -- 5:00pm; subject to change. Please be advised this position may close without advance notice, should we receive a sufficient number of qualified applications. 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. 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. Essential Duties/Responsibilities: - 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 subjec 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 and external. - Performs daily data quality control and integrity checks and makes recommendations for automation opportunities. Identifies, recommends, and implements process optimization programs using best practice methodologies. Facilitates automation efforts by developing and deploying minor applications, scripts, or workflows to support data processing and pipeline orchestration and to complement existing line-of-business applications. - Conducts and supports data profiling activities in relation to data quality assessment and metadata analysis. Develops and manages the enterprise data dictionary by recording data attributes and associated metadata to increase the understanding and utility of data. - Establishes and applies data standards and documentation. - Establishes and applies data modeling practices and data architecture options; provides guidance and support to stakeholders. - Supports new enterprise-level information management capabilities and related change efforts. - Coordinates with internal service providers and end users to ensure technical compatibility and user satisfaction. Works directly with third-party vendors to coordinate release upgrades, resolve system failures, and define specifications for new system features. - Performs project management activities, including project plan development, status tracking, and coordination of teams. - Creates non-technical summaries and other materials to assist in the communication of project efforts and outcomes. - Provides reporting assistance and technical training to non-technical end-users. - Drives product adoption and ensures a positive user experience and understanding by hosting product user groups and facilitating product-related knowledge-sharing. - Understands the strategic importance and value proposition of assigned products and seeks to position products to maximize customer value. - Performs other duties as required. Supervision Exercised: This classification does not have supervisory authority; however, may be required to provide expertise or limited guidance or direction to employees, such as overseeing work quality, training, and guidance. Typically serves as a subject matter expert on the scope of functional area. Supervision Received: Receives general supervision. This classification typically performs job duties by following established standard operating procedures and/or policies. Regular direction, guidance, and coaching from supervisor may be expected. There is a choice of the appropriate procedure or policy to apply to duties. Performance reviewed periodically. Qualifications: Knowledge, Skills & Abilities - Working knowledge of data integration processes, including ETL and ELT patterns, data transformation, data quality, and data profiling, as well as data pipeline development and orchestration. - Knowledge of Microsoft Office 365 and the Microsoft Power Platform. - Knowledge of statistical analyses, datasets, and associated software such as SAS, R, Python, or comparable cloud data environments. - Knowledge of agile project management methods. Skill in prioritizing and organizing multiple tasks and the ability to complete projects in a timely manner, frequently under deadline pressure. - Knowledge of data integration methods, including working with application programming interfaces (APIs) and external data services. - Familiarity with cloud-base