"ERP/SIS and BI Reporting & Analytics Developer"

ERP/SIS and BI Reporting & Analytics Developer

Northeast Wisconsin Technical College is a nationally recognized and locally trusted college dedicated to advancing the success of all students and economic vitality of the communities we serve through access, high-quality education, and strategic partnerships.

The community that we serve is home to people with a rich range of backgrounds and experiences. We are committed to supporting an environment where all students and employees thrive and succeed. We believe every team member enriches our organization with unique skills, perspectives, and solutions. We seek applicants who are motivated and equipped to support all students, to work effectively with colleagues from a range of backgrounds, and to build the vibrancy of our community.

You belong here. See why you will love working at NWTC.

Department: Institutional Research - Strategy and Innovation

Reports To: Manager, Institutional Research

LOCATION: Green Bay

While our institution supports a hybrid work policy, this position is primarily in-person to best support team collaboration and customer needs. The exact hybrid schedule will be determined by the hiring manager based on the role's responsibilities and operational requirements. If you're looking for a role with some flexibility but enjoy being on-site and engaging with others, this could be a great fit for you!

STANDARD HOURS: 40 hours per week. Typical hours Monday - Friday 8:00 am - 5:00 pm; Flexibility required to include other evening and/or weekend hours, as necessary.

STARTING PAY RANGE: $80,515 - $86,777 per year

*Salaries/Wages for all finalists (internal and external) will be placed within the range based upon education, experiences, current wages, and internal equity.

POSITION SUMMARY

The ERP/SIS and BI Reporting & Analytics Developer is responsible for building and maintaining NWTC's ERP/SIS and BI reporting solutions and infrastructure for systems such as Workday and using tools such as Prism and PowerBI. Provide exceptional analytical skills, the ability to think creatively and strategically, collaboration with stakeholders, and ensure project scope, deadlines and expectations are satisfied.

ESSENTIAL FUNCTIONS

• Develop and modify general reporting solutions and BI dashboards for the SIS and all components of the ERP, including Financials and Human Capital Management (HCM).
• Develop reporting for specific functions of the SIS/ERP, including automation (Mass Operation Management), cohort generation, and data loads (inbound EIBs).
• Collaborate with stakeholders to outline requirements for reports and dashboards.
• Notify SIS/ERP Security experts of the appropriate access needed for reporting solutions and work with them on access workarounds as necessary.
• Train stakeholders on Workday reporting functions and available reporting solutions.
• Work with NWTC leadership to determine and implement reporting and dashboard strategies for Key Performance Indicators; define what is meant by KPIs and other metrics (data governance).
• Collaborate with ESAs and BSAs to set up and troubleshoot SIS/ERP configuration, business process logic, and other rule-based configuration.
• Collaborate with members of the Enterprise Applications, Institutional Research, and functional leads to prepare for semiannual updates with regression testing as needed and by replacing obsolete report fields with newer equivalents.
• Collaborate with Application Developers to provide calculated fields and/or reporting to be used in integrations and/or as web services in web applications (RaaS reports).
• Create, configure, and maintain inbound data load integrations (inbound EIBs) to assist in the automation of functional activities.
• Leverage BI tools, such as Workday Prism or PowerBI, to combine SIS/ERP data with data from other sources and overcome SIS/ERP reporting limitations

MINIMUM QUALIFICATIONS AND WORK EXPERIENCE

• Requires a minimum of a bachelor's degree in computer science, Information Systems, or a related field.
• Completion of Workday reporting training is required for this role, including the Workday Reporting class.
• Minimum 2 years of experience building reporting solutions in the Workday ecosystem. Experience with Workday Student a strong plus.
• Analyzing, developing new, enhancing existing and supporting production reporting solutions using Workday Report Writer and Power BI
• Troubleshooting and resolving problems found in supported reporting solutions
• Ability to create and modify Calculated Fields
• Ability to determine when to leverage Workday Prism and the ability to ingest and manipulate data with Workday Prism
• Ability to create and modify SQL queries
• Familiar with Workday BIRT and Composite Reporting
• Familiar with Workday Studio, Workday Orchestrate, Integrations (including inbound EIBs), the Workday Object model, Cohort reports, Mass Operation Management, and Security
• Familiar with XML, including the ability to decipher path references in XML responses
• Microsoft Office Suite and Internet Web Browsers.
• Designing, building, testing, implementing and documenting development effort
• Support of enterprise systems such as Workday and Power BI
• Excellent communications skills (both written and verbal), planning skills, and organizational skills
• Must have experience working with leaders at all levels
• Ability to establish and meet target dates; must be able to multi-task effectively and handle multiple development projects, and problem solve
• Handle confidential documents and information with the utmost discretion
• Working in a team-oriented environment
• Willing to work in Green Bay, WI

**An equivalent combination of education and work experience may be considered.

Preferred Qualifications:

• Preference for candidates with experience working with data and business processes for K-12 or Higher Education domains

Skills and Abilities:

• Student Success: Demonstrate behaviors and actions that support student recruitment, retention, and student success initiatives.
• Values: Demonstrate behaviors and action that support the College's values
• Collaboration: Demonstrate behaviors and actions that create respectful environments and services for all, and the ability to work effectively across differences in background and experience.

PHYSICAL DEMANDS

• Extended Sitting: Ability to sit for extended periods while working on a computer or attending meetings
• Mobility: Ability to move around the campus to attend meetings and events
• Manual Dexterity: Proficiency in using hands and fingers to handle or operate office equipment, tools, or controls.
• Visual and Auditory: Ability to read documents and communicate effectively with students and staff.
• Light Lifting: Capability to lift and carry materials weighing up to 25 pounds.