Business Intelligence Analyst

Mid-State Technical College - Marshfield, WI

Full-time - Mid Level

Marshfield, WI

Executive, Legislative, and Other General Government Support

About the position

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.

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.

Requirements

• 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.

Nice-to-haves

• 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.
• Ability to 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.
• Ability to effectively manage time and resources to ensure that work is completed efficiently.
• Ability to accomplish tasks by considering all areas involved, no matter how detailed; show concern for all aspects of the job; accurately check processes and tasks.
• Ability to maintain effectiveness when experiencing major changes in work responsibilities or environment.
• Ability to take prompt action to accomplish work goals; take action to achieve results beyond what is required; be proactive.
• Ability to set high standards of performance for self and others; assume responsibility and accountability for successfully completing assignments or tasks.
• Demonstrate a positive attitude and approach toward work.

Benefits

• 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
• Employee wellness program