Data Reporting Specialist - Information Technology Specialist 2

CENT - White Bear Lake/Mahtomedi Campus, United States

⚠️ We'll shut down after Aug 1st - try foo🦍 for all jobs in tech ⚠️

Minnesota State

Homepage for the Minnesota State Colleges and Universities system. Minnesota State consists of 33 public colleges and universities with 54 convenient campuses throughout Minnesota.

View all jobs at Minnesota State

Apply now Apply later

All Job Postings will close at 12:01 a.m. CT on the specified Closing Date (if designated).

Working Title:

Data Reporting Specialist - Information Technology Specialist 2

Institution:

Century College

Classification Title:

Information Technology Spec 2

Bargaining Unit / Union:

214: Minnesota Association of Professional Employees

City:

White Bear Lake

FLSA:

Non Job Exempt

Full Time / Part Time:

Full time

Employment Condition:

Classified - Unlimited

Salary Range:

$27.76 - $45.14

Job Description

Position Purpose

This person has primary campus responsibility for providing data and reporting services including creating real-time, dynamic, online, user-customizable and pre-made reports as well as fulfilling ad-hoc data requests as requested by Administrative and Academic Departments for the college.  This person will participate in technical design, programming, report generation, and will utilize relational databases within these applications.

Position Responsibilities

  • Database and Reporting Requests/Development.  This could include but is not limited to the following:

    • Works with a variety of parties on campus to identify data needs for data-driven decision making.

    • Writes Microsoft SQL queries to satisfy data requests.

    • Develops online real-time and pre-made (canned) reports (Microsoft Power BI Report Server).

    • Develops OLAP database structures.

    • Understands database structures to store college data.

    • Understands stored procedures to manage and populate databases and reports.

    • Generates and maintains documentation of work, best practices and data dictionaries.

    • Able to create workflow analysis, requirements statements, objectives, and data and process models.

    • Utilize data warehouse data to generate reports and lists as requested.

    • Utilizes secure data reporting and database management practices; ensures data security for all work.

    • Maintain working knowledge of Database Management Systems, development tools and languages.

  • Participate as a regular member of the Development Team to contribute to the strategies, goals, and objectives for the group.

Salary Range:

$27.76 - $45.14/hour

(DOQ – Salary Placement will be done at time of hire.)

Minimum Qualifications

  • 2 years of experience with enterprise technologies that support combining, preparing, analyzing and visualizing data (e.g. Power BI, ODI, SharePoint).

  • 2 years of experience with Microsoft SQL Server, including Reporting Services.

  • 2 years of experience with Microsoft SQL Server Analysis Services, or similar OLAP database experience

  • Experience with an enterprise level database engine such as Oracle or MS SQL.

  • Excellent written and verbal communication skills, enabling effective collaboration with a wide range of internal and external stakeholders.

  • Ability to clearly and readily communicate technical information to both technical and non-technical personnel.

Preferred Qualification 

  • Working knowledge of MS Access.

  • Advanced knowledge of stored procedures and views.

Other Requirements

To facilitate proper crediting, please ensure that your resume clearly describes your experience in areas listed and indicates the beginning and ending month and year for each job held.

This position requires successful completion of employment references and a driver’s license background check.

Work Shift (Hours / Days of work)

Monday – Friday 8:30am – 5:00pm

Telework (Yes/No)

Yes - *Century currently operates in a hybrid work environment. The hiring manager will provide guidance to the type of work environment at/following the interview process.

Application Procedure

To bid on this position, an employee of Century College must currently work in an Information Technology Specialist 2 position in a different work area or different shift. To bid, please submit a written request (email is sufficient) to Kim Claggett, in Human Resources.

Internal Applicants - Please make sure your applications materials reflect how you appear in Workday.

