Associate Data Analyst & JIRA Admin

Job Description

Who We Are:

O.C. Tanner is the global leader in providing solutions designed to help companies improve workplace culture through meaningful employee experiences. We connect people to purpose, accomplishment, and one another at thousands of the most respected companies on earth. O.C. Tanner offers competitive pay with a host of benefits designed to attract and retain talented employees.

Job Description:

The O.C Tanner Company is looking for a qualified individual to provide data analysis in our Client Success team. This job is an entry level position working primarily with data sets and Excel to extract, analyze, and report on data from multiple systems including but not limited to: SAP, MS Dynamics, Sharpen, Sharepoint, and Jira. This data is used primarily to help guide our leaders and company through KPIs and related metrics. This position will also be a Jira Administrator for Client Success who heavily relies on Jira for workflow and other processes. A successful candidate will have strong technical expertise and be well versed with programming logic, a master in Excel, as well as strong interpersonal and communication skills.

Objectives Deliverables:

• Query various systems to import, transform, validate, and analyze data required for various business needs
• Create visualizations from data that are easy to digest and tell a meaningful story
• Provide standard and custom business and client reports on regular intervals
• Collaborate with stakeholders to gather business requirements and create ad-hoc custom reports
• Provide data driven insights to help leaders make crucial business decisions
• Create dashboards in various systems to help the business understand performance in real time
• Create documentation, training and standards for reporting across Client Success teams
• Ensure data integrity through careful examination and review
• Interface with key stakeholders, business leaders and team members to understand needs and requirements
• Create and maintain effective documentation on processes, reporting, and other solutions
• Collaborate with BI team in IT to escalate particularly challenging reporting requirements

Job Requirements

Skills and Abilities:

• Advanced knowledge of Microsoft Excel
• Experience with handling large data sets and databases and complex formulas
• Knowledge of relational databases and SQL*Plus
• Ability to run VBA and OfficeScripts
• Demonstrated skills with charts, graphs, pivot tables, vlookup, and other Excel capabilities
• Self-motivated, flexible, team player with solid multi-tasking, time management organization expertise with the ability to manage multiple and often changing priorities
• Assist in managing users, roles, security profiles in Jira
• Respond to issues or questions from Jira users through out the organization, resolve technical and functional support issues
• Ability to present insights and data visually and verbally to stakeholders
• The ideal candidate is customer focused, action-oriented and committed to driving quality results