Systems Analyst (Custom Reporting Solutions)

O.C. Tanner•Salt Lake City, UT

About The Position

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. The role analyzes requirements, develops and validates reporting solutions, identifies opportunities for improvement and automation, and helps ensure solutions deliver measurable client value. The ideal candidate combines strong analytical and communication skills, attention to detail, hands-on SQL experience, and a collaborative, client-focused approach. Success is measured by the accuracy, completeness, and quality of reporting solutions; on-time delivery; clear requirements and stakeholder communication; timely resolution of reporting questions and defects; client and stakeholder satisfaction; and reduced manual effort through automation and reusable processes.

Requirements

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.
Hands-on experience with SQL and relational databases, including joins, aggregations, common table expressions, and data validation.
Strong communication skills and ability to build productive 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.

Nice To Haves

Experience with payroll, tax, audit, compliance, or other client-facing operational reporting.
Experience with enterprise data warehouses and 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.

Responsibilities

Collaborate with clients and O.C. Tanner stakeholders to gather, clarify, and document custom reporting needs.
Translate business needs into 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.
Partner with Clients, Product, and Technology teams throughout delivery, including design, engineering, 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.
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.
Serve as a liaison between business and technical teams, clearly communicating requirements, decisions, risks, dependencies, progress, and outcomes.
Facilitate working sessions and recommend approaches 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.