All current Century College and Minnesota State employees will need to log into Workday to apply for the position via the Jobs Hub. The Jobs Hub can be found under the Menu, in the upper left-hand corner of Workday, under the Apps, and then Jobs Hub. Employees may also search for “Browse Jobs – Employees” in Workday via the search bar at the top to view open positions.

External Applicants - Please make sure to use your legal name on your application materials.

Applicants not currently employed by Minnesota State can access the career site to search and apply for jobs, and to check the status of applications. Those applying for a position will be prompted to create a profile in Workday. This does include other state of Minnesota employees who work for agencies other than Minnesota State.

Please upload the following documents to your application.

  • Cover letter/letter of interest. (That includes a description of your demonstrated commitment to student diversity, equity, and inclusion in teaching.)

  • Current resume.

You can upload the required application documents under the Resume/Cover Letter section with a maximum total of 5 documents. If you have more than that then they will need to combine documents to upload. Photographs do not download with the rest of your application documents, so please make sure all your documents are PDF or Word documents.

These documents should be word documents or PDF (no jpeg) and are required for your application to be considered complete so not attaching all the required documentation will not allow you to move forward in the process.

Candidates having issues with job applications (i.e., unable to apply) or needing accommodations can email: careers@minnstate.edu . Inquiries about application status or general questions about the position should be directed to jobs@century.edu

For additional information about the application process, go to our Employment page on our main Century College site, https://www.century.edu/home/employment/, click on Current Employment Opportunities for more information

About

Century College is a 2-year community and technical college in White Bear Lake, Minnesota.

As one of the largest two-year colleges in Minnesota, we serve nearly 18,000 credit and non-credit students every year.

We offer degrees, diplomas, certificates, and courses in general education and transfer, business, human services, health sciences, technology, engineering, applied design, industrial, and non-credit workforce training.

With various student support and student life opportunities, including athletics, student clubs and organizations, campus theatre, Multicultural Center, LGBTQ Center, Veterans Center, and much more, Century College provides a welcoming and vibrant campus community.

As a “community” college, we care about our locality. We are engaged, connected, and a resource within our local communities, including K-12 and workforce/industry partners.

Century College. Discover What’s Next!

To learn more about Century College or Minnesota State, visit https://www.century.edu/ or www.minnstate.edu

For questions, please contact Century College Human Resources at jobs@century.edu

Notice of Annual Security Report Availability: Century College is committed to assisting all members of our community in providing for their own safety and security.  The Annual Security Report is available on the Century College Department of Public Safety website at https://www.century.edu/home/public-safety   If you would like to receive a paper copy of the Annual Security Report which contains this information, you can contact the Century College Department of Public Safety on East Campus room E1411 or by calling 651-444-2910.

Link to Century College’s Non-Discrimination Statement

https://www.century.edu/about/non-discrimination-statement

Benefits Information:

At Minnesota State, we have a GREAT BENEFITS PACKAGE! Our generous benefits include 11 paid Holidays, Vacation Time, Sick Time, six weeks of Paid Parental Leave, low cost medical and dental insurance with low deductibles ($250 - $1500), a Pension Plan, 457(b) and 403(b) retirement plans and other retirement investment options, pre-tax medical and dental expense (with roll-over option) and dependent care accounts, employer paid life insurance, short and long term disability, as well as professional development and a tuition waiver program for employees and their dependents, etc.  We promote the health and well-being of our employees and take work/life balance seriously.

Desired Start Date:

09-03-2025

Position End Date:

Open Date:

07-31-2025

Close Date:

08-15-2025

Posting Contact Name:

Kim Claggett

Posting Contact Email:

kim.claggett@century.edu
Apply now Apply later
Job stats:  0  0  0

Tags: Classification Data warehouse Driver’s license Engineering Industrial MS SQL OLAP Oracle Power BI RDBMS Security SharePoint SQL Teaching

Perks/benefits: Career development Equity / stock options Health care Insurance Medical leave Parental leave Unlimited paid time off

Region: North America
Country: United States

More jobs like this