Systems Administration Specialist Strategy and Performance Division Harry S Truman Building - 301 W. High Street, Jefferson City, MO
ANNUAL SALARY : $58,000 - $62,000 (based upon credentials)
The salary indicated represents a base pay rate. If the individual selected is eligible for a pay differential (e.g., years of service), it will be added to the total compensation in your paycheck. A pay differential does not raise your base pay.
This is a temporary, full-time, benefit-eligible position that could end as early as June 30, 2027. Why You’ll Love This Position:
The Department of Economic Development (DED) is in the process of updating a myriad of systems in effort of streamlining 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.
- Manage Project ticketing system.
- Troubleshoot and resolve system issues, ensuring system integrity and data quality.
- Create reports, dashboards, and KPIs for business teams, as needed.
- Create data governance plan.
- Develop standard operating procedures.
- Develop/modify Salesforce user guides.
- Assist in implementing new Salesforce features and tools for business teams, as needed.
- Provide ongoing user training and support.
- Customize, configure, and modify system as needed to include custom objects, fields, templates, page layouts and flows.
- Create and deploy change sets for Development, UAT, and Production sites as needed.
- Analyze historical system data and communicate migration criteria with internal team members and vendor.
- Develop matrices for requirements and potential systems.
- Analyze business processes to develop system process requirements.
- Develop and map ideal, digital processes for new systems in coordination with stakeholders and Lean Six Sigma practices.
- Assist in development of data dictionaries and crosswalks for current systems.
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: - Salesforce experience is desired, but not required.
- 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.
- Experience in creating standard operating procedures and user guides.
- 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 .
If you have questions about this position, please contact DED Human Resources at HRHelpdesk@ded.mo.gov .