{bc}
Apply
workday

Systems Analyst (Custom Reporting Solutions)

O.C. Tanner
USA
Full-time
Mid · 3+ years experience
Onsite
Discovered 2 days ago
snowflakesql

Full Job Posting

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

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.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at O.C. Tanner

Associate Product Designer

, USA

Discovered 2 days agoFull-time

Client Success Specialist

, USA

Discovered 3 days agoFull-time

Systems Analyst

, USA

Discovered 1 weeks agoFull-time

Principal Product Content Strategist

, USA

Discovered 3 weeks agoFull-time

Sales Advisor-Park City Jewelry Store

, USA

Discovered 3 weeks agoFull-time

Manager, DevOps

, USA

Discovered 3 weeks agoFull-time

Painter / Finisher

, USA

Discovered 3 weeks agoFull-time

Sr Executive - Client Success

Mumbai, IND

Discovered 3 weeks agoFull-time