IT Advanced Data Analyst - ITS4

Minnesota Careers

$78K — $129K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Minimum of four years IT experience in data analysis or quality assurance.
  • Proven experience leading data analysis and reconstruction efforts.
  • Advanced SQL skills and experience conducting code reviews.
  • Strong background in data validation and technical support for data systems.
  • Effective communication skills for clear understanding among stakeholders.

Responsibilities

  • Analyze complex data sets and document system requirements.
  • Design and implement solutions based on user and technical needs.
  • Write advanced SQL queries for data extraction and report generation.
  • Troubleshoot data issues and maintain data quality standards.
  • Collaborate with developers and business owners to ensure correct implementation.

Benefits

  • Affordable health insurance plans for employees and their families.
  • Paid vacation and sick leave, with 12 paid holidays each year.
  • 6 weeks of paid leave for parents of newborns or newly adopted children.
  • Employer paid life insurance and disability insurance options available.
  • Access to resources for professional development and career support.
Full Job Description
Job Details

Working Title: IT Advanced Data Analyst
Job Class: Information Technology Specialist 4
Agency: Minnesota IT Services
  • Job ID: 95999
  • Location: St. Paul
  • Telework Eligible: Yes #LI-Hybrid
  • Full/Part Time: Full-Time
  • Regular/Temporary: Limited
  • Who May Apply: Open to all qualified job seekers
  • Date Posted: 07/31/2026
  • Closing Date: 08/13/2026
  • Hiring Agency/Seniority Unit: Minnesota IT Services
  • Division/Unit: Office of Higher Education
  • Work Shift/Work Hours: Day Shift
  • Days of Work: Monday - Friday
  • Travel Required: No
  • Salary Range: $37.72 - $62.21 / hourly; $78,759 - $129,894 / annually
  • Job Class Option: Data Systems
  • Classified Status: Unclassified
  • Bargaining Unit/Union: 214 - Professional Employees
  • End Date: Anticipated End Date 08/30/2029
  • FLSA Status: Exempt - Professional
  • Designated in Connect 700 Program for Applicants with Disabilities : No

Job Summary

This position is temporary and includes full state fringe benefits; it is anticipated to last three (3) years.

As an Advanced Data Analyst, analytical thinking, advanced level SQL skills, knowledge of working data process flows, and problem solving are the most critical skills required of this position. The nature of this role is instrumental in the success between analyzing data, documenting requirements, designing a solution, writing complex queries and making recommendations towards implementation of the system/project; it also places a premium on creative and effective problem solving, planning and analytical activities. This position must work effectively with the developer(s) and business owners to create solutions that meet user and technical requirements to ensure the data quality, and the functionality of the system is met and tested.

This position will assist with diverse data analysis activities for student loan data, data feeds, financial reporting and other areas at the Office of Higher Education as needed. This position will be a key staff member helping OHE with technical issues surrounding ad hoc data requests and will be expected to become proficient and be able to trouble shoot data issues and understanding the correlation between tables and multiple data sets used for OHE reporting.. This person will be expected to understand the technical design of data warehouse systems, identify issues and opportunities to enhance data management and reporting, and is responsible for both detailed and high-level problem solving, data analysis, and data extraction using SQL. They will create and maintain documentation.

This position requires an employee to work onsite at 1450 Energy Park Dr. Saint Paul, Minnesota at least 50% [or more or less if space limitations remain] of the time, with limited telework available. Telework eligibility depends on residence:
  • Candidates living in Minnesota or within 50 miles of the worksite in a bordering state (Iowa, North Dakota, South Dakota, and Wisconsin) may telework up to 50%.
  • Minnesota residents living more than 50 miles from the worksite may be eligible to telework more than 50%.
  • Candidates living 50 miles or more from the worksite in a bordering state may work onsite 100% or may be telework eligible if relocating within 50 miles.


Qualifications

Minimum Qualifications

Candidates must clearly demonstrate all of the following qualifications in their resume. Resume tips here. :

Position requires a minimum of four (4) years of IT related experience performing IT data analysis or quality assurance for large scale, enterprise business initiatives.

