Advanced Data Analyst | Minnestar

Minnesota IT Services
06/17/2024

Working Title: Advanced Data Analyst
Job Class: Information Technology Specialist 4
Agency: Minnesota IT Services

  • Job ID: 76883
  • Location: St. Paul
  • Telework Eligible: Yes #LI-Hybrid
  • Full/Part Time: Full-Time
  • Regular/Temporary: Unlimited
  • Who May Apply: Open to all qualified job seekers
  • Date Posted: 06/06/2024
  • Closing Date: 06/17/2024
  • 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: $34.95 – $57.65 / hourly; $72,975 – $120,373 / annually
  • Job Class Option: Data Systems
  • Classified Status: Classified
  • Bargaining Unit/Union: 214 – Professional Employees (MAPE)
  • FLSA Status: Exempt – Administrative
  • Designated in Connect 700 Program for Applicants with Disabilities: Yes

The work you’ll do is more than just a job.

At the State of Minnesota, employees play a critical role in developing policies, providing essential services, and working to improve the well-being and quality of life for all Minnesotans. The State of Minnesota is committed to equity and inclusion, and invests in employees by providing benefits, support resources, and training and development opportunities.

Join the 2,600+ professionals of Minnesota IT Services (MNIT) who connect Minnesotans to services that will improve their lives. This position serves our partners at the Minnesota Office of Higher Education (OHE). MNIT OHE designs and supports large and complex database and reporting systems. The team leads the technical design of agency systems, business practices, and process automation. 

Job Summary

As an Advanced Data Analyst, analytical thinking, 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 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 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 BI tools and will be expected to become proficient and be able to trouble shoot data issues and create additional reporting for OHE. 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. They will create and maintain documentation.

This position is currently eligible for full-time telework: 

  • Telework for Minnesota IT Services allows an employee to perform work from a telework location and an employee may be required to be in the office based on business needs and other dependencies in St. Paul, Minnesota. 
  • Only candidates located in Minnesota and bordering states (Iowa, North Dakota, South Dakota, or Wisconsin) are telework eligible. 

Qualifications

Minimum Qualifications

Candidates must clearly demonstrate all of the following qualifications on their resume: 

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 business intelligence efforts.
  • Experience with SQL, leading SQL development and code reviews.
  • Experience with data validation.
  • Experience providing technical support and administration for data systems.
  • Ability to deliver effective verbal or written messages that facilitate a mutual understanding on both parties.
  • Customer service skills that include active listening, empathy, and problem-solving.

**A master’s degree in Information Technology or an IT related field substitutes for three (3) years of experience, OR an IT related bachelor’s degree substitutes for two (2) years, OR an IT related associate’s degree substitutes for one (1) year.

Preferred Qualifications

  • Advanced SQL skills.
  • 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 and perform root-cause analysis.
  • 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 will not sponsor applicants for work visas, including F-1 STEM OPT extensions. All applicants must be legally authorized to work in the United States.

Job Type: Full-time
Compensation: $34.95 - $57.65 / hourly - $72,975 - $120,373 / annually
Compensation Type: Salaried
Location: St Paul, MN - Telework
Posted by Karla Larson on June 6, 2024