Home › Companies › Iaucqy Fa Ocs Oraclecloud Com CX 1 › Business Systems Analyst: Hoag Clinic Claims & Enrollment
Business Systems Analyst: Hoag Clinic Claims & Enrollment
Iaucqy Fa Ocs Oraclecloud Com CX 1 · Costa Mesa, CA, United States; Redhill Business Center, Costa Mesa, CA, US · Active · Oracle Recruiting Cloud / Fusion HCM
Job facts
| Field | Value |
|---|---|
| Company | Iaucqy Fa Ocs Oraclecloud Com CX 1 |
| Title | Business Systems Analyst: Hoag Clinic Claims & Enrollment |
| Normalized title | - |
| Department / team | Administrative Support |
| Location | Costa Mesa, CA, United States |
| Work model | - |
| Employment type | - |
| Salary | - |
| Status | active |
| ATS provider | Oracle Recruiting Cloud / Fusion HCM |
| Posted / first seen | 2026-05-04 / 2026-05-31 |
| Changed / last seen | 2026-05-31 / 2026-06-06 |
Related slices
| Page | What it contains | Open |
|---|---|---|
| Company jobs | Active postings from Iaucqy Fa Ocs Oraclecloud Com CX 1. | Open |
| Company breakdowns | Role, location, ATS, and work model facets for this company. | Open |
| ATS provider jobs | Active postings observed through Oracle Recruiting Cloud / Fusion HCM. | Open |
| Provider filtered search | The same provider as a filtered job collection. | Open |
| City jobs | Active postings in Costa Mesa. | Open |
| Department jobs | Active postings in Administrative Support. | Open |
| Lifecycle events | Open, update, close, and reopen events for this posting. | Open |
| Original posting | Canonical source or apply URL captured from the ATS. | Open |
Linked records
| Company | Iaucqy Fa Ocs Oraclecloud Com CX 1 |
| Source | 1b5266ee-b080-4128-abb9-c78c0858fc67 |
| ATS provider | Oracle Recruiting Cloud / Fusion HCM |
Description
Description
The Business Systems Analyst plays a critical role in supporting advanced analytics and data driven decision making across Hoag Clinic operational departments, including but not limited to Member Services, Quality, Utilization Management, Claims, Medical Management, Clinical Services, and Eligibility.
This role is responsible for designing developing and maintaining complex analytical solutions including Power BI dashboards enterprise reports and scalable data models. The analyst will work extensively with Power Query and SQL to extract transform and model data from multiple source systems and will be expected to independently translate complex business questions into actionable insights.
The ideal candidate has strong hands-on experience with Power BI, Power Query and SQL and is comfortable working with large healthcare datasets end to end from data ingestion and transformation through visualization and presentation.
Responsibilities
Primary Duties and Responsibilities
Design develop and maintain advanced Power BI dashboards semantic models and reports used by operational and clinical leadership Use Power Query extensively to extract transform cleanse and combine data from multiple source systems Write optimize and maintain complex SQL queries views and datasets to support reporting and analytics Partner with business stakeholders to translate operational and regulatory requirements into scalable analytical solutions Perform deep dive analysis across claims referrals eligibility and utilization data to identify trends anomalies and operational risks Ensure data accuracy consistency and integrity across all reporting layers including source transformation and visualization Collaborate with IT Strategic Analytics and external partners to improve data pipelines data availability and performance Create and maintain documentation for data sources transformations calculations business rules and reporting definitions Serve as a subject matter expert for Power BI Power Query and SQL within the department Stay current on Power BI feature releases advanced modeling techniques and healthcare analytics best practices Perform other duties as assigned
Qualifications
Education and Experience
Bachelor’s degree in Data Analytics Information Systems Business or equivalent practical experience 3 plus years of hands-on experience in data analytics business intelligence or reporting roles Strong hands-on experience using Power BI including Power Query data modeling DAX and visualization best practices Strong SQL skills with experience querying and transforming complex relational datasets Experience working with healthcare data including claims referrals eligibility or utilization highly preferred Solid understanding of data warehousing concepts star schema and reporting optimization Proven ability to independently manage multiple analytics deliverables from requirements through delivery Strong analytical critical thinking and problem-solving skills Excellent communication skills with the ability to present data insights to non-technical audiences
Company
Hoag Memorial Hospital Presbyterian is a nonprofit regional health care delivery network in Orange County, California, consisting of three acute-care hospitals with sixteen urgent care centers, eleven health centers and a network of more than1,800 physicians, 100 allied health members, 8,000 employees, and 2,000 volunteers. More than 30,000 inpatients and 550,000 outpatients choose Hoag each year.
For over 70 years, Hoag has delivered a level of personalized care that is unsurpassed among Orange County’s health care providers. Since 1952, Hoag has served the local communities and continues its mission to provide the highest quality health care services through the core strategies of quality and service, people, physician partnerships, strategic growth, financial stewardship, community benefit and philanthropy.
Hoag offers a comprehensive blend of health care services including six institutes providing specialized care in the areas of cancer, heart and vascular, neurosciences, women's health, orthopedics, and digestive health through our institutes.
Hoag was the highest ranked hospital in Orange County in the 2024-2025 U.S. News &World Report, the only Orange County hospital ranked in the top 10 for California. The organization was ranked the #5 hospital in the Los Angeles Metro Area and the #10 hospital in California.
To learn more about Hoag’s awards and accreditations, visit: https://www.hoag.org/about-hoag/awards-accreditations/ .
Hoag is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. Hoag is committed to the principle of equal employment opportunity for all employees and providing employees with a work environment free of discrimination and harassment. Hoag hires a diverse group of people in a manner that allows them to reach their full potential in the pursuit of organizational objectives.
Full job record
| Job ID | 51e69a94f0e328067d58cbeb70b06e55e674b4ac |
| Org ID | 239fd395-3f3c-4897-89b4-debc4ffacabc |
| Source ID | 1b5266ee-b080-4128-abb9-c78c0858fc67 |
| Board ID | 1b5266ee-b080-4128-abb9-c78c0858fc67 |
| Provider | oracle_hcm |
| Provider Job Key | 128614 |
| Title | Business Systems Analyst: Hoag Clinic Claims & Enrollment |
| Normalized Title | — |
| Status | active |
| Active | yes |
| Location Text | Costa Mesa, CA, United States; Redhill Business Center, Costa Mesa, CA, US |
| Department | Administrative Support |
| Team | — |
| Employment Type | — |
| Workplace Type | — |
| Remote Policy | — |
| Country | United States |
| Region | CA |
| City | Costa Mesa |
| Salary Raw | Description The Business Systems Analyst plays a critical role in supporting advanced analytics and data driven decision making across Hoag Clinic operational departments, including but not limited to Member Services, Quality, Utilization Management, Claims, Medical Management, Clinical Services, and Eligibility. This role is responsible for designing developing and maintaining complex analytical solutions including Power BI dashboards enterprise reports and scalable data models. The analyst will work extensively with Power Query and SQL to extract transform and model data from multiple source systems and will be expected to independently translate complex business questions into actionable insights. The ideal candidate has strong hands-on experience with Power BI, Power Query and SQL and is comfortable working with large healthcare datasets end to end from data ingestion and transformation through visualization and presentation. Responsibilities Primary Duties and Responsibilities Design develop and maintain advanced Power BI dashboards semantic models and reports used by operational and clinical leadership Use Power Query extensively to extract transform cleanse and combine data from multiple source systems Write optimize and maintain complex SQL queries views and datasets to support reporting and analytics Partner with business stakeholders to translate operational and regulatory requirements into scalable analytical solutions Perform deep dive analysis across claims referrals eligibility and utilization data to identify trends anomalies and operational risks Ensure data accuracy consistency and integrity across all reporting layers including source transformation and visualization Collaborate with IT Strategic Analytics and external partners to improve data pipelines data availability and performance Create and maintain documentation for data sources transformations calculations business rules and reporting definitions Serve as a subject matter expert for Power BI Power Query and SQL within the department Stay current on Power BI feature releases advanced modeling techniques and healthcare analytics best practices Perform other duties as assigned Qualifications Education and Experience Bachelor’s degree in Data Analytics Information Systems Business or equivalent practical experience 3 plus years of hands-on experience in data analytics business intelligence or reporting roles Strong hands-on experience using Power BI including Power Query data modeling DAX and visualization best practices Strong SQL skills with experience querying and transforming complex relational datasets Experience working with healthcare data including claims referrals eligibility or utilization highly preferred Solid understanding of data warehousing concepts star schema and reporting optimization Proven ability to independently manage multiple analytics deliverables from requirements through delivery Strong analytical critical thinking and problem-solving skills Excellent communication skills with the ability to present data insights to non-technical audiences Company Hoag Memorial Hospital Presbyterian is a nonprofit regional health care delivery network in Orange County, California, consisting of three acute-care hospitals with sixteen urgent care centers, eleven health centers and a network of more than1,800 physicians, 100 allied health members, 8,000 employees, and 2,000 volunteers. More than 30,000 inpatients and 550,000 outpatients choose Hoag each year. For over 70 years, Hoag has delivered a level of personalized care that is unsurpassed among Orange County’s health care providers. Since 1952, Hoag has served the local communities and continues its mission to provide the highest quality health care services through the core strategies of quality and service, people, physician partnerships, strategic growth, financial stewardship, community benefit and philanthropy. Hoag offers a comprehensive blend of health care services including six institutes providing specialized care in the areas of cancer, heart and vascular, neurosciences, women's health, orthopedics, and digestive health through our institutes. Hoag was the highest ranked hospital in Orange County in the 2024-2025 U.S. News &World Report, the only Orange County hospital ranked in the top 10 for California. The organization was ranked the #5 hospital in the Los Angeles Metro Area and the #10 hospital in California. To learn more about Hoag’s awards and accreditations, visit: https://www.hoag.org/about-hoag/awards-accreditations/ . Hoag is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. Hoag is committed to the principle of equal employment opportunity for all employees and providing employees with a work environment free of discrimination and harassment. Hoag hires a diverse group of people in a manner that allows them to reach their full potential in the pursuit of organizational objectives. |
| Salary Min | — |
| Salary Max | — |
| Salary Currency | — |
| Salary Period | — |
| Source URL | https://iaucqy.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/128614 |
| Apply URL | https://iaucqy.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/128614 |
| First Seen At | 2026-05-31 17:57:24Z |
| Last Seen At | 2026-06-06 19:32:40Z |
| Last Checked At | 2026-06-06 19:32:40Z |
| Last Changed At | 2026-05-31 17:57:24Z |
| Inactive At | — |
| Source Posted At | 2026-05-04 18:00:21Z |
| Source Updated At | — |
| Raw Payload Uri | s3://job-postings-prod-raw-590183727216/raw/provider=oracle_hcm/board=iaucqy.fa.ocs.oraclecloud.com|CX_1/date=2026-06-06/2026-06-06T19-32-24-205Z-4e62a75d74031a35a8b5339c06f45fa07f091eba396067af52af13d075da0477.json |
Event Fields
{
"content_hash": "e9f8b96e99bd55cca6680d7ae05f047a8efdf4b4c88714fe45f81d050b730e33",
"source_hash": "5a1baf8263f0773c83e86bbb5d4843a8598ccbeb2d7f2730959962d799eba1fe",
"last_changed_at": "2026-05-31T17:57:24.903Z",
"active_status": "active"
}Parsed Structured
{
"language": "en",
"location": {
"raw": "Costa Mesa, CA, United States",
"city": "Costa Mesa",
"region": "CA",
"country": "United States",
"is_remote": false,
"confidence": 0.8
},
"salary_max": null,
"salary_min": null,
"inferred_at": "2026-06-06T19:32:40.104Z",
"launch_scope": {
"reason": "english_us_canada",
"included": true,
"language": "en",
"location": {
"raw": "Costa Mesa, CA, United States",
"city": "Costa Mesa",
"region": "CA",
"country": "United States",
"is_remote": false,
"confidence": 0.8
},
"countries": [
"United States"
]
},
"remote_policy": null,
"salary_period": null,
"workplace_type": null,
"salary_currency": null
}Extensions
{}Native Structured
{
"detail": {
"Id": "128614",
"Title": "Business Systems Analyst: Hoag Clinic Claims & Enrollment",
"media": [],
"skills": [],
"JobType": null,
"Category": "Administrative Support",
"JobGrade": null,
"JobLevel": null,
"JobShift": "Day",
"WorkDays": null,
"WorkHours": null,
"WorkYears": null,
"Department": null,
"HotJobFlag": false,
"StudyLevel": null,
"WorkMonths": null,
"WorkerType": null,
"GeographyId": 300000006669686,
"JobFamilyId": 300000012021221,
"JobFunction": null,
"JobSchedule": null,
"BusinessUnit": null,
"ContractType": null,
"Organization": null,
"TrendingFlag": false,
"workLocation": [
{
"Country": "US",
"Region1": "Orange",
"Region2": "CA",
"Region3": null,
"Building": null,
"Latitude": "33.67193",
"Longitude": "-117.87931",
"LocationId": 300000011577151,
"PostalCode": "92626",
"TownOrCity": "Costa Mesa",
"AddressLine1": "2975 Red Hill Ave",
"AddressLine2": "Ste 200",
"AddressLine3": null,
"AddressLine4": null,
"LocationName": "Redhill Business Center"
}
],
"ContentLocale": "en",
"HiringManager": null,
"LegalEmployer": null,
"RequisitionId": 300001407731974,
"WorkplaceType": "",
"BusinessUnitId": 300000006639285,
"OrganizationId": 300000011592351,
"GeographyNodeId": 100000776796678,
"JobFunctionCode": null,
"LegalEmployerId": 300000006640009,
"PrimaryLocation": "Costa Mesa, CA, United States",
"RequisitionType": "Salaried",
"NumberOfOpenings": null,
"WorkplaceTypeCode": null,
"BeFirstToApplyFlag": false,
"otherWorkLocations": [],
"secondaryLocations": [],
"ExternalContactName": null,
"ShortDescriptionStr": "",
"ExternalContactEmail": null,
"ExternalPostedEndDate": "2026-06-30T07:00:00+00:00",
"OtherRequisitionTitle": null,
"requisitionFlexFields": [
{
"Value": "$43.51-$67.23/hour",
"Prompt": "Pay Range",
"ControlType": "TextArea",
"SequenceNumber": 1
},
{
"Value": "Onsite",
"Prompt": "Remote or Onsite",
"ControlType": "SingleChoiceList",
"SequenceNumber": 2
},
{
"Value": "Full Time",
"Prompt": "Job Schedule",
"ControlType": "SingleChoiceList",
"SequenceNumber": 3
},
{
"Value": "NO",
"Prompt": "HHIX Position",
"ControlType": "SingleChoiceList",
"SequenceNumber": 4
}
],
"ApplyWhenNotPostedFlag": true,
"DomesticTravelRequired": null,
"ExternalDescriptionStr": "<p class=\"x_xmsonormal\" data-olk-copy-source=\"MessageBody\" style=\"-webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); color: rgb(36, 36, 36); font-family: Aptos, sans-serif; font-size: 12pt; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0in; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;\">The Business Systems Analyst plays a critical role in supporting advanced analytics and data driven decision making across Hoag Clinic operational departments, including but not limited to Member Services, Quality, Utilization Management, Claims, Medical Management, Clinical Services, and Eligibility. </p><p class=\"x_xmsonormal\" style=\"-webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); color: rgb(36, 36, 36); font-family: Aptos, sans-serif; font-size: 12pt; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0in; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;\">This role is responsible for designing developing and maintaining complex analytical solutions including Power BI dashboards enterprise reports and scalable data models. The analyst will work extensively with Power Query and SQL to extract transform and model data from multiple source systems and will be expected to independently translate complex business questions into actionable insights.</p><p class=\"x_xmsonormal\" style=\"-webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); color: rgb(36, 36, 36); font-family: Aptos, sans-serif; font-size: 12pt; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0in; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;\">The ideal candidate has strong hands-on experience with Power BI, Power Query and SQL and is comfortable working with large healthcare datasets end to end from data ingestion and transformation through visualization and presentation.</p>",
"ObjectVerNumberProfile": null,
"PrimaryLocationCountry": "US",
"CorporateDescriptionStr": "<p>Hoag Memorial Hospital Presbyterian is a nonprofit regional health care delivery network in Orange County, California, consisting of three acute-care hospitals with sixteen urgent care centers, eleven health centers and a network of more than1,800 physicians, 100 allied health members, 8,000 employees, and 2,000 volunteers. More than 30,000 inpatients and 550,000 outpatients choose Hoag each year.</p>\n<p>For over 70 years, Hoag has delivered a level of personalized care that is unsurpassed among Orange County’s health care providers. Since 1952, Hoag has served the local communities and continues its mission to provide the highest quality health care services through the core strategies of quality and service, people, physician partnerships, strategic growth, financial stewardship, community benefit and philanthropy.</p>\n<p>Hoag offers a comprehensive blend of health care services including six institutes providing specialized care in the areas of cancer, heart and vascular, neurosciences, women's health, orthopedics, and digestive health through our institutes.</p>\n<p>Hoag was the highest ranked hospital in Orange County in the 2024-2025 U.S. News &World Report, the only Orange County hospital ranked in the top 10 for California. The organization was ranked the #5 hospital in the Los Angeles Metro Area and the #10 hospital in California.</p>\n<p>To learn more about Hoag’s awards and accreditations, visit: <a href=\"https://www.hoag.org/about-hoag/awards-accreditations/\" target=\"_blank\"> https://www.hoag.org/about-hoag/awards-accreditations/</a>.</p>\n<p>Hoag is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. Hoag is committed to the principle of equal employment opportunity for all employees and providing employees with a work environment free of discrimination and harassment. Hoag hires a diverse group of people in a manner that allows them to reach their full potential in the pursuit of organizational objectives.</p>",
"ExternalPostedStartDate": "2026-05-04T18:00:21+00:00",
"ExternalQualificationsStr": "<p class=\"x_xmsonormal\" data-olk-copy-source=\"MessageBody\" style=\"-webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); color: rgb(36, 36, 36); font-family: Aptos, sans-serif; font-size: 12pt; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0in; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;\"><strong>Education and Experience</strong></p><ul type=\"disc\" style=\"-webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); color: rgb(36, 36, 36); font-family: "Segoe UI", "Segoe UI Web (West European)", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 15px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; list-style-type: disc; margin-bottom: 0in; margin-top: 0in; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;\"><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Bachelor’s degree in Data Analytics Information Systems Business or equivalent practical experience</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">3 plus years of hands-on experience in data analytics business intelligence or reporting roles</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Strong hands-on experience using Power BI including Power Query data modeling DAX and visualization best practices</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Strong SQL skills with experience querying and transforming complex relational datasets</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Experience working with healthcare data including claims referrals eligibility or utilization highly preferred</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Solid understanding of data warehousing concepts star schema and reporting optimization</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Proven ability to independently manage multiple analytics deliverables from requirements through delivery</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Strong analytical critical thinking and problem-solving skills</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Excellent communication skills with the ability to present data insights to non-technical audiences</li></ul><p class=\"x_xmsonormal\" aria-hidden=\"true\" style=\"-webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); color: rgb(36, 36, 36); font-family: Aptos, sans-serif; font-size: 12pt; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0in; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;\"> </p>",
"InternalQualificationsStr": "<p class=\"x_xmsonormal\" data-olk-copy-source=\"MessageBody\" style=\"-webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); color: rgb(36, 36, 36); font-family: Aptos, sans-serif; font-size: 12pt; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0in; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;\"><strong>Education and Experience</strong></p><ul type=\"disc\" style=\"-webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); color: rgb(36, 36, 36); font-family: "Segoe UI", "Segoe UI Web (West European)", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 15px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; list-style-type: disc; margin-bottom: 0in; margin-top: 0in; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;\"><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Bachelor’s degree in Data Analytics Information Systems Business or equivalent practical experience</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">3 plus years of hands-on experience in data analytics business intelligence or reporting roles</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Strong hands-on experience using Power BI including Power Query data modeling DAX and visualization best practices</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Strong SQL skills with experience querying and transforming complex relational datasets</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Experience working with healthcare data including claims referrals eligibility or utilization highly preferred</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Solid understanding of data warehousing concepts star schema and reporting optimization</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Proven ability to independently manage multiple analytics deliverables from requirements through delivery</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Strong analytical critical thinking and problem-solving skills</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Excellent communication skills with the ability to present data insights to non-technical audiences</li></ul><p class=\"x_xmsonormal\" aria-hidden=\"true\" style=\"-webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); color: rgb(36, 36, 36); font-family: Aptos, sans-serif; font-size: 12pt; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0in; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;\"> </p>",
"OrganizationDescriptionStr": "",
"primaryLocationCoordinates": [
{
"Latitude": "33.66389",
"Longitude": "-117.90239",
"CountryCode": "US",
"GeographyId": 300000006669686,
"GeographyNodeId": 100000776796678
}
],
"ExternalResponsibilitiesStr": "<p class=\"x_xmsonormal\" data-olk-copy-source=\"MessageBody\" style=\"-webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); color: rgb(36, 36, 36); font-family: Aptos, sans-serif; font-size: 12pt; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0in; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;\"><strong>Primary Duties and Responsibilities</strong></p><ul type=\"disc\" style=\"-webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); color: rgb(36, 36, 36); font-family: "Segoe UI", "Segoe UI Web (West European)", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 15px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; list-style-type: disc; margin-bottom: 0in; margin-top: 0in; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;\"><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Design develop and maintain advanced Power BI dashboards semantic models and reports used by operational and clinical leadership</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Use Power Query extensively to extract transform cleanse and combine data from multiple source systems</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Write optimize and maintain complex SQL queries views and datasets to support reporting and analytics</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Partner with business stakeholders to translate operational and regulatory requirements into scalable analytical solutions</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Perform deep dive analysis across claims referrals eligibility and utilization data to identify trends anomalies and operational risks</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Ensure data accuracy consistency and integrity across all reporting layers including source transformation and visualization</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Collaborate with IT Strategic Analytics and external partners to improve data pipelines data availability and performance</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Create and maintain documentation for data sources transformations calculations business rules and reporting definitions</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Serve as a subject matter expert for Power BI Power Query and SQL within the department</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Stay current on Power BI feature releases advanced modeling techniques and healthcare analytics best practices</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Perform other duties as assigned</li></ul>",
"InternalResponsibilitiesStr": "<p class=\"x_xmsonormal\" data-olk-copy-source=\"MessageBody\" style=\"-webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); color: rgb(36, 36, 36); font-family: Aptos, sans-serif; font-size: 12pt; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; margin: 0in; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;\"><strong>Primary Duties and Responsibilities</strong></p><ul type=\"disc\" style=\"-webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); color: rgb(36, 36, 36); font-family: "Segoe UI", "Segoe UI Web (West European)", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 15px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; list-style-type: disc; margin-bottom: 0in; margin-top: 0in; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-decoration-thickness: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;\"><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Design develop and maintain advanced Power BI dashboards semantic models and reports used by operational and clinical leadership</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Use Power Query extensively to extract transform cleanse and combine data from multiple source systems</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Write optimize and maintain complex SQL queries views and datasets to support reporting and analytics</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Partner with business stakeholders to translate operational and regulatory requirements into scalable analytical solutions</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Perform deep dive analysis across claims referrals eligibility and utilization data to identify trends anomalies and operational risks</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Ensure data accuracy consistency and integrity across all reporting layers including source transformation and visualization</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Collaborate with IT Strategic Analytics and external partners to improve data pipelines data availability and performance</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Create and maintain documentation for data sources transformations calculations business rules and reporting definitions</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Serve as a subject matter expert for Power BI Power Query and SQL within the department</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Stay current on Power BI feature releases advanced modeling techniques and healthcare analytics best practices</li><li class=\"x_xmsonormal\" style=\"font-family: Aptos, sans-serif; font-size: 12pt; margin-bottom: 0in; margin-right: 0in; margin-top: 0in;\">Perform other duties as assigned</li></ul>",
"InternationalTravelRequired": null
},
"list_job": {
"Id": "128614",
"Title": "Business Systems Analyst: Hoag Clinic Claims & Enrollment",
"JobType": null,
"Distance": 1777852800000,
"JobShift": null,
"Language": "US",
"WorkDays": null,
"JobFamily": null,
"Relevancy": 2,
"WorkHours": null,
"Department": null,
"HotJobFlag": false,
"PostedDate": "2026-05-04",
"StudyLevel": null,
"WorkerType": null,
"GeographyId": 300000006669686,
"JobFunction": null,
"JobSchedule": null,
"BusinessUnit": null,
"ContractType": null,
"ManagerLevel": null,
"Organization": null,
"TrendingFlag": false,
"workLocation": [
{
"Country": "US",
"Region1": "Orange",
"Region2": "CA",
"Region3": null,
"Building": null,
"Latitude": 33.67193,
"Longitude": -117.87931,
"LocationId": 300000011577151,
"PostalCode": "92626",
"TownOrCity": "Costa Mesa",
"AddressLine1": "2975 Red Hill Ave",
"AddressLine2": "Ste 200",
"AddressLine3": null,
"AddressLine4": null,
"LocationName": "Redhill Business Center"
}
],
"LegalEmployer": null,
"MediaThumbURL": null,
"WorkplaceType": "",
"BusinessUnitId": 300000006639285,
"OrganizationId": 300000011592351,
"PostingEndDate": null,
"LegalEmployerId": 300000006640009,
"PrimaryLocation": "Costa Mesa, CA, United States",
"WorkDurationYears": null,
"WorkplaceTypeCode": null,
"BeFirstToApplyFlag": false,
"WorkDurationMonths": null,
"otherWorkLocations": [],
"secondaryLocations": [],
"ShortDescriptionStr": "",
"requisitionFlexFields": [],
"DomesticTravelRequired": null,
"PrimaryLocationCountry": "US",
"ExternalQualificationsStr": null,
"ExternalResponsibilitiesStr": null,
"InternationalTravelRequired": null
},
"detail_meta": {
"url": "https://iaucqy.fa.ocs.oraclecloud.com/hcmRestApi/resources/latest/recruitingCEJobRequisitionDetails?expand=all&onlyData=true&finder=ById;Id=%22128614%22,siteNumber=CX_1",
"http_status": 200,
"content_type": "application/json",
"response_bytes": 24676
},
"detail_errors": []
}Get this page with API
Rendered from the bluedoor Job Postings API. Reproduce it:
GET https://api.bluedoor.sh/job-postings/v1/jobs/51e69a94f0e328067d58cbeb70b06e55e674b4ac?include=descriptionJSONGET https://api.bluedoor.sh/job-postings/v1/orgs/239fd395-3f3c-4897-89b4-debc4ffacabcJSONGET https://api.bluedoor.sh/job-postings/v1/sources/1b5266ee-b080-4128-abb9-c78c0858fc67JSONGET https://api.bluedoor.sh/job-postings/v1/jobs/51e69a94f0e328067d58cbeb70b06e55e674b4ac/eventsJSON