Logo for CTG

IT Business Analyst – Finance Systems (SAP and OneStream)

Role overview

Summary

This role supports financial data integration, reconciliation, and reporting across SAP, Oracle databases, and OneStream. You will partner with Finance stakeholders and technical teams to gather requirements and validate reporting results, ensuring accurate financial data management.

Qualifications

  • Minimum 5 years of relevant IT business analysis or financial systems experience.
  • Strong understanding of accounting and financial processes, including general ledger, journal entries, trial balances, fiscal periods, and currencies.
  • Hands-on SAP ECC or S/4HANA Finance experience, including researching balances and accounting documents.
  • Practical SQL skills, including joins, filters, aggregations, and data validation.
  • Advanced Microsoft Excel skills, including PivotTables, lookups, and reconciliation formulas.

Responsibilities

  • Gather and document Finance business requirements, functional specifications, data mappings, test scenarios, and support procedures.
  • Analyze financial data across SAP, Oracle databases, and OneStream to support general ledger, trial balance, consolidation, reporting, and drillback requirements.
  • Write and troubleshoot SQL queries to extract, validate, and reconcile financial data; investigate discrepancies and coordinate resolutions with technical teams.
  • Collaborate with Finance stakeholders and technical teams to maintain accurate financial data and reliable reporting.

Key facts

  • Remote from: United States
  • Full time
  • Senior (5-10 years)
  • IT Support Analyst
  • $175K / year
  • English

Hard skills

Key skills for this role

Other skills

  • Microsoft Excel
  • Detail Oriented
  • Problem Solving
  • Decision Making
  • Communication
  • Collaboration

About the company

CTG logo

CTG

  • IT Services & Consulting
  • 5,001–10,000
CTG, a Cegeka company, is at the forefront of digital transformation, offering innovative IT solutions and services that accelerate your strategy and project momentum. We help you achieve your evolving digital aspirations and desired business and IT outcomes—improved business performance, data-driven decision making, continuous innovation, and reimagined customer experiences—with the agility and confidence needed to succeed. CTG’s comprehensive solutions help clients across all industries address the business, technology, and operational challenges that are escalating as the pace of change gets faster and the stakes get higher. Our solutions leverage the latest tools and methodologies to allow for greater technology and business flexibility. Contact us today at info@ctg.com to learn how CTG can help accelerate your digital transformation.

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Description:

CTG's long-standing Fortune 500 client has a W2 contract assignment for an IT Business Analyst – Finance Systems (SAP and OneStream).

Type: Contract
Job Title: IT Business Analyst – Finance Systems (SAP and OneStream)
Location: Remote, working US business hours with Eastern Time overlap
Pay Rate: Up to $91.00/hour based on experience
Work Hours: M-F 8am-5pm
Education: Bachelor's degree in Finance, Accounting, Information Technology, Business Administration, or a related field preferred.

Description

CTG is seeking an experienced IT Business Analyst to support financial data integration, reconciliation, and reporting across SAP, Oracle databases, and OneStream. This role will partner with Finance stakeholders and technical teams to gather business requirements, investigate financial data discrepancies, document solutions, and validate reporting results.

The ideal candidate has strong SAP Finance, SQL, financial reconciliation, and business analysis skills. Experience with OneStream or another financial consolidation platform is preferred, but candidates with relevant SAP and financial systems experience who are willing to learn OneStream will also be considered.

Requirements:

  • Gather and document Finance business requirements, functional specifications, data mappings, test scenarios, and support procedures.

  • Analyze financial data across SAP, Oracle databases, and OneStream to support general ledger, trial balance, consolidation, reporting, and drillback requirements.

  • Write and troubleshoot SQL queries to extract, validate, and reconcile financial data; investigate discrepancies and coordinate resolutions with technical teams.

  • Support integration testing, user acceptance testing, financial close activities, and reporting validation.

  • Collaborate with Finance stakeholders and technical teams to maintain accurate financial data and reliable reporting.

Qualifications

  • Minimum 5 years of relevant IT business analysis or financial systems experience.

  • Strong understanding of accounting and financial processes, including general ledger, journal entries, trial balances, fiscal periods, and currencies.

  • Hands-on SAP ECC or S/4HANA Finance experience, including researching balances and accounting documents.

  • Practical SQL skills, including joins, filters, aggregations, and data validation.

  • Advanced Microsoft Excel skills, including PivotTables, lookups, and reconciliation formulas.

  • Experience gathering business requirements, documenting solutions, and supporting system testing.

  • Strong analytical and problem-solving skills, attention to detail, and ability to work independently.

  • Effective communication skills and ability to collaborate with Finance users and technical teams.

  • Ability to act quickly, make decisions, and manage competing priorities.

Preferred Qualifications

  • OneStream or other financial consolidation platform experience.

  • Knowledge of PeopleSoft Financials, SAP Special Purpose Ledger, or Central Finance.

  • Oracle RDBMS, SQL performance analysis, Qlik replication, or change data capture experience.

  • Familiarity with financial controls, audit documentation, and reconciliation automation.

  • Experience with Microsoft Visio or Visual Basic.

Additional Information

  • No third party resumes will be accepted.

  • Drug testing and/or other employment-related inquiries may be conducted.

  • CTG will consider for employment-qualified applicants with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.

  • All interested individuals MUST be able to work on a W2 Tax basis (no C2C or third party vendors).

  • CTG is an Equal Employment Opportunity employer.

  • CTG is an E-Verify Company.

To be considered for this opportunity, please apply directly through our website by clicking the link below.

About Us:

CTG, a Cegeka company, delivers IT and business solutions that enhance clients’ digital agility, empowering them to seize new opportunities and overcome any challenge. Backed by more than 60 years’ experience and a commitment to being a reliable, results-driven partner, we work shoulder to shoulder with clients to shape digital together. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. With more than 9,000 team members in over 15 countries, we combine global expertise with local insight to deliver innovative solutions. We operate across the Americas, Europe, and India, working with over 3,000 clients in many of today's highest-growth industries.


Together, we shape what’s next—working shoulder to shoulder to deliver impactful solutions for our clients and society. Our culture is built by the people who work at CTG, the values we hold, and the actions we take. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. At CTG, you’ll find a workplace where you are encouraged to grow, supported in your ambitions, and empowered to shape your own career journey. For more information, visit www.ctg.com.


CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.


CTG is an Equal Opportunity Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. CTG is fully committed to promoting employment opportunities for members of protected classes.

Related jobs

See all IT Support Analyst jobs

Other jobs at CTG