Job description

Together, we innovate for a stronger Colorado The work of employees at the Governor's Office of Information Technology (OIT) is challenging and diverse because the needs of agencies, customers and Coloradans constantly evolve. But our focus never changes: improve the lives of all Coloradans through innovation and collaboration. We're building one of the nation's leading government IT organizations by reimagining how we support agencies, building first-of-their-kind applications, and creating an inclusive, collaborative culture, together. Join us in the important work of providing equitable access to services. Watch this video to learn more about how we're Serving People. Serving Colorado. IMPORTANT NOTE: Please review your application to ensure completion. For the most equitable applicant experience, OIT’s hiring team considers only the contents of your application to review your qualifications. Please do not include any attachments (such as resume or cover letter) with your application as these items are not used by OIT’s hiring team. We are seeking an experienced Data Analyst to analyze business and application data, support data migration and modernization efforts, and work closely with business and technical teams to ensure data is accurate, usable, and aligned with business requirements. As a Senior Data Analyst , you will analyze existing data and workflows, develop SQL queries and data analysis, support data transformation and migration activities, and assist with testing and validation of applications and data. The ideal candidate will be comfortable working with legacy systems, translating business needs into data requirements, and collaborating across technical and business teams. Essential Duties: • Analyze business and application data using SQL to identify trends, validate data, and support business requirements. • Work with business stakeholders and technical teams to gather, document, and analyze data requirements. • Analyze legacy data structures and workflows and identify requirements for migration to modern systems. • Support data migration, transformation, and validation activities to ensure data is accurately transferred and structured for target systems. • Develop queries, data analysis, and documentation to support application modernization and operational needs. • Perform data quality checks and investigate data discrepancies or inconsistencies. • Develop and execute test scenarios and test scripts to validate data, applications, and business processes. • Partner with developers, testers, business analysts, and project teams throughout the application lifecycle. • Document data processes, business rules, workflows, requirements, and transformation logic. • Support regression and user acceptance testing by validating expected data and system behavior. • Identify opportunities to improve data processes, reporting, testing, and overall system efficiency. • Communicate findings and recommendations clearly to both technical and non-technical stakeholders. • Participate in Agile delivery processes, including Scrum and Kanban ceremonies and iterative delivery. Technical Environment SQL | Data Analysis | Data Migration & Transformation | Data Validation | Requirements Analysis | Application Testing | Regression Testing | Agile/Scrum | Legacy Systems | Business Process Analysis | JAWS / JAWS Inspect A wide salary range is posted for this position and any job offer is based upon a salary analysis to comply with the Colorado Equal Pay for Equal Work Act. The salary analysis considers relevant experience, education, certifications, and state seniority as compared to others doing substantially similar work. While all offers are compliant with the Colorado Equal Pay for Equal Work Act, there is no guarantee an offer will be at the top of the posted range based on the salary analysis. This is a skills-based job announcement. The required minimum qualifications and/or education (if substituting for the proven experience, knowledge, and skills), are as follows: Minimum Qualifications: • Minimum of five (5) years of experience in data analysis, business analysis, systems analysis, or a related field. • Strong SQL skills and experience analyzing relational data. Substitutions: • Additional appropriate education will substitute for the required experience on a year-for-year basis, but cannot completely substitute for these qualifications. • Training or Certification related to the work assigned to the position will be assigned credit towards substitution for experience and/or education, but cannot completely substitute for these qualifications. • If the minimum qualifications include a degree requirement, additional appropriate paid or unpaid experience will substitute for the required education on a year-for-year basis. Preferred Qualifications: • Experience with large-scale enterprise or government data environments. • Experience developing test scripts and supporting regression, integration, and user acceptance testing. • Experience with accessibility testing and tools such as JAWS or JAWS Inspect . • Experience with both Agile and traditional project delivery methodologies. • PMP, Scrum Master, or related professional certification. • Experience analyzing and documenting data requirements, business processes, and workflows. • Experience supporting data migration and data transformation initiatives . • Experience with data validation, quality assurance, and application testing. • Strong analytical and problem-solving skills. • Ability to translate business requirements into clear technical and data requirements. • Strong written and verbal communication skills. • Experience collaborating with cross-functional teams and business stakeholders. • Experience working in an Agile/Scrum environment . Conditions of Employment: OIT employees must comply with any screening procedures in place at state agency locations where they might perform work. A pre-employment background check will be conducted as part of the selection process. Post-employment background checks will be required for specific agencies as business needs dictate, which may include a polygraph exam, fingerprint-based criminal history search, reference checks, and a drug test. This position may require travel within the specified geographic area, and to locations across the state as needed. If this posting indicates “remote from anywhere in CO” in the title, periodic reporting to the primary state work location designated for the position is required. All remote work must be performed in Colorado. While candidates from out of state will be considered for this role, the candidate selected for the position must relocate and reside in Colorado on the first day of their new position. A reasonable timeframe for relocation will be established on an individual basis, while considering business needs, and determining a start date. We know it's important to support each other, and that means having a healthy balance of work and personal time. Visit our benefits to learn more about some of our great offerings that allow us all to have fulfilling lives. Visit our How to Apply webpage to learn more about our application process and what to expect after you apply. The State of Colorado strives to create a Colorado for All by building and maintaining workplaces that value and respect all Coloradans through a commitment to equal opportunity and hiring based on merit and fitness. The State is resolute in non-discriminatory practices in everything we do, including hiring, employment, and advancement opportunities. The Governor's Office of Information Technology is committed to the full inclusion of all qualified individuals. As part of this commitment, our agency will assist individuals who have a disability with any reasonable accommodation requests related to employment, including completing the application process, interviewing, completing any pre-employment testing, participating in the employee selection process, and/or to perform essential job functions where the requested accommodation does not impose an undue hardship. If you have a disability and require reasonable accommodation to ensure you have a positive experience applying or interviewing for this position, please direct your inquiries to our ADA Coordinator at OIT_HR@state.co.us or call (303) 764-7900. This posting may be used to fill multiple vacancies based upon business need. The Governor's Office of Information Technology does NOT offer sponsored Visas for employment purposes.

