Business Intelligence Analyst

Position Summary

Focus on delivering data insights and developing reports for key departments including Human Resources, Student Services, Institutional Effectiveness, Accreditation and Quality, and Finance. This role will also involve meeting State and Federal Reporting requirements, as well as fulfilling grant reporting obligations. Work closely with business analysts and various college stakeholders, particularly within Institutional Effectiveness, Accreditation, and Quality, to ensure that all data needs are thoroughly addressed and met.

Duties & Responsibilities

Collaborate with College stakeholders to gather, understand, and document reporting requirements, developing complex reporting solutions.

Serve as the liaison between the Institutional Research team, the data center, and the ERP provider, ensuring effective communication and understanding of data structures.

Prioritize and manage project timelines, ensuring deadlines and goals are met.

Evaluate, design, and develop Power BI reports, SSRS reports, FRD reports (Financial Reporting Designer), and dashboards according to functional specifications while maintaining data integrity and data quality.

Build and maintain complex data models in Power BI that enable efficient reporting and analysis.

Use Power Query for data transformations and create calculated fields, measures, and KPIs.

Design efficient, scalable data models to handle large datasets and optimize performance.

Develop interactive Power BI visualizations, incorporating slicers and drill-through functionality to enhance data presentation.

Customize delivered SSRS reports to meet specific college requirements.

Write and optimize complex SQL queries to extract data from various data sources, ensuring efficient retrieval and processing of large datasets.

Work with internal stakeholders and the Anthology integration team members to define data calculations and extensions to data sets, analyze, and test additions to datasets.

Participate in the full development lifecycle, from analysis through to implementation, testing, and providing ongoing reporting support.

Ensure accurate and timely completion of state and federal reporting requirements for institutional data, including IPEDS, NC SARA, and other relevant entities.

Provide extensive support to the user community in User Acceptance Testing, Integration Testing, and Regression Testing.

Validate data quality across multiple systems, including legacy systems, data warehouses, and the new Student Information System, presenting findings for review.

Assist business users with Power BI functionality, addressing any troubleshooting needs and offering guidance.

Understand the current data warehouse reporting structure.

Maintain security of confidential student and employee information.

Respond to ad-hoc reporting requests and provide customized analyses as needed by the College.

Other duties as assigned.

Qualifications

Bachelor's degree in Computer Science, Data Analytics, Management Information Systems, Business Information Technology, or related field required. A combination of education and experience may be considered.

Minimum of 3 years of experience required in Microsoft SQL Server development, SSRS, Microsoft Power BI and / or Microsoft Dynamics, or similar tools, including ability to develop reports and write complex SQL queries.

Experience working with a data warehouse and completing enterprise data migrations / conversions from one system to another system as part of an implementation preferred.

Experience with data modeling.

Knowledge of Higher Education, Enterprise Resource Planning systems (ERP), and / or CRM Systems preferred.

Must possess excellent problem resolution, organizational, interpersonal, communication, and project management skills.

Must possess ability to :

• Achieve a satisfactory level of technical, functional, and / or professional skill or knowledge in position-related areas; keep up with current developments and trends in areas of expertise; leverage expert knowledge to accomplish results.
• Identify and understand problems and opportunities by gathering, analyzing, and interpreting quantitative and qualitative information; choose the best course of action by establishing clear decision criteria, generate and evaluate alternatives, and make timely decisions; take action that is consistent with available facts and constraints and optimizes probable consequences.
• Effectively manage time and resources to ensure that work is completed efficiently.
• Accomplish tasks by considering all areas involved, no matter how detailed; show concern for all aspects of the job; accurately check processes and tasks; be watchful over a period of time.
• Maintain effectiveness when experiencing major changes in work responsibilities or environment (e.g., people, processes, structure, or culture); adjust effectively to change by exploring the benefits, trying new approaches, and collaborating with others to make the change successful.
• Take prompt action to accomplish work goals; take action to achieve results beyond what is required; be proactive.
• Set high standards of performance for self and others; assume responsibility and accountability for successfully completing assignments or tasks; self-impose standards of excellence rather than having standards imposed.
• Demonstrate a positive attitude and approach toward work.

Must embrace Mid-State's core values of student centeredness, commitment, accountability, respect, integrity, and exceptional service.

Compensation & Benefits

Compensation is dependent upon experience and qualifications.

Benefits include health, dental, and vision insurance; life insurance; short-term and long-term disability; paid time off and holidays; flexible spending account; Wisconsin Retirement System; 403(b) and 457; employee assistance program; educational assistance; and employee wellness program.

How To Apply

To be considered for this position, you must complete an online application. You should have the following information available when completing an application :

Application materials submitted via mail, fax, email, or in-person will not be considered.

Incomplete applications or applications noting "See Resume" will not be considered.

Continuous recruitment with first review of completed applications starting February 7, 2025. Applications received on or after February 7th may be considered in a secondary pool.

Please note that Mid-State's main form of communication during the recruitment process is email. In addition to receiving communications from email addresses with an @mstc.edu domain, you may receive emails from donotreply@invalidemail.com. Please be sure to watch your inbox as well as junk, spam, and clutter folders.

Equal Opportunity

Mid-State Technical College, an equal opportunity employer and educator, does not discriminate on the basis of race, color, national origin, gender, disability, sexual orientation, or other applicable legislated categories, in its services, employment programs, and / or its educational programs and activities, including but not limited to admission, treatment, and access. Mid-State Technical College provides reasonable accommodations to assist persons with disabilities to access or participate in its programs and activities. The following person has been designated to handle inquiries regarding the nondiscrimination policies : VP-Human Resources, 32nd Street N, Wisconsin Rapids, WI 54494, Phone : 715-422-5325 or Email : aaeo@mstc.edu.

Optimize Your Online Application Experience

Below you will find a few technical tips to help ensure a positive and successful online application experience :

Edge

Firefox

Chrome

Safari

Windows 7, 8 and 10, both 32-bit and 64-bit, as well as Mac OS 10.6 and greater.

If you experience issues in submitting your online application, please contact Human Resources at 715.422.5568.