Senior Data Analyst – Department of Human Services

Need help with applying? Visit our Talent Acquisition page here for application guidance and resources. 

VISION

El Paso County will be a trusted regional leader known for excellence in county service delivery. 

PURPOSE

We provide essential public services to the Pikes Peak Region in support of our residents, businesses, and communities, enhancing the freedom for all to thrive. 

VALUES

Service Focused • Collaborative • Accountable • Trustworthy • Transparent

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.

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. 

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

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-based data platforms and services (e.g., Azure, Snowflake, Google BigQuery, or similar environments).
• Familiarity with data architecture, storage, archiving, lineage, and impact analysis.
• Excellent analytical skills, including the ability to quickly and accurately wrangle, analyze and interpret data, identify and define data integrity issues, and make recommendations for resolution. Familiarity with business process modeling.
• Project management understanding of project scopes, project schedules, budgets, and resource allocation for on-time, on-budget projects.
• Skilled in writing and maintaining accurate records, reports, and plans to meet management objectives.
• Excellent facilitation and conflict management skills.
• Must have excellent interpersonal and communication skills with both technical and non-technical audiences. Ability to provide excellent customer service. 
• Must possess a high level of professionalism and integrity to handle sensitive and confidential situations and information.
• Must have strong customer service, teamwork, and contract management skills.
• Ability to work cross-functionally with IT teams and key stakeholders, utilizing analytical skills in understanding data flows, dissecting problems, and delivering clear recommendations and guidance.
• Ability to respond in a flexible manner and reprioritize work as situations change.
• Ability to work independently and in a team environment.
• Ability to establish and maintain effective working relationships with co-workers, County staff, partner organizations, and vendors.
• Maintain regular and punctual attendance. 

• High school diploma or equivalent education.
• Five years of data collection, synthesis, or analysis experience, including working with databases or statistical software. 
  • Associate’s degree in a related field may substitute for one year of the required experience. 
  • Bachelor’s degree in a related field may substitute for two years of the required experience. 
  • Master’s degree in a related field may substitute for three years of the required experience. 
  • Education substitutions are not cumulative; only the highest qualifying degree will be considered.
• Experience with SQL or other data query languages.
• Experience with data integration tools, scripting languages, or data management within databases or cloud-based platforms.
• Experience with data visualization tools, such as Power BI.

• Bachelor's degree in computer science, information systems, project management, business administration, statistics, or related field.
• Seven years of data collection, synthesis, or analysis experience, including working with databases or statistical software. 
• Experience working with a human services-related field.

• Must obtain and maintain necessary certifications/licenses as applicable to position.
• If assigned to the Digital, Strategy, & Technology Department:
  • Must obtain and maintain Criminal Justice Information System (CJIS) Compliance within six months of employment based on regular access to the Sheriff's Office buildings, systems, and/or networks.

•  Must pass conditional post offer background investigation and drug screen.

Duties are primarily performed in an office and/or remote work environment dependent on Department discretion and business needs. May be required to work outside of normal business hours and respond to sensitive situations 24 hours a day, 7 days a week; may be required to carry a cell phone. 
 
The classification specification above is intended to describe the general nature of work, key responsibilities, and minimum qualifications. Minimum qualifications reflect the baseline experience required for the classification. Departments may establish additional or preferred qualifications to address operational needs, assignment complexity, and specialized functions, provided such qualifications are job-related, consistent with the intent of the classification, and as approved by the Human Resources department. Specific job assignments, duties, education, experience, licenses/certifications, and working conditions may vary based on the department or office's needs and the requirements of the assigned position. Changes to this classification specification may only be made by the Human Resources Department.

El Paso County is an E-Verify and Equal Opportunity Employer.

El Paso County adheres to Federal drug screening guidelines and requires a pre-employment drug screen.