Systems Analyst (Custom Reporting Solutions)

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) 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.