Systems Data Analyst

Systems Data Analyst

Strategy and Performance Division

Harry S Truman Building - 301 W. High Street, Jefferson City, MO

SALARY : $58,000 - $62,000

Why You’ll Love This Position:

Are you interested in being a key player in the development of DED’s new system(s)? Well look no further, this position is for you. The Department of Economic Development currently utilizes over 30 systems or database tools between programs, with many requiring duplication of data management because these systems do not communicate with each other. We are working to update systems and streamline processes to improve our customer and team member experience. This position will assist the team with gathering system and business requirements to develop our new Salesforce system. This position will include training that could lead to a paid Salesforce certification.

#TeamDED is an energetic environment that encourages economic growth by supporting Missouri’s businesses and diverse industries, strengthening our communities, developing a talented and skilled workforce, and maintaining a high quality of life. Together, #WeServeMO.

This is a temporary, full-time, benefit-eligible position that could end as early as June 30, 2026.

• Analyze historical system data and communicate migration criteria with internal team members and vendor.

• Identify cleaning and transforming of data needed prior to migration.

• Participate in workshops to gather and structure system requirements with internal and external stakeholders.
• Develop matrices for requirements and potential systems.
• Analyze business processes to develop system process requirements.
• Work with Program Teams to validate inventory lists and process maps.
• Develop and map ideal, digital processes for new systems in coordination with stakeholders and Lean Six Sigma practices.
• Assist division and program leadership with developing standardized forms and procedures.
• Drive development of data dictionaries and crosswalks for current systems.
• Develop General System Design documents based on stakeholder requirements.

Minimum Qualifications:

• Six or more years of relevant experience. This can be obtained through a combination of work experience and completion of a Bachelor’s degree program in Computer Information Systems (CIS), Computer Information Management (CIM), Marketing, Public Relations, Finance, Economics, Business or Public Administration, International Business, Agribusiness or a closely related field.
• Lack of post-secondary education will not be used as the sole basis for denying consideration to any applicant.

Preferred Knowledge, Skills, and Abilities:

• SQL knowledge to include: writing and optimizing SQL queries to retrieve data in a database, understanding and designing database schemas, creating and modifying database tables, and ensuring data integrity using constraints and indexes.
• Experience in analyzing and preparing documents, reports and requirements to support system design.
• Experience with and knowledge of data dictionary and/or data crosswalk structuring is desired, but not required.
• Ability to quickly gain an overall understanding of the business systems we currently have.
• Ability to see and communicate overall vision and structure of new processes to ensure systems selected meet stakeholder requirements.
• Ability to multi-task and prioritize assignments.
• Ability to function and adjust in a fast pace and busy environment.
• Ability to read and understand process flow diagrams.
• Skill in collecting and analyzing complex report data.
• Skill in analyzing and organizing technical data.
• Proficient knowledge in Excel.
• Excellent organizational and time management skills.
• Working understanding of data and its properties.

The State of Missouri offers an excellent benefits package that includes a defined pension plan, generous amounts of leave and holiday time, and eligibility for health insurance coverage. Your total compensation is more than the dollars you receive in your paycheck. To help demonstrate the value of working for the State of Missouri, we have created an interactive Total Compensation Calculator. This tool provides a comprehensive view of benefits and more that are offered to prospective employees. The Total Compensation Calculator and other applicant resources can be found here .

• 

• State of Missouri

Show more