Financial Analyst III - TPA

{
  "content_hash": "4ab76e9a8dc9cfc28ceadf0dcbd3891b7bd7b64fc60c12ac9e36612aa079d1dc",
  "source_hash": "5e24f883d44be6036a253f25d1f5caf4e86e5c223741a1a1f32d63c92b907425",
  "last_changed_at": "2026-06-21T12:15:25.533Z",
  "active_status": "active"
}

{
  "dedupe": null,
  "language": "en",
  "location": {
    "raw": "Menomonee Falls, WI, United States",
    "city": "Menomonee Falls",
    "region": "WI",
    "country": "United States",
    "is_remote": false,
    "confidence": 0.8
  },
  "salary_max": 127802,
  "salary_min": 85202,
  "inferred_at": "2026-06-23T11:06:14.460Z",
  "launch_scope": {
    "reason": "english_us_canada",
    "included": true,
    "language": "en",
    "location": {
      "raw": "Menomonee Falls, WI, United States",
      "city": "Menomonee Falls",
      "region": "WI",
      "country": "United States",
      "is_remote": false,
      "confidence": 0.8
    },
    "countries": [
      "United States"
    ]
  },
  "remote_policy": "remote",
  "salary_period": "year",
  "workplace_type": "remote",
  "salary_currency": "USD"
}

{}

