Junior Reporting Analyst jobs in Norman, OK

VISION: Transform the university through the power of generosity.

MISSION: Unite donor passions with university priorities to elevate the impact of Oklahoma State University.

DEPARTMENT PURPOSE: The Information Services department serves the OSU Foundation and its partners by providing administrative, development, and strategic oversight of the organization’s fundraising and accounting applications and databases (ascend and FE NXT), digital engagement infrastructure, reporting solutions, and data management systems. It involves aligning fundraising objectives with user accessibility to information required for immediate and long-tern business success. Collaboration with cross-functional teams, including software developers, data analysts, and foundation and university stakeholders is critical.

PRIMARY PURPOSE: The Business Reporting Analyst is responsible for providing daily operational support to business users via the KACE ticketing system. This position may also provide key data insights for the OSU Foundation and its OSU system partners through applications such as Tableau, MS Visual Studio, SSRS, Salesforce, and other analytical software tools.

KEY AREAS OF FOCUS:

Primary Responsibility #1

• Interpret and transform information to provide data visualizations and reporting solutions for delivery in support of business strategies and/or fundraising initiatives.

Primary Responsibility #2

• Provide support to the Business Intelligence Developer as it pertains to the Annual Giving Department direct marketing needs, Event Management Team communications and systems tracking, list requests, and the OSUF mass communication process.

Primary Responsibility #3

• Learn the OSUF business model and best practices for data analysis and mass communication practices using SQL. Snowflake, Tableau, ascend, Salesforce, and Marketing Cloud Email platforms to provide daily operational support for business users and campus partners.

Primary Responsibility #4

• Collaborate with Application Administration and Development and Data Intelligence and Analytics teams to align report development with business needs and ensure conformance with OSUF Information Strategy standards and OSU needs.

Primary Responsibility #5

• Maintain documentation, including technical specifications, data mapping, program logic, flowcharts, and user level documentation for training and troubleshooting purposes.

Other duties as assigned.

JOB COMPETENCIES AND EXPERIENCE:

Education & Certifications-

• An undergraduate degree in a computational field (accounting, Finance, MSIS, etc.) or related discipline is preferred; or the combination of education and experience that enables performance of all aspects of the position.

Desired Experience-

• Strong Data Visualization Experience with Tableau.
• Experience with Report Development using SQL Reporting Services (SSRS)
• Strong analytical and visualization skills to assess problems and determine creative solutions.
• Statistical knowledge around data modeling, cluster analysis, A/B Testing, linear/logistic regression.
• Proficiency in SQL, writing queries, and troubleshooting query performance.
• Experience with Salesforce Customer Relationship Management Software
• Strong experience with Microsoft Office, especially Excel.
• Knowledge and experience with ETL, Cloud Warehousing, and AI preferred.
• Ability to learn OSUF applications including Financial Edge NXT, Marketing Cloud, GitHub etc.
• Eye for consistency and maintaining an established report brand.
• Attention to detail and the ability to meet deadlines is a must.
• Strong interpersonal skills and proven sense of humor with the ability to have fun.

Organizational Competencies-

• Effective Communication: Proactively ensures effective communication throughout the organization; makes relevant contributions to discussions and meetings, giving clear and concise explanations and sticking to the point; chooses language and communication method to suit the audience, reframes and articulates to help others understand; asks questions to check understanding when disseminating information.
• Execution & Initiative: Motivates self and others to achieve the best results, displaying energy, drive and a desire to succeed; enlists the support of others as necessary to overcome resistance; supervises cross-functional project team execution on tasks to meet stated objectives; helps other employees’ gain the skills and experience they need to contribute; pro-actively outlines milestones, outcomes and deliverables and effectively communicates them to internal and external stakeholders.
• Teamwork/Interpersonal Skills: Develops and nurtures formal & informal relationships with a wide circle of people beyond those involved in current activities, including potential donors, stakeholders, and information links; encourages collaboration among colleagues, departments and entire organization to achieve results; compromises, handles conflicts, seeks common ground, articulates own and others goals; stays focused on positive win-win outcomes; seeks input on how to leverage existing processes to improve the donor experience; translates ideas into action
• Problem Solving/Judgment: Gains understanding of how to apply approved policies and procedures; when and why escalation of issues is needed and to whom and communicates decisions and desired outcomes to others; anticipates the outcome of a single decision; recognizes problems in advance, systematically gathers information to define the root cause, breaks down complex information into component parts, develops alternatives, seeks input from others, selects and recommends the best solution
• Adaptability/Flexibility: Embraces complex or first-time problems as opportunities to learn and incorporate new skills; flexes style based on immediate needs; accepts responsibility for implementing change; evaluates and manages resources needed to implement change; personally supports (in words and actions) organizational direction and change agenda.
• Courage & Conviction: Takes responsibility for individual & project outcomes regardless of success and learns from all results; encourages candid responses, feedback, new ideas and conflicting opinions.
• Donor Centered: Takes time to actively learn about the stated needs by asking questions, exploring how to unite the donors and university’s passions and priorities; anticipates customer needs and proactively makes recommendations.

PHYSICAL REQUIREMENTS: Must use a computer terminal and view a computer screen for extended periods of time. Must talk in person or by phone (frequently and sometimes for extended periods) to internal staff. Must constantly use visual acuity to check printed and designed materials of various types. Must be able to navigate within the OSU Foundation. Typical office working conditions.