Systems Analyst (Custom Reporting Solutions)

1 O.C. Tanner Company; Salt Lake City (UT); On-site; USD 85,000 - 120,000; Full time

Job summary

O.C. Tanner Company is seeking a Systems Analyst (Custom Reporting Solutions) to translate client reporting needs into effective data and process solutions.

You will analyze requirements, develop and validate reporting, and collaborate with clients and tech teams to deliver measurable value. The ideal candidate has hands-on SQL experience, strong communication, and a collaborative, client-focused approach to ensure accuracy, automation opportunities, and scalable reporting across multiple data

Qualifications

• Minimum 3 years in business analysis, systems analysis, data analysis, reporting, or a related technology role.
• Hands-on SQL experience and relational database knowledge.
• Ability to translate business needs into clear, actionable technical requirements and acceptance criteria.
• Strong communication skills and stakeholder management across business and technical teams.
• Bachelor's degree or equivalent practical experience.

Responsibilities

• Requirements Discovery and Analysis: gather, clarify, and document custom reporting needs and data flows.
• Custom Reporting Solution Delivery: design, engineer, test, implement, validate and support reporting solutions.
• Data Analysis, Validation and Quality: validate outputs against sources and acceptance criteria; ensure data quality.
• Stakeholder Partnership and Continuous Improvement: communicate progress, reduce manual work via automation, and share standards.

Skills

Business analysis

SQL

Communication

Attention to detail

Requirements gathering

Education

Bachelor's degree or equivalent

Tools

Snowflake

Oracle

Postgres

Job description

O.C. Tanner is the global leader in software and services that improve workplace culture through meaningful employee experiences. Our Culture Cloud is a suite of apps designed to enhance the employee experience with strategic recognition, service awards, wellbeing, leadership, and events that help people thrive at work. Our Culture by Design approach provides expert services to organizations looking to create great workplaces. Our global team of 1,500 people hail from 58 countries and speak 62 languages. As programmers, researchers, designers, client professionals and craftspeople we create the tech, tools and awards that connect employees to purpose at thousands of companies. Join us as we help people all over the world thrive at work.

The Systems Analyst (Custom Reporting Solutions)

The Systems Analyst (Custom Reporting Solutions) partners with clients, business stakeholders, and technology teams to translate custom reporting needs into effective system, data, and process solutions. Your day-to-day responsibilities will include analyzing requirements, developing and validating reporting solutions, identifying opportunities for improvement and automation, and helping ensure solutions deliver measurable client value. The ideal candidate combines strong analytical and communication skills, a high acumen for detail, with hands-on SQL experience and a collaborative, client-focused approach.

Key Responsibilities

• Requirements Discovery and Analysis Collaborate with clients and O.C. Tanner stakeholders to gather, clarify, and document custom reporting needs. Translate business needs into clear business and system requirements, scopes of work or memoranda of understanding, data process flows, acceptance criteria, and practical solution designs. Assess data availability, dependencies, risks, effort, and intended use cases, escalating complex issues as appropriate.
• Custom Reporting Solution Delivery Partner with Clients, Product, and Technology teams throughout delivery-from design and engineering through testing, automation, implementation, validation, and post-launch support. Develop custom payroll, tax, audit, compliance, and operational reporting solutions using SQL, data transformations, and calculations across multiple data sources. Create and maintain documentation for requirements, report logic, business rules, data mappings, testing, and deployment.
• Data Analysis, Validation and Quality Use SQL and relational data to analyze use cases, engineer custom reporting solutions, and research and resolve questions and unexpected outcomes. Validate report output against source systems, documented requirements, and acceptance criteria. Identify data quality issues, edge cases, and calculation discrepancies, and support root cause analysis and resolution. Apply established testing, reconciliation, and quality practices to help ensure accurate, scalable reporting.
• Stakeholder Partnership and Continuous Improvement Serve as a liaison between business and technical teams, clearly communicating requirements, decisions, risks, dependencies, progress, and outcomes. Facilitate working sessions and contribute recommendations that balance client value, delivery effort, maintainability, and product direction. Identify opportunities to reduce manual work through automation, reusable processes, and product enhancements. Share knowledge and contribute to team standards for requirements, documentation, report design, testing, and quality control.

Required Qualifications

At least 3 years of experience in business analysis, systems analysis, data analysis, reporting, or a related technology role. Experience eliciting, analyzing, and documenting business and system requirements. Ability to translate business needs into clear, actionable technical requirements, process flows, and acceptance criteria. Demonstrated hands-on experience with SQL and relational databases, including joins, aggregations, common table expressions, and data validation. Strong communication skills and the ability to build productive stakeholder relationships across business and technical teams. Strong analytical, organizational, and problem-solving skills, with high aptitude for accuracy and detail. Knowledge of software development and technology delivery practices, including testing and implementation. Ability to manage multiple assignments, priorities, and deadlines. A relevant bachelor's degree or equivalent practical experience.

Preferred Qualifications

Experience with payroll, tax, audit, compliance, or other client-facing operational reporting. Experience with enterprise data warehouses & relational databases such as Snowflake, Oracle, and Postgres. Experience partnering with Product, Engineering, Data, or software development teams. Familiarity with data governance, regulatory reporting, automation, or production support practices.

Success Measures

• Accuracy, completeness, and quality of custom reporting solutions.
• On-time delivery against agreed requirements and acceptance criteria.
• Clear, actionable requirements and effective communication across stakeholders.
• Timely resolution of reporting questions, discrepancies, and defects.
• Client and stakeholder satisfaction with delivered solutions.
• Reduction in manual effort through automation, reusable processes, and product improvements.

We create inspiring workplaces for some of the biggest and best companies in the world. And we do it within our own teams every day. That's one reason we made the Fortune 100 Best Companies to Work For® list in 2021. Join us and watch people thrive at work—including you. With seven global offices and employees working around the world, we're committed to creating an atmosphere where every person can share their talents and reach their potential.