Experience must include:
  • Experience leading data analysis and data reconstruction efforts.
  • Experience with SQL, leading SQL development and code reviews.
  • Experience with data validation.
  • Experience providing technical support and administration for data systems.
  • Demonstrated ability to communicate clearly and effectively in a manner that facilitates mutual understanding.
  • Customer-focused approach grounded in active listening, empathy, and solution-oriented problem-solving to deliver positive user experiences.

Education in Information Technology (IT) or an IT related field may substitute for experience as follows: a master's degree or a bachelor's degree for one (1) year; and an associate's degree for six (6) months.

Preferred Qualifications
  • Knowledge of dimensional data modeling and physical database design.
  • Experience with various reporting/analytical dash-boarding products.
  • Knowledge of data warehousing.
  • Experience with statistical/trend analysis, data visualization, mining, operational reporting, analytical reporting, ad-hoc queries, executive dashboards, and report distribution.
  • Ability to troubleshoot, perform root-cause analysis, and propose solutions.
  • Ability to examine data structures, which may include Data Warehouse/BI Query, and utilize information obtained.

Additional Requirements

It is the policy of Minnesota IT Services that a successful candidate must pass all legally required checks prior to employment which may consist of the following:
  • SEMA4 Records Check (applies to current and past state employees only)
  • Criminal History Check
  • Reference Check
  • Social Security and Address Verification
  • Education Verification
  • Other legally required checks

Minnesota IT Services does not participate in E-Verify. Minnesota IT Services will not sponsor applicant for work visas, including F-1 STEM OPT extensions. All applicants must be legally authorized to work in the United States.

Application Details

How to Apply

Select "Apply for Job" at the top of this page. If you have questions about applying for jobs, contact the Careers Help Desk at 651-259-3637 or email [email protected] . For additional information about the application process, go to http://www.mn.gov/careers .

Contact

If you have questions about this position, contact Human Resources at w [email protected] .

Veterans

To be considered for any Veteran's Status , you MUST indicate this on your application.

RECENTLY SEPARATED VETERANS (RSV) : Effective July 1, 2009, legislation provides that the top five RSV applicants who apply and meet the qualifications for a vacancy shall be granted an interview. You must:
  1. Meet all Minimum Qualifications identified in this posting.
  2. Meet all of the RSV criteria.
  3. Submit a copy of your DD-214 form by the closing date to: w [email protected]

Current State Employees
  • Current State Employees: Please note that employment provisions (including but not limited to seniority and leave accrual) vary among the three branches of Minnesota State government. When considering a job with another branch of state government, you are highly encouraged to explore these differences. For assistance, please direct questions to your current or anticipated Human Resources office.


Benefits

As an employee, you'll have access to one of the most affordable health insurance plans in Minnesota, along with other benefits to help you and your family be well.

Your benefits may include:
  • Paid vacation and sick leave
  • 12 paid holidays each year
  • Low-cost medical, dental, vision, and prescription drug plans
    • Fertility care, including IVF
    • Diabetes care
    • Dental and orthodontic care for adults and children
  • 6 weeks paid leave for parents of newborn or newly adopted children
  • Pension plan that provides income when you retire (after working at least three years)
  • Employer paid life insurance to provide support for your family in the event of death
  • Short-term and long-term disability insurance that can provide income if you are unable to work due to illness or injury
  • Tax-free expense accounts for health, dental, and dependent care
  • Resources that provide support and promote physical, emotional, social, and financial well-being

Support to help you reach your career goals:
  • Training, classes, and professional development
  • Federal Public Service Loan Forgiveness Program (Some positions may qualify for the Public Service Loan Forgiveness Program. For more information, visit the Federal Student Aid website at studentaid.gov )

Employee Assistance Program (EAP) for work/life support:
  • A voluntary confidential program that helps employees and their families with life challenges that may impact overall health, personal well-being, or job performance
  • Common sources of stress can be addressed through the EAP: mental health, relationship challenges (personal and work), grief and loss, finances, and legal issues
  • Daily Living/Convenience Services: Chore services, home repair, trip planning, child/elder care


Programs, resources and benefits eligibility varies based on type of employment, agency, funding availability, union/collective bargaining agreement, location, and length of service with the State of Minnesota.

Similar Jobs

More Jobs at Minnesota Careers

More Information Technology Jobs

Find similar IT Advanced Data Analyst - ITS4 jobs: