Senior SQL & Power BI Analyst

{
  "content_hash": "4bbc3d69c625be044873f3a47205c736826fd9cf75d64fe3292327d0b890efdb",
  "source_hash": "17e83bc54f5819f1e0c8eae8d0b87ac187551373f4e576457dd101b0e1c762a7",
  "last_changed_at": "2026-05-31T19:05:42.723Z",
  "active_status": "active"
}

{
  "language": "en",
  "location": {
    "raw": "ADDISON, TX 75001; 15305 DALLAS PKWY, ADDISON, TX, 75001, USA",
    "city": "ADDISON",
    "region": "TX",
    "country": "United States",
    "is_remote": false,
    "confidence": 0.8
  },
  "salary_max": null,
  "salary_min": null,
  "inferred_at": "2026-06-06T20:38:54.124Z",
  "launch_scope": {
    "reason": "english_us_canada",
    "included": true,
    "language": "en",
    "location": {
      "raw": "ADDISON, TX 75001; 15305 DALLAS PKWY, ADDISON, TX, 75001, USA",
      "city": "ADDISON",
      "region": "TX",
      "country": "United States",
      "is_remote": false,
      "confidence": 0.8
    },
    "countries": [
      "United States"
    ]
  },
  "remote_policy": null,
  "salary_period": null,
  "workplace_type": "on_site",
  "salary_currency": null
}

{}