{
  "detail": {
    "Id": "3276",
    "Title": "Financial Analyst III - TPA",
    "media": [],
    "skills": [],
    "JobType": null,
    "Category": "Accounting/Finance",
    "JobGrade": null,
    "JobLevel": null,
    "JobShift": null,
    "WorkDays": null,
    "WorkHours": null,
    "WorkYears": null,
    "Department": null,
    "HotJobFlag": false,
    "StudyLevel": null,
    "WorkMonths": null,
    "WorkerType": null,
    "GeographyId": 300000023146885,
    "JobFamilyId": 300000027592889,
    "JobFunction": "Professional",
    "JobSchedule": "Full time",
    "BusinessUnit": null,
    "ContractType": null,
    "Organization": null,
    "TrendingFlag": false,
    "workLocation": [],
    "ContentLocale": "en",
    "HiringManager": null,
    "LegalEmployer": null,
    "RequisitionId": 300000097007174,
    "WorkplaceType": "",
    "BusinessUnitId": 300000001901027,
    "OrganizationId": 1,
    "GeographyNodeId": 300000034366171,
    "JobFunctionCode": "PROF",
    "LegalEmployerId": 300000001951056,
    "PrimaryLocation": "Menomonee Falls, WI, United States",
    "RequisitionType": "SKYGEN",
    "NumberOfOpenings": null,
    "WorkplaceTypeCode": null,
    "BeFirstToApplyFlag": false,
    "otherWorkLocations": [],
    "secondaryLocations": [],
    "ExternalContactName": null,
    "ShortDescriptionStr": "",
    "ExternalContactEmail": null,
    "ExternalPostedEndDate": null,
    "OtherRequisitionTitle": null,
    "requisitionFlexFields": [
      {
        "Value": "$85,202 - $127,802",
        "Prompt": "Pay Range",
        "ControlType": "TextArea",
        "SequenceNumber": 4
      }
    ],
    "ApplyWhenNotPostedFlag": null,
    "DomesticTravelRequired": null,
    "ExternalDescriptionStr": "<p><span><strong>What are important things that YOU need to know about this role?&nbsp;</strong></span></p><ul style=\"list-style-type: disc;\"><li><span><strong>Experience</strong>: 3–5 years of financial reporting or analytics experience, with strong SQL and advanced Excel skills to drive data-driven insights&nbsp;&nbsp;</span></li><li><span><strong>Work Location</strong>: Enjoy the flexibility of permanent remote work, but our ideal candidate will live near our Menomonee Falls office and able to join us onsite for occasional meetings</span></li></ul><p><br><span><strong>What will YOU be doing for us?</strong>&nbsp; &nbsp;Take an active role in the financial performance of the company by using data analysis and analytics to optimize financial reporting and processes to ensure accurate, timely and enhanced data and reporting for the organization.&nbsp;</span></p><p><span><strong>What will YOU be working on every day?&nbsp;</strong></span></p><p style=\"margin-left: 0.25in;\"><span><strong>Financial Reporting &amp; Analysis</strong></span></p><ul style=\"list-style-type: disc;\"><li>Prepare, analyze, and interpret monthly, quarterly, and annual TPA financial reports.</li><li>Support Finance and Operations by completing financial analysis and TPA reporting.</li><li>Develop and maintain dashboards, external reporting deliverables, and management reporting packages.</li><li>Ensure accuracy and consistency of financial data across systems and reports.</li></ul><p style=\"margin-left: 0.25in;\"><span><strong>Data &amp; Systems</strong></span></p><ul style=\"list-style-type: disc;\"><li>Use SQL to extract, transform, and analyze data from multiple sources.</li><li>Build and maintain SQL queries, views, and datasets to support reporting and ad‑hoc analysis.</li><li>Collaborate with IT, data teams, and business partners to improve data quality and streamline reporting workflows.</li><li>Assist in system enhancements, testing, and implementation of new financial tools or modules.</li></ul><p style=\"margin-left: 0.25in;\"><span><strong>Process Improvement</strong></span></p><ul style=\"list-style-type: disc;\"><li>Identify opportunities to automate manual processes and improve reporting efficiency.</li><li>Document processes, controls, and reporting standards.</li><li>Support internal and external audit requests with accurate, well‑organized data.</li></ul><p><span><strong>What qualifications do YOU need to have to be GOOD candidate?</strong></span></p><ul style=\"list-style-type: disc;\"><li>Bachelor’s degree in Accounting, Finance, Data Analytics or a related field.</li><li>3-5 years experience with financial reporting, general ledger systems, and finance operations</li><li>Strong SQL proficiency (writing queries, joining tables, troubleshooting data issues).</li><li>Solid understanding of accounting principles.</li><li>Advanced Excel skills (pivot tables, lookups, modeling).</li><li>Strong analytical mindset and attention to detail.</li></ul><p><span><strong>What qualifications do YOU need to have to be a GREAT candidate?&nbsp;</strong></span></p><ul style=\"list-style-type: disc;\"><li>Experience with BI tools (Power BI, Tableau, Looker, etc.).</li><li>Familiarity with ERP systems (SAP and Oracle).</li><li>Experience working with large datasets or data warehouses.</li><li>CPA, CMA, or progress toward certification.</li></ul><p>&nbsp;</p><p><i><span>The salary range and midpoint is listed below for your reference. Please keep in mind that your education and experience along with your knowledge, skills and abilities are taken into consideration when determining placement within the range.</span></i></p><p><span>Compensation Range: $85,202 - $127,802</span></p><p><span>Compensation Midpoint $106,502</span></p>",
    "ObjectVerNumberProfile": null,
    "PrimaryLocationCountry": "US",
    "CorporateDescriptionStr": "SKYGEN is the trusted partner for specialty benefits payers and government agencies responsible for the delivery and administration of dental and vision benefits. Through cutting-edge technology and service solutions, SKYGEN empowers clients to become the most efficient, effective healthcare organizations in the country.",
    "ExternalPostedStartDate": "2026-06-17T19:18:23+00:00",
    "ExternalQualificationsStr": "",
    "InternalQualificationsStr": "",
    "OrganizationDescriptionStr": "",
    "primaryLocationCoordinates": [
      {
        "Latitude": "43.1731",
        "Longitude": "-88.10368",
        "CountryCode": "US",
        "GeographyId": 300000023146885,
        "GeographyNodeId": 300000034366171
      }
    ],
    "ExternalResponsibilitiesStr": "",
    "InternalResponsibilitiesStr": "",
    "InternationalTravelRequired": null
  },
  "list_job": {
    "Id": "3276",
    "Title": "Financial Analyst III - TPA",
    "JobType": null,
    "Distance": 1781654400000,
    "JobShift": null,
    "Language": "US",
    "WorkDays": null,
    "JobFamily": null,
    "Relevancy": 8,
    "WorkHours": null,
    "Department": null,
    "HotJobFlag": false,
    "PostedDate": "2026-06-17",
    "StudyLevel": null,
    "WorkerType": null,
    "GeographyId": 300000023146885,
    "JobFunction": null,
    "JobSchedule": null,
    "BusinessUnit": null,
    "ContractType": null,
    "ManagerLevel": null,
    "Organization": null,
    "TrendingFlag": false,
    "workLocation": [],
    "LegalEmployer": null,
    "MediaThumbURL": null,
    "WorkplaceType": "",
    "BusinessUnitId": 300000001901027,
    "OrganizationId": 1,
    "PostingEndDate": null,
    "LegalEmployerId": 300000001951056,
    "PrimaryLocation": "Menomonee Falls, WI, 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://fa-eqhn-saasfaprod1.fa.ocs.oraclecloud.com/hcmRestApi/resources/latest/recruitingCEJobRequisitionDetails?expand=all&onlyData=true&finder=ById;Id=%223276%22,siteNumber=CX_2",
    "http_status": 200,
    "content_type": "application/json",
    "response_bytes": 6827
  },
  "detail_errors": []
}