Analytics Solutions Developer (Research/Data Analyst)

State-of-Missour; Jefferson City (MO); On-site; USD 51,000 - 62,000; Full time

Job summary

State-of-Missour in Jefferson City seeks a developer to automate workflows and build data solutions using ServiceNow, Microsoft Power Apps, Snowflake, and Tableau. You will craft data pipelines, run SQL queries, and deliver interactive dashboards for Missouri's insurance market.

Minimum qualifications include a Bachelor's degree in Computer Science, Data Analytics, or Information Systems with 2–4 years of relevant experience.

Qualifications

• Bachelor's degree in Computer Science, Data Analytics, Information Systems, or related field.
• 2-4 years of relevant experience in software or application development (low-code, scripting, or enterprise platforms).
• 2-4 years of experience handling complex SQL queries and data transformations.

Responsibilities

• Automate process workflows using code-based and/or low-code solutions.
• Design, build, and maintain applications using ServiceNow, Microsoft Power Apps, or similar platforms.
• Develop and optimize data ingestion and transformation pipelines in Snowflake using SQL.
• Build and maintain internal and external interactive dashboards using Tableau.
• Perform in-depth data analysis and market research on Missouri's insurance market.

Skills

Problem solving

Critical thinking

Education

Bachelor's degree in Computer Science, Data Analytics, Information Systems, or related field

Tools

ServiceNow

Power Platform

Snowflake

Tableau

Job description

Starting Salary: $56,760.24

The salary indicated represents a base pay rate. If the candidate selected is eligible for a years-of-service pay differential, it will be added to the total compensation. A pay differential does not raise the base pay.

Job Location: This position is located at the Harry S Truman State Office Building, 301 W High Street, Jefferson City, Missouri.

Why is the work you do in this position important to Missouri?

Through automation, this position supports the agency's goal of efficiently delivering insurance market information for consumers, insurance companies, departmental staff, and policymakers to monitor the health of Missouri's insurance markets.

• Automate process workflows using code-based and/or low-code solutions.
• Design, build, and maintain applications using ServiceNow, Microsoft Power Apps, or similar application development platforms.
• Develop and optimize data ingestion and transformation pipelines in Snowflake using SQL.
• Build and maintain internal and external interactive dashboards using Tableau.
• Perform in-depth data analysis and market research on the Missouri insurance market.

Minimum Qualifications:

• Strong problem-solving drive and critical thinking skills.
• Bachelor's degreein Computer Science, Data Analytics, Information Systems, ora related field,plus 2-4 years of relevant experience.
  • Areas of qualifying experience:
    • 2-4 years of experience in software or application development (low-code, scripting, or enterprise platforms),
    • 2-4 years of experience handling complex SQL queries and data transformations.

Preferred Qualifications:

• Proficiency with ServiceNow development or Microsoft Power Platform administration.
• Proficiency with Snowflake data architecture, warehousing, and ETL/ELT pipelines.
• Proficiency with Tableau or other data visualization software.

Lack of post-secondary education will not be used as the sole basis denying consideration to any applicant.

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, an interactive Total Compensation Calculator was created. 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.

The Missouri Department of Commerce and Insurance, Human Resources Section at [e-mail].