Jobs › Health Care Service Corporation

Financial BI Technical Specialist (Oracle)

Health Care Service Corporation · Chicago, IL · $84,400–$152,300 a year · Full time

Posted Sep 30, 2026 · We last checked this listing on Oct 6, 2026

Apply at Health Care Service Corporation

Likely interview questions for this role

Written from this job description, not a generic list. Each one notes what the interviewer is really checking.

About your past

Tell me about a reporting process you automated. How much time or risk did it remove?

What they are checking: Real automation results, which the posting asks them to identify and deliver.

Tell me about a time you explained a technical reporting limit to finance leaders.

What they are checking: Communication with non-technical stakeholders about tradeoffs and timing.

What would you do

Two teams calculate the same KPI differently. How do you get to one definition?

What they are checking: Facilitation and governance skills to make metrics consistently defined and calculated.

How do you work with actuarial teams whose data needs differ from finance's?

What they are checking: Partnership skills across finance and actuarial, which the posting stresses.

Month-end reports are late because of a data feed issue. What do you do?

What they are checking: Urgency, communication and root cause follow-up when reporting timeliness is at risk.

How do you decide whether a request should become a standard report or stay ad hoc?

What they are checking: Judgment that reduces redundancy instead of adding more reports to maintain.

About the work

This role focuses on Oracle financial reporting. Which Oracle tools have you used, and what did you build with them?

What they are checking: Hands-on experience with the Oracle stack the posting names.

How would you lead a report rationalization effort when finance has hundreds of overlapping reports?

What they are checking: Ability to inventory, consolidate and retire reports while keeping users supported.

How do you design a BI framework built on a standard set of business drivers and KPIs?

What they are checking: Understanding of semantic layers, data models and governance for financial reporting.

How do you validate that financial data in a report matches the general ledger?

What they are checking: Reconciliation discipline that keeps leadership from making decisions on wrong numbers.

Practice this interview out loud.

Offer builds a real interview for this exact role at Health Care Service Corporation from your resume and this job description, asks the questions one at a time, and tells you what landed. The first one is free.

Practice this out loud

The full job description

As published by Health Care Service Corporation.

At HCSC, our employees are the cornerstone of our business and the foundation to our success. We empower employees with curated development plans that foster growth and promote rewarding, fulfilling careers. Join HCSC and be part of a purpose-driven company that will invest in your professional development. Job Summary This position is responsible for assisting in the design and implementation of financial and management reporting and analytics portfolio(s) used to drive strategic and operation decision making. Additionally, this role oversees the team*s alignment of business intelligence strategy and framework, consisting of a standard set of business drivers and kpis, to gain insights into financial business operations through data retrieval, analysis, and reporting. This position is also responsible for report rationalization ensuring metrics are consistently defined, calculated, and accessed, and for identifying opportunities for enhanced reporting automation. The financial bi technical consultant will closely partner with finance and actuarial teams to improve the efficiency and effectiveness of reporting processes, reduce risks and redundancy, while improving timeliness, quality and delivery. Required Job Qualifications: • Bachelor’s Degree in Computer Science, Information Systems, Business Administration or related field • Minimum 5 years of experience with business intelligence tools and systems, and relational database technology • Project Management, strategy development, change management and process improvement experience • Reporting and data governance experience Preferred Job Qualifications: • Oracle Fusion Financials Reporting Experience (ERP and EPM) • Oracle Smart view, BI Publisher, OTBI, Financial Reporting Studio (FRS) • Experience in EPM Reports, Narrative reporting • Hands on Report development experience • PowerBi Paginated reporting experience This is a Flex (Hybrid) role: 3 days in office; 2 days remote. #LI-MG1 Are you being referred to one of our roles? If so, ask your connection at HCSC about our Employee Referral process! Pay Transparency Statement: At Health Care Service Corporation, you will be part of an organization committed to offering meaningful benefits to our employees to support their life outside of work. From health and wellness benefits, 401(k) savings plan, pension plan, paid time off, paid parental leave, disability insurance, supplemental life insurance, employee assistance program, paid holidays, tuition reimbursement, plus other incentives, we offer a robust total rewards package for employees. Learn more about our benefit offerings by visiting https://careers.hcsc.com/totalrewards . The compensation offered will vary depending on your job-related skills, education, knowledge, and experience. This role aligns with an annual incentive bonus plan subject to the terms and the conditions of the plan. Flex employees are expected to be in the office a minimum of three days a week. Management will have discretion to modify an employee's weekly schedule for exigent circumstances. HCSC Employment Statement: We are an Equal Opportunity Employment employer dedicated to providing a welcoming environment where the unique differences of our employees are respected and valued. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other legally protected characteristics. We are a drug-free and smoke-free workplace. Employment may be contingent upon successful completion of drug screening in accordance with applicable law. Base Pay Range $84,400.00 - $152,300.00 Exact compensation may vary based on skills, experience, and location.

Apply at Health Care Service Corporation