Senior Software Development Engineer

Quest Oracle Community; Chicago, Northern (IL, KY); Hybrid; USD 102,000 - 204,000; Full time

Benefits offered by this job

Medical, dental, vision coverage

Bonus program

Paid time off

Retirement savings options

Job summary

CVS Health in Chicago seeks a Senior BI & Financial Systems Analyst specializing in Oracle Hyperion tools and Power BI. You will design planning and reporting solutions, build dashboards, and support budgeting cycles while ensuring governance and data integrity across the finance stack.

The role demands senior-level SQL, ETL, and ERP integration experience, with strong collaboration across Finance and IT. This is a full-time position with a comprehensive benefits package.

Qualifications

• 7+ years of hands-on experience with Oracle Hyperion Business Tools.
• 3+ years of experience developing Power BI reports, dashboards, and datasets.
• Proficiency in Power Query, DAX, data modeling, and report optimization.
• Experience integrating financial data from ERP systems such as SAP, Oracle EBS, Oracle Cloud ERP.

Responsibilities

• Design, develop, and support Hyperion Planning, FMS (HFM), Essbase, FR, and Smart View solutions.
• Develop and maintain interactive Power BI dashboards, reports, and semantic models.
• Collaborate with Finance, Accounting, and Business teams to gather requirements.
• Perform data integration, validation, reconciliation, and financial data analysis.
• Automate manual financial reporting activities and optimize processes.
• Support month-end, quarter-end, annual planning, forecasting, and budgeting cycles.
• Troubleshoot Hyperion and Power BI issues and provide user support.
• Ensure compliance with data governance, security, and audit requirements.

Skills

Hyperion Planning

Hyperion Financial Management (HFM)

Essbase

Financial Reporting Studio

Smart View

Power BI

Power Query

DAX

SQL

ETL

Data modeling

Education

Bachelor's degree in CS/IS/Finance/Accounting/Business Analytics

MBA preferred

Tools

Hyperion Suite

Power BI

SQL databases

ERP integrations (SAP, Oracle EBS/Cloud ERP)

Job description

We're building a world of health around every individual - shaping a more connected, convenient and compassionate health experience. At CVS Health®, you'll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger - helping to simplify health care one person, one family and one community at a time.

Position Summary

We are seeking a highly skilled and experienced Senior Business Intelligence & Financial Systems Analyst with expertise in Oracle Hyperion Business Tools and Microsoft Power BI to support enterprise financial planning, reporting, analytics, and decision-making initiatives. The ideal candidate will be responsible for designing, developing, and maintaining financial reporting solutions, dashboards, and planning applications that enable business stakeholders to gain actionable insights. This role requires a strong blend of finance, business intelligence, data analytics, and technical development capabilities.

Key responsibilities include:

• Design, develop, and support Hyperion Planning, Financial Management (HFM), Essbase, Financial Reporting (FR), and Smart View solutions.
• Develop and maintain interactive Power BI dashboards, reports, and semantic data models.
• Collaborate with Finance, Accounting, and Business teams to gather reporting and planning requirements.
• Perform data integration, validation, reconciliation, and financial data analysis.
• Optimize reporting processes and automate manual financial reporting activities.
• Support month-end, quarter-end, annual planning, forecasting, and budgeting cycles.
• Troubleshoot system issues and provide user support for Hyperion and Power BI platforms.
• Ensure compliance with enterprise data governance, security, and audit requirements.
• Partner with cross-functional teams to drive reporting modernization and continuous improvement initiatives.

Required Qualifications

7+ years of hands‑on experience with Oracle Hyperion Business Tools.

• Strong experience with: Hyperion Planning Hyperion Financial Management (HFM) Essbase Financial Reporting Studio Smart View
• 3+ years of experience developing Power BI reports, dashboards, and datasets.
• Proficiency in Power Query, DAX, data modeling, and report optimization.
• Experience integrating financial data from ERP systems such as SAP, Oracle EBS, Oracle Cloud ERP, or similar platforms.
• Strong knowledge of budgeting, forecasting, financial planning, and management reporting processes.
• Experience writing SQL queries and working with relational databases.
• Knowledge of ETL processes and data integration tools.
• Strong analytical, problem‑solving, and troubleshooting skills.
• Experience gathering business requirements and translating them into technical solutions.
• Excellent verbal and written communication skills with the ability to engage both technical and business stakeholders.
• Ability to manage multiple priorities in a fast‑paced environment.

Preferred Qualifications

Experience with Oracle EPM Cloud (EPBCS, FCCS, ARCS, PCMCS).

• Experience integrating Hyperion solutions with cloud-based data platforms.
• Familiarity with Azure, AWS, Google Cloud Platform (GCP), or hybrid analytics environments.
• Knowledge of financial consolidation, close management, and regulatory reporting.
• Experience with Power BI Premium, Fabric, and advanced analytics capabilities.
• Exposure to Alteryx, Informatica, ODI, Data Factory, or similar integration tools.
• Understanding of data governance, SOX controls, and audit compliance requirements.
• Experience with Agile delivery methodologies and DevOps practices.
• Professional certifications such as: Microsoft Certified: Power BI Data Analyst Associate Oracle Hyperion / EPM Certifications PMP or Agile Certifications
• Experience supporting large‑scale enterprise finance transformation initiatives.

Education

Bachelor's degree in Computer Science, Information Systems, Finance, Accounting, Business Analytics, or a related field.

• Master's degree in Business Administration (MBA), Finance, Information Systems, or related discipline preferred.
• Equivalent combination of education, certifications, and relevant work experience will be considered.

Anticipated Weekly Hours

40

Time Type

Full time

Pay Range

The typical pay range for this role is:

$101,970.00 - $203,940.00

This pay range represents the base hourly rate or base annual full‑time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors. This position is eligible for a CVS Health bonus, commission or short‑term incentive program in addition to the base pay range listed above.

Our people fuel our future. Our teams reflect the customers, patients, members and communities we serve and we are committed to fostering a workplace where every colleague feels valued and that they belong.

Great benefits for great people

We take pride in offering a comprehensive and competitive mix of pay and benefits that reflects our commitment to our colleagues and their families.

This full‑time position is eligible for a comprehensive benefits package designed to support the physical, emotional, and financial well‑being of colleagues and their families. The benefits for this position include medical, dental, and vision coverage, paid time off, retirement savings options, wellness programs, and other resources, based on eligibility.

Additional details about available benefits are provided during the application process and on Benefits Moments.

We anticipate the application window for this opening will close on: 10/05/2026

Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.