Requirements

Must-haves

Together, we innovate for a stronger Colorado
Watch this video to learn more about how we're Serving People. Serving Colorado.
Analyze business and application data using SQL to identify trends, validate data, and support business requirements.
Work with business stakeholders and technical teams to gather, document, and analyze data requirements.
Analyze legacy data structures and workflows and identify requirements for migration to modern systems.
Support data migration, transformation, and validation activities to ensure data is accurately transferred and structured for target systems.
Develop queries, data analysis, and documentation to support application modernization and operational needs.
Perform data quality checks and investigate data discrepancies or inconsistencies.
Develop and execute test scenarios and test scripts to validate data, applications, and business processes.
Partner with developers, testers, business analysts, and project teams throughout the application lifecycle.
Document data processes, business rules, workflows, requirements, and transformation logic.
Support regression and user acceptance testing by validating expected data and system behavior.

Nice-to-haves

Experience with large-scale enterprise or government data environments.
Experience developing test scripts and supporting regression, integration, and user acceptance testing.
Experience with accessibility testing and tools such as JAWS or JAWS Inspect .
Experience with both Agile and traditional project delivery methodologies.
PMP, Scrum Master, or related professional certification.
Experience analyzing and documenting data requirements, business processes, and workflows.
Experience supporting data migration and data transformation initiatives .
Experience with data validation, quality assurance, and application testing.
Strong analytical and problem-solving skills.
Ability to translate business requirements into clear technical and data requirements.
Strong written and verbal communication skills.
Experience collaborating with cross-functional teams and business stakeholders.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlagilescrumaccessibility

Platform: governmentjobs
Effort: medium