Business Intelligence Analyst

Position Summary Transform lives by focusing on generating data insights and creating reports for key areas, such as: Human Resources, Student Services, Institutional Effectiveness, Accreditation and Quality, and Finance This role also includes ensuring compliance with state and federal reporting requirements, as well as grant-related reporting. Collaborate closely with business analysts and college stakeholders, especially within Institution Effectiveness, Accreditation, and Quality, to ensure all data needs are effectively identified and fulfilled. This is not a remote position and will require an on-campus presence. 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), PeopleSoft queries, and College 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. Act as the primary administrator and subject matter expert for Power BI service. Lead tenant-level administration, including configuration, governance policies, and capacity management. Manage Power BI security and access control, including roles, permissions, and data protection policies. Stay current with Power BI and Microsoft Fabric updates, recommending improvements and innovations. 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: 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: Contact information (addresses, phone numbers) Employment History Education Electronic copy of resume and transcripts 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 May 18, 2026. Applications received on or after May 18th 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 domain, you may receive emails from . 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: or Email:. Optimize Your Online Application Experience Below you will find a few technical tips to help ensure a positive and successful online application experience: Be sure to fill in each field in the application. You will receive an error message at the time of submission and your application will not be submitted if each required field is not filled in. Avoid clicking the back, forward, or refresh buttons while applying. Doing so will interfere with the submission and may result in data loss. Clear your browser's temporary files/cache and cookies prior to beginning the application. Disable pop-up blockers. Do not bookmark or favorite the application. Navigate to the careers site each time you wish to access your saved/submitted application. Your application session will remain open for 24 hours assuming you do not close your browser. To ensure submission, complete the application process within that time frame. The following browsers are currently supported: Edge Firefox Chrome Safari The following operating systems are currently supported: 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 .

Position Summary Transform lives by focusing on generating data insights and creating reports for key areas, such as: Human Resources, Student Services, Institutional Effectiveness, Accreditation and Quality, and Finance This role also includes ensuring compliance with state and federal reporting requirements, as well as grant-related reporting. Collaborate closely with business analysts and college stakeholders, especially within Institution Effectiveness, Accreditation, and Quality, to ensure all data needs are effectively identified and fulfilled. This is not a remote position and will require an on-campus presence. 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), PeopleSoft queries, and College 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. Act as the primary administrator and subject matter expert for Power BI service. Lead tenant-level administration, including configuration, governance policies, and capacity management. Manage Power BI security and access control, including roles, permissions, and data protection policies. Stay current with Power BI and Microsoft Fabric updates, recommending improvements and innovations. 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: 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: Contact information (addresses, phone numbers) Employment History Education Electronic copy of resume and transcripts 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 May 18, 2026. Applications received on or after May 18th 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 domain, you may receive emails from . 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: or Email:. Optimize Your Online Application Experience Below you will find a few technical tips to help ensure a positive and successful online application experience: Be sure to fill in each field in the application. You will receive an error message at the time of submission and your application will not be submitted if each required field is not filled in. Avoid clicking the back, forward, or refresh buttons while applying. Doing so will interfere with the submission and may result in data loss. Clear your browser's temporary files/cache and cookies prior to beginning the application. Disable pop-up blockers. Do not bookmark or favorite the application. Navigate to the careers site each time you wish to access your saved/submitted application. Your application session will remain open for 24 hours assuming you do not close your browser. To ensure submission, complete the application process within that time frame. The following browsers are currently supported: Edge Firefox Chrome Safari The following operating systems are currently supported: 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 .

• Government Careers

Show more