{
  "detail": {
    "city": "ADDISON",
    "jobId": 44186,
    "level": "",
    "endDate": "",
    "legalId": 118,
    "isHotJob": false,
    "jobShift": "",
    "jobTitle": "Senior SQL & Power BI Analyst ",
    "location": "ADDISON, TX 75001",
    "startDate": "",
    "clientCode": "13V07",
    "remoteType": "",
    "description": "<p><span style=\"font-family:Aptos,sans-serif\"><strong>Location: Addison, TX (On-Site)</strong></span><br />\n&nbsp;</p>\n\n<p><strong>*No Agencies*</strong></p>\n\n<p><strong>*Candidates must be eligible to work in the U.S. without employer sponsorship.*</strong></p>\n\n<p><span style=\"font-family:Aptos,sans-serif\"><strong>Position Overview</strong></span></p>\n\n<p><span style=\"font-family:Aptos,sans-serif\">We are seeking a hands-on data analyst with strong SQL and Power BI expertise to support healthcare operational and financial reporting. This role is responsible for building governed, reconciled, drillable reporting that leadership can rely on for decision-making.</span></p>\n\n<p><span style=\"font-family:Aptos,sans-serif\">This is not a dashboard-only role. The ideal candidate understands healthcare data structures, data validation discipline, and how to design models that produce accurate, defensible reporting.</span></p>\n\n<div style=\"margin-bottom:11px; text-align:center\">\n<hr /></div>\n\n<p><span style=\"font-family:Aptos,sans-serif\"><strong>Core Requirements (Must-Have)</strong></span></p>\n\n<p><span style=\"font-family:Aptos,sans-serif\"><strong>1. Advanced SQL (Primary Skill)</strong></span></p>\n\n<ul>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Write complex SQL queries across multiple tables (joins, CTEs, aggregations, subqueries)</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Validate and reconcile data against source systems</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Optimize queries for performance</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Ensure accuracy of financial and operational reporting outputs</span></li>\n</ul>\n\n<p><span style=\"font-family:Aptos,sans-serif\"><strong>2. Strong Power BI Development</strong></span></p>\n\n<ul>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Build semantic models and reports in Microsoft Power BI</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Develop measures using DAX</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Design well-structured data models (star schema preferred)</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Enable drill-down and drill-through functionality for executive reporting</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Create interactive reports supporting multi-level healthcare analysis</span></li>\n</ul>\n\n<p><span style=\"font-family:Aptos,sans-serif\"><strong>3. Healthcare Industry Experience</strong></span></p>\n\n<ul>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Experience working with healthcare data (clinical, operational, or financial)</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Familiarity with healthcare systems such as EMR, practice management, or billing platforms</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Understanding of healthcare reporting nuances and data sensitivity</span></li>\n</ul>\n\n<p><span style=\"font-family:Aptos,sans-serif\"><strong>4. Governance &amp; Reconciliation Discipline</strong></span></p>\n\n<ul>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Reconcile report outputs to source systems</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Validate totals before distribution</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Document metric definitions and logic</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Maintain reporting standards and controls</span></li>\n</ul>\n\n<div style=\"margin-bottom:11px; text-align:center\">\n<hr /></div>\n\n<p><span style=\"font-family:Aptos,sans-serif\"><strong>Additional Skills (Preferred)</strong></span></p>\n\n<ul>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Experience supporting finance or operations leadership</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Familiarity with healthcare regulatory or compliance considerations</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Exposure to ETL concepts or data pipeline workflows</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Strong stakeholder communication skills</span></li>\n</ul>\n\n<div style=\"margin-bottom:11px; text-align:center\">\n<hr /></div>\n\n<p><span style=\"font-family:Aptos,sans-serif\"><strong>What Success Looks Like</strong></span></p>\n\n<ul>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Leadership can drill from summary metrics into transactional detail confidently</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Reports consistently reconcile to source systems</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Data models are structured, scalable, and maintainable</span></li>\n\t<li><span style=\"font-family:Aptos,sans-serif\">Reporting outputs are reliable and audit-defensible</span></li>\n</ul>\n\n<p>&nbsp;</p>\n",
    "jobCategory": "",
    "salaryRange": "",
    "socialMedia": {
      "xLink": null,
      "emailLink": null,
      "facebookLink": null,
      "linkedInLink": null
    },
    "isQuickApply": false,
    "positionType": "",
    "countryPaidIn": "",
    "googleJobJson": "{\"@context\":\"https://schema.org/\",\"@type\":\"JobPosting\",\"title\":\"Senior SQL & Power BI Analyst \",\"identifier\":\"J13V0744186\",\"url\":\"https://www.paycomonline.net/v4/ats/web.php/portal/A15BCCA045869F7332E892B1DF2E79F2/jobs/44186\",\"image\":\"https://www.paycomonline.net/v4/ats/web.php/application/style/logo?clientkey=A15BCCA045869F7332E892B1DF2E79F2\",\"datePosted\":\"2026-01-29\",\"description\":\"Job DetailsJob Location: ADDISON, TX 75001Location: Addison, TX (On-Site)\\n&nbsp;\\n\\n*No Agencies*\\n\\n*Candidates must be eligible to work in the U.S. without employer sponsorship.*\\n\\nPosition Overview\\n\\nWe are seeking a hands-on data analyst with strong SQL and Power BI expertise to support healthcare operational and financial reporting. This role is responsible for building governed, reconciled, drillable reporting that leadership can rely on for decision-making.\\n\\nThis is not a dashboard-only role. The ideal candidate understands healthcare data structures, data validation discipline, and how to design models that produce accurate, defensible reporting.\\n\\n\\n\\n\\nCore Requirements (Must-Have)\\n\\n1. Advanced SQL (Primary Skill)\\n\\n\\n\\tWrite complex SQL queries across multiple tables (joins, CTEs, aggregations, subqueries)\\n\\tValidate and reconcile data against source systems\\n\\tOptimize queries for performance\\n\\tEnsure accuracy of financial and operational reporting outputs\\n\\n\\n2. Strong Power BI Development\\n\\n\\n\\tBuild semantic models and reports in Microsoft Power BI\\n\\tDevelop measures using DAX\\n\\tDesign well-structured data models (star schema preferred)\\n\\tEnable drill-down and drill-through functionality for executive reporting\\n\\tCreate interactive reports supporting multi-level healthcare analysis\\n\\n\\n3. Healthcare Industry Experience\\n\\n\\n\\tExperience working with healthcare data (clinical, operational, or financial)\\n\\tFamiliarity with healthcare systems such as EMR, practice management, or billing platforms\\n\\tUnderstanding of healthcare reporting nuances and data sensitivity\\n\\n\\n4. Governance &amp; Reconciliation Discipline\\n\\n\\n\\tReconcile report outputs to source systems\\n\\tValidate totals before distribution\\n\\tDocument metric definitions and logic\\n\\tMaintain reporting standards and controls\\n\\n\\n\\n\\n\\nAdditional Skills (Preferred)\\n\\n\\n\\tExperience supporting finance or operations leadership\\n\\tFamiliarity with healthcare regulatory or compliance considerations\\n\\tExposure to ETL concepts or data pipeline workflows\\n\\tStrong stakeholder communication skills\\n\\n\\n\\n\\n\\nWhat Success Looks Like\\n\\n\\n\\tLeadership can drill from summary metrics into transactional detail confidently\\n\\tReports consistently reconcile to source systems\\n\\tData models are structured, scalable, and maintainable\\n\\tReporting outputs are reliable and audit-defensible\\n\\n\\n&nbsp;\\nQualifications\",\"responsibilities\":\"Location: Addison, TX (On-Site)\\n&nbsp;\\n\\n*No Agencies*\\n\\n*Candidates must be eligible to work in the U.S. without employer sponsorship.*\\n\\nPosition Overview\\n\\nWe are seeking a hands-on data analyst with strong SQL and Power BI expertise to support healthcare operational and financial reporting. This role is responsible for building governed, reconciled, drillable reporting that leadership can rely on for decision-making.\\n\\nThis is not a dashboard-only role. The ideal candidate understands healthcare data structures, data validation discipline, and how to design models that produce accurate, defensible reporting.\\n\\n\\n\\n\\nCore Requirements (Must-Have)\\n\\n1. Advanced SQL (Primary Skill)\\n\\n\\n\\tWrite complex SQL queries across multiple tables (joins, CTEs, aggregations, subqueries)\\n\\tValidate and reconcile data against source systems\\n\\tOptimize queries for performance\\n\\tEnsure accuracy of financial and operational reporting outputs\\n\\n\\n2. Strong Power BI Development\\n\\n\\n\\tBuild semantic models and reports in Microsoft Power BI\\n\\tDevelop measures using DAX\\n\\tDesign well-structured data models (star schema preferred)\\n\\tEnable drill-down and drill-through functionality for executive reporting\\n\\tCreate interactive reports supporting multi-level healthcare analysis\\n\\n\\n3. Healthcare Industry Experience\\n\\n\\n\\tExperience working with healthcare data (clinical, operational, or financial)\\n\\tFamiliarity with healthcare systems such as EMR, practice management, or billing platforms\\n\\tUnderstanding of healthcare reporting nuances and data sensitivity\\n\\n\\n4. Governance &amp; Reconciliation Discipline\\n\\n\\n\\tReconcile report outputs to source systems\\n\\tValidate totals before distribution\\n\\tDocument metric definitions and logic\\n\\tMaintain reporting standards and controls\\n\\n\\n\\n\\n\\nAdditional Skills (Preferred)\\n\\n\\n\\tExperience supporting finance or operations leadership\\n\\tFamiliarity with healthcare regulatory or compliance considerations\\n\\tExposure to ETL concepts or data pipeline workflows\\n\\tStrong stakeholder communication skills\\n\\n\\n\\n\\n\\nWhat Success Looks Like\\n\\n\\n\\tLeadership can drill from summary metrics into transactional detail confidently\\n\\tReports consistently reconcile to source systems\\n\\tData models are structured, scalable, and maintainable\\n\\tReporting outputs are reliable and audit-defensible\\n\\n\\n&nbsp;\\n\",\"employmentType\":\"OTHER\",\"hiringOrganization\":{\"@type\":\"Organization\",\"name\":\"OMS MEDICAL BILLING LLC\",\"logo\":\"https://www.paycomonline.net/v4/ats/web.php/application/style/logo?clientkey=A15BCCA045869F7332E892B1DF2E79F2\"},\"jobLocation\":{\"@type\":\"Place\",\"address\":{\"streetAddress\":\"15305 DALLAS PKWY\",\"addressLocality\":\"ADDISON\",\"addressRegion\":\"TX\",\"postalCode\":75001,\"addressCountry\":\"USA\"}},\"validThrough\":\"-0001-11-30\"}",
    "applyAvailable": true,
    "educationLevel": "",
    "qualifications": "",
    "descriptionTitle": "Description",
    "travelPercentage": "",
    "jobYoutubeVideoId": "",
    "legalRevisionDate": {
      "date": "2025-04-28T16:23:47.000Z",
      "timezone": "America/Chicago",
      "timezone_type": 3
    },
    "secondaryLocations": [],
    "primaryPhoneCountry": "US",
    "primaryPhoneEnabled": true,
    "qualificationsTitle": "Qualifications",
    "primaryPhoneRequired": true,
    "primaryPhoneNumberDoesNotExist": false
  },
  "preview": {
    "jobId": 44186,
    "isHotJob": false,
    "jobTitle": "Senior SQL & Power BI Analyst ",
    "postedOn": "",
    "locations": "ADDISON, TX 75001",
    "remoteType": "",
    "description": "Location: Addison, TX (On-Site)\n \n\n*No Agencies*\n\n*Candidates must be eligible to work in the U.S. without employer sponsorship.*\n\nPosition Overview\n\n...",
    "positionType": ""
  },
  "detail_meta": {
    "url": "https://portal-applicant-tracking.us-cent.paycomonline.net/api/ats/job-postings/44186",
    "http_status": 200,
    "content_type": "application/json",
    "response_bytes": 14374
  },
  "detail_errors": []
}