IT Advanced Data Analyst - ITS4

• Designated in Connect 700 Program for Applicants with Disabilities (https://mn.gov/mmb/careers/diverse-workforce/people-with-disabilities/connect700/) : No

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.

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 (https://mn.gov/mmb-stat/policies/1422-telework.pdf) 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.

Candidates must clearly demonstrate all of the following qualifications in their resume.** Resume tips here. (https://mn.gov/mnit/about-mnit/careers/hiringprocess.jsp) **:

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.