Senior Analyst - Information Systems

Paycom - ATS; Stillwater (OK); On-site; USD 80,000 - 110,000; Full time

Job summary

OSU Alumni Association in Stillwater, OK seeks a Senior Analyst – Information Systems to lead its data systems and analytics initiatives. You will develop automated processes, maintain databases, and provide staff with technical guidance to maximize data insights.

Requirements include a bachelor's in MIS or CS and 5+ years in IT, with strong SQL, data analytics, and familiarity with AI tools such as Microsoft Copilot. This on-site role supports events and occasional after-hours work.

Qualifications

• A bachelor's degree in MIS or computer science with database focus is required.
• 5+ years in information technology, database management, or data analytics.
• Experience writing SQL queries and delivering data to stakeholders.
• Familiarity with AI tools, specifically Microsoft Copilot.

Responsibilities

• Lead and maintain data systems and databases for OSU Alumni Association.
• Develop automated business processes and data warehouse queries.
• Provide in-house IT support and coordinate with outside vendors as needed.
• Synchronize data between Alumni Association website and other systems.
• Provision and manage staff hardware; oversee telecom needs.
• Train staff on standard software applications and databases.

Skills

SQL queries

Object-oriented programming

Data analytics

Microsoft Copilot

Communication skills

Adaptability

Education

Bachelor's degree (MIS or CS)

Tools

Snowflake

Workato

Ascend/Salesforce database

Tableau

Visual Studio Code

Microsoft Office Suite

Microsoft Copilot

Encompass

Job description

Job Title: Senior Analyst – Information SystemsReports To: Vice President of Finance and OperationsFLSA Classification: ExemptNature of Work:The Senior Analyst – Information Systems is the technical lead for Information Systems at the OSU Alumni Association. This position develops and maintains various data systems and databases and provides technical guidance and support to staff.Responsibilities:Program ManagementDevelop and maintain automated business process programsReview, analyze, and evaluate database systems and user needs to provide recommendations and solutions parallel to overall business strategiesDevelop programs and systems to synchronize data between the Alumni Association website and other data systemsCreate, maintain, and execute data warehouse queriesProcess data requests and develop custom reports utilizing data from multiple sources, including the Alumni Association constituent databaseProvide in-house expertise and technical support to end users on database, software, and desktop-related issues:Identify, research, and resolve technical problems, working with outside vendors/technical support as needed, and documenting, tracking, and monitoring problems to ensure a timely resolutionProcure, provision, and manage staff hardware, including laptops, monitors, and peripheralsProvide technical guidance to OSUAA Information Services teamManage telecom needs of staff coordinating with OSU Information ServicesPerform other duties as assignedOrganizational StrategyTrain staff in the use of the Alumni Association's standard software applications/databases, as neededCollaborate with the OSU Foundation and OSU Information Technology to remain informed on software projects, updates, upgrades, and additional services, including the use of AI technologyMaintain goals and objectives by providing data and analytics for information services supporting alumni association programsProvide excellent customer service to all constituents requesting queries and IT supportFacilitate the effectiveness of the Information Services teamJob Competencies and Experience:EducationA bachelor's degree is required, preferably in Management Information Systems or computer science with an emphasis in database management.SQL database experience and object-oriented programming experience are required.ExperienceFive or more years of experience in information technology, database management, or data analytics.Skills:Experience using a production environment and automating data flows between diverse data systemsExperience writing SQL queries and delivering data to stakeholdersAnalytical skills to evaluate current systemsFamiliarity with AI tools, specifically Microsoft CopilotStrong communication skillsAbility to prioritize workload and complete activities without close supervisionCore Competencies:Effective Communication: Promotes the timely, seamless flow of high-quality information throughout and beyond the organization while encouraging the open exchange of ideas and opinions.Execution & Initiative: Makes decisions authoritatively and wisely, after adequately contemplating various available courses of actionTeamwork & Interpersonal Skills: Fosters development of a common vision; coaches, motivates, encourages and gains support to accomplish specific goalsProblem Solving & Judgement: Makes decisions on sound reasoning, evaluation of facts and consideration of alternatives; negotiates between disagreeing viewpoints with tact and diplomacyAdaptability: Changes behavioral style or method of approach when necessary to achieve a goal; adjusts style as appropriate to the needs of the situationEquipment Used:SnowflakeWorkatoAscend/Salesforce databaseTableauMicrosoft Visual Studio CodeMicrosoft Office SuiteMicrosoft CopilotEncompass web platformWork Environment:The position is in an office setting within the OSU Alumni Center. Events and activities may be held outside, so there will be some outdoor exposure. The position requires availability to work nights and weekends supporting systems and scheduled events.Physical Demands:Position needs to move about inside the office to access file cabinets, office machinery, etc.Position needs to be able to transport parcels, packages, and other items short distances, and drive a vehicle to deliver and pick up materialPosition frequently communicates with staff and must be able to exchange accurate informationFrequently move items weighing up to 50 poundsSpecial Condition for Employment: Successful completion of a background checkThis job description is not designed to cover or contain a comprehensive list of activities, duties, or responsibilities required of each employee. Duties, responsibilities, and activities may change, or new ones may be assigned at any time with or without notice.