Senior IT Data Analyst

{
  "content_hash": "ba713a92390252983051bec0f39628f9cc732cff61c1f02244004e887ddf1aa2",
  "source_hash": "5d4df148ba77560a1826233a78fa9aad108b51f71c3ca4323dd43de9992c0b70",
  "last_changed_at": "2026-05-31T19:05:28.503Z",
  "active_status": "active"
}

{
  "language": "en",
  "location": {
    "raw": "Allied Benefit Systems - CHICAGO, IL 60606; 200 WEST ADAMS ST, CHICAGO, IL, 60606, USA",
    "city": "CHICAGO",
    "region": "IL",
    "country": "United States",
    "is_remote": true,
    "confidence": 0.8
  },
  "salary_max": 105000,
  "salary_min": 95000,
  "inferred_at": "2026-06-06T20:18:38.869Z",
  "launch_scope": {
    "reason": "english_us_canada",
    "included": true,
    "language": "en",
    "location": {
      "raw": "Allied Benefit Systems - CHICAGO, IL 60606; 200 WEST ADAMS ST, CHICAGO, IL, 60606, USA",
      "city": "CHICAGO",
      "region": "IL",
      "country": "United States",
      "is_remote": true,
      "confidence": 0.8
    },
    "countries": [
      "United States"
    ]
  },
  "remote_policy": "remote",
  "salary_period": "year",
  "workplace_type": "remote",
  "salary_currency": "USD"
}

{}

{
  "detail": {
    "city": "CHICAGO",
    "jobId": 167101,
    "level": "",
    "endDate": "",
    "legalId": 17,
    "isHotJob": false,
    "jobShift": "",
    "jobTitle": "Senior IT Data Analyst",
    "location": "Allied Benefit Systems - CHICAGO, IL 60606",
    "startDate": "",
    "clientCode": "16672",
    "remoteType": "Fully Remote",
    "description": "<p><span style=\"font-size:12pt;\"><span style=\"font-family:'Times New Roman', serif;\"><b><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">POSITION SUMMARY </span></span></b></span></span></p>\n\n<p><span style=\"font-size:12pt;\"><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">The Senior IT Data Analyst is responsible for performing quantitative analysis of complex business situations, such as strategies, performance, and solutions involving sales and customer performance. They may apply SQL skills and database tools to conduct the analysts. The Senior IT Data Analyst will be responsible for various aspects of data analytics, such as programming, mining, generation, and visualization. As a technical lead, the data analyst will be responsible for resolving issues and ensuring the success of projects assigned to their team. </span></span></span></span></p>\n\n<p> </p>\n\n<p><span style=\"font-size:12pt;\"><span style=\"font-family:'Times New Roman', serif;\"><b><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">ESSENTIAL FUNCTIONS </span></span></b></span></span></p>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Respond to data and product related inquiries in real-time to support business and technical teams. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Provide expertise and translate the business needs to design; and develop tools, techniques, and metrics, and dashboards for insights and data visualization. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Responsible for developing and executing tools to monitor and report on data quality. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Responsible for establishing appreciation and adherence to the principles of data quality management, including metadata, lineage, and business definitions. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Provide support to Tech teams in managing security mechanisms and data access governance. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Develop an understanding of the health insurance world in different areas of the business such as claims, eligibility, customer service, and stop loss. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Perform analyses of varied healthcare data to evaluate programs and product solutions using medical, dental, flex, pharmacy, lab, provider, and utilization data. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Maintain high standards of data quality and integrity. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Work closely with stakeholders to create dashboards and reports. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Design and code efficiently using SQL and other data reporting languages. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Help create and test SQL statements for data presentation and further automation. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Set up and monitor routine maintenance of SQL jobs and developing / maintaining an alert strategy(s) for failed jobs and database problems and/or failures. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Data modeling, including an understanding of all normalized forms, design and development of stored procedures, views, and triggers. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Manage daily / monthly data and reporting processes automated through SQL Server agent. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Create reports using a variety of tools and formats such as Excel, Power BI, PDFs, .txt files, etc. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Document methods, specifications, and findings clearly; contribute to the writing and presentation of results, findings, and conclusions. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Excellent attention to detail, ability to detect and correct problems within SQL script. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Meet Allied’s expectations for productivity, quality, and goal accomplishment. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Work closely with the manager to complete assigned tasks. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Adhere to, and apply all applicable privacy and security laws, including but not limited to HIPAA, HITECH and any regulations promulgated thereto. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Attend continuing education classes as required, including but not limited to HIPAA training. </span></span></span></span></span></li>\n\t<li style=\"margin-left:8px;\"><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\"><span style=\"color:#000000;\">Other duties as assigned.</span></span></span></span></span></span></li>\n</ul>\n\n<p> </p>\n\n<p><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><b><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">EDUCATION</span></span></b></span></span></span></p>\n\n<ul style=\"margin-bottom:11px;\">\n\t<li style=\"margin-bottom:11px;margin-left:8px;\"><span style=\"font-size:11pt;\"><span style=\"line-height:107%;\"><span style=\"font-family:Calibri, sans-serif;\"><span style=\"font-family:Arial, sans-serif;\">Bachelor’s degree required with a focus in Computer Science, Math, Statistics, or equivalent work experience required. </span></span></span></span></li>\n</ul>\n\n<p> </p>\n\n<p><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><b><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">EXPERIENCE AND SKILLS</span></span></b> </span></span></span></p>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">4-5 years of data analyst experience required. Health care experience preferred. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">4 to 5 years’ experience with MS SQL Server required. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Experience with SQL Server Development – creating and modifying complex stored procedures. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Proficient with reporting and business intelligence tools like Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Integration Services (SSIS), and Power BI. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Ability to collaborate well with team members. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Experience working in a data warehouse environment as well as the ability to work with large data sets from multiple data sources. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Proficient computer skills, including Microsoft Office Suite (Word, Excel, Access and Power Point). </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Demonstrated analytical and problem-solving skills. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Strong written, verbal communication, and analytical skills are required. </span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Usage of SQL Profiler.</span></span></span></span></span></li>\n</ul>\n\n<ul>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Experience with Power Automate. </span></span></span></span></span></li>\n\t<li><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">Knowledge of integrating SQL Server solutions in .NET environments, with working knowledge of C#, ASP.NET and SOA with web services. </span></span></span></span></span></li>\n</ul>\n\n<p> </p>\n\n<p><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><b><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">POSITION COMPETENCIES</span></span></b></span></span></span></p>\n\n<ul style=\"margin-bottom:11px;\">\n\t<li><span style=\"font-size:12pt;\"><span style=\"color:#000000;\"><span style=\"line-height:107%;\"><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:11pt;\"><span style=\"line-height:107%;\"><span style=\"font-family:Arial, sans-serif;\"><span style=\"color:#000000;\">Accountability</span></span></span></span></span></span></span></span></li>\n\t<li style=\"margin-left:8px;\"><span style=\"font-size:11pt;\"><span style=\"line-height:107%;\"><span style=\"font-family:Calibri, sans-serif;\"><span style=\"font-family:Arial, sans-serif;\"><span style=\"color:#000000;\">Analytical Problem Solving</span></span></span></span></span></li>\n\t<li style=\"margin-left:8px;\"><span style=\"font-size:11pt;\"><span style=\"line-height:107%;\"><span style=\"font-family:Calibri, sans-serif;\"><span style=\"font-family:Arial, sans-serif;\"><span style=\"color:#000000;\">Collaboration</span></span></span></span></span></li>\n\t<li style=\"margin-left:8px;\"><span style=\"font-size:11pt;\"><span style=\"line-height:107%;\"><span style=\"font-family:Calibri, sans-serif;\"><span style=\"font-family:Arial, sans-serif;\"><span style=\"color:#000000;\">Quality and Risk Management</span></span></span></span></span></li>\n\t<li style=\"margin-left:8px;\"><span style=\"font-size:11pt;\"><span style=\"line-height:107%;\"><span style=\"font-family:Calibri, sans-serif;\"><span style=\"font-family:Arial, sans-serif;\"><span style=\"color:#000000;\">Systems Thinking</span></span></span></span></span></li>\n\t<li style=\"margin-bottom:11px;margin-left:8px;\"><span style=\"font-size:11pt;\"><span style=\"line-height:107%;\"><span style=\"font-family:Calibri, sans-serif;\"><span style=\"font-family:Arial, sans-serif;\"><span style=\"color:#000000;\">Technical/Functional Expertise</span></span></span></span></span></li>\n</ul>\n\n<p> </p>\n\n<p><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><b><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">PHYSICAL DEMANDS</span></span></b></span></span></span></p>\n\n<ul style=\"margin-bottom:11px;\">\n\t<li style=\"margin-bottom:11px;margin-left:8px;\"><span style=\"font-size:11pt;\"><span style=\"line-height:115%;\"><span style=\"font-family:Calibri, sans-serif;\"><span style=\"font-family:Arial, sans-serif;\"><span style=\"color:#000000;\">This is a</span></span><span style=\"font-family:Arial, sans-serif;\"> standard desk role requiring extended sitting and computer work</span></span></span></span></li>\n</ul>\n\n<p><span style=\"font-size:12pt;\"><span><span style=\"font-family:'Times New Roman', serif;\"><b><span style=\"font-size:11pt;\"><span style=\"font-family:Arial, sans-serif;\">WORK ENVIRONMENT </span></span></b></span></span></span></p>\n\n<ul style=\"margin-bottom:11px;\">\n\t<li style=\"margin-bottom:11px;margin-left:8px;\"><span style=\"font-size:11pt;\"><span><span style=\"line-height:107%;\"><span style=\"font-family:Calibri, sans-serif;\"><span style=\"font-family:Arial, sans-serif;\">Remote</span></span></span></span></span></li>\n</ul>\n\n<p><span style=\"font-size:12pt;\"><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:10.5pt;\"><span style=\"font-family:Arial, sans-serif;\">Here at Allied, we believe that great talent can thrive from anywhere. Our remote friendly culture offers flexibility and the comfort of working from home, while also ensuring you are set up for success. To support a smooth and efficient remote work experience, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 100Mbps download/25Mbps upload. Reliable internet service is essential for staying connected and productive</span></span><span style=\"font-size:10.5pt;\"><span style=\"font-family:Calibri, sans-serif;\">.</span></span></span></span></p>\n\n<p><span style=\"font-size:12pt;\"><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:10.5pt;\"><span style=\"font-family:Arial, sans-serif;\">The company has reviewed this job description to ensure that essential functions and basic duties have been included. It is not intended to be construed as an exhaustive list of all functions, responsibilities, skills, and abilities. Additional functions and requirements may be assigned by supervisors as deemed appropriate.</span></span></span></span></p>\n\n<p><span style=\"font-size:12pt;\"><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:10.5pt;\"><span style=\"font-family:Arial, sans-serif;\">Compensation is not limited to base salary.  Allied values our Total Rewards, and offers a competitive Benefit Package including, but not limited to, Medical, Dental, Vision, Life and Disability Insurance, Generous Paid Time Off, Tuition Reimbursement, EAP, and a Technology Stipend.</span></span></span></span></p>\n\n<p><span style=\"font-size:12pt;\"><span style=\"font-family:'Times New Roman', serif;\"><span style=\"font-size:10.5pt;\"><span style=\"font-family:Arial, sans-serif;\">Allied reserves the right to amend, change, alter, and revise, pay ranges and benefits offerings at any time.  All applicants acknowledge that by applying to the position you understand that the specific pay range is contingent upon meeting the qualification and requirements of the role, and for the successful completion of the interview selection and process.  It is at the Company's discretion to determine what pay is provided to a candidate within the range associated with the role.</span></span></span></span></p>",
    "jobCategory": "Information Technology",
    "salaryRange": "$95,000.00 - $105,000.00 Salary",
    "socialMedia": {
      "xLink": {
        "text": "Allied%2520Benefit%2520Systems%2520Job%2520Opportunity%2520Senior%2520It%2520Data%2520Analyst"
      },
      "emailLink": {
        "subject": "Allied%20Benefit%20Systems%20Job%20Opportunity%20Senior%20It%20Data%20Analyst",
        "summary": "POSITION%20SUMMARY%20%0A%0AThe%20Senior%20IT%20Data%20Analyst%20is%20responsible%20for%20performing%20quantitative%20analysis%20of%20complex%20business%20situations%2C%20such%20as%20strategies%2C%20performance%2C%20and%20solutions%20involving%20sales%20and%20customer%20performance.%20They%20may%20apply%20SQL%20skills%20and%20database%20tools%20to%20conduct%20the%20analysts.%20The%20Senior%20IT%20Data%20Analyst%20will%20be%20responsible%20for%20various%20aspects%20of%20data%20analytics%2C%20such%20as%20programming%2C%20mining%2C%20generation%2C%20and%20visualization.%20As%20a%20technical%20lead%2C%20the%20data%20analyst%20will%20be%20responsible%20for%20resolving%20issues%20and%20ensuring%20the%20success%20of%20projects%20assigned%20to%20their%20team.%C2%0A%0A%C2%0A%0AESSENTIAL%20FUNCTIONS%20%0A%0A%0A%09Respond%20to%20data%20and%20product%20related%20inquiries%20in%20real-time%20to%20support%20business%20and%20technical%20teams.%C2%0A%0A%0A%0A%09Provide%20expertise%20and%20translate%20the%20business%20needs%20to%20design%3B%20and%20develop%20tools%2C%20techniques%2C%20and%20metrics%2C%20and%20dashboards%20for%20insights%20and%20data%20visualization.%C2%0A%0A%0A%0A%09Responsible%20for%20developing%20and%20executing%20tools%20to%20monitor%20and%20report%20on%20data%20quality.%C2%0A%0A%0A%0A%09Responsible%20for%20establishing%20appreciation%20and..."
      },
      "facebookLink": {
        "redirectUri": "",
        "facebookAppId": "773759036043100"
      },
      "linkedInLink": {}
    },
    "isQuickApply": false,
    "positionType": "Full Time",
    "countryPaidIn": "",
    "googleJobJson": "{\"@context\":\"https://schema.org/\",\"@type\":\"JobPosting\",\"title\":\"Senior IT Data Analyst\",\"identifier\":\"J16672167101\",\"url\":\"https://www.paycomonline.net/v4/ats/web.php/portal/518A90CE68B712867516B5A3986512DA/jobs/167101\",\"image\":\"https://www.paycomonline.net/v4/ats/web.php/application/style/logo?clientkey=518A90CE68B712867516B5A3986512DA\",\"baseSalary\":{\"@type\":\"MonetaryAmount\",\"currency\":\"USD\",\"value\":{\"@type\":\"QuantitativeValue\",\"minValue\":95000,\"maxValue\":105000,\"unitText\":\"\"}},\"datePosted\":\"2026-04-27\",\"description\":\"Job DetailsJob Location: Allied Benefit Systems - CHICAGO, IL 60606Position Type: Full TimeSalary Range: $95,000.00 - $105,000.00 SalaryJob Category: Information TechnologyPOSITION SUMMARY \\n\\nThe Senior IT Data Analyst is responsible for performing quantitative analysis of complex business situations, such as strategies, performance, and solutions involving sales and customer performance. They may apply SQL skills and database tools to conduct the analysts. The Senior IT Data Analyst will be responsible for various aspects of data analytics, such as programming, mining, generation, and visualization. As a technical lead, the data analyst will be responsible for resolving issues and ensuring the success of projects assigned to their team. \\n\\n \\n\\nESSENTIAL FUNCTIONS \\n\\n\\n\\tRespond to data and product related inquiries in real-time to support business and technical teams. \\n\\n\\n\\n\\tProvide expertise and translate the business needs to design; and develop tools, techniques, and metrics, and dashboards for insights and data visualization. \\n\\n\\n\\n\\tResponsible for developing and executing tools to monitor and report on data quality. \\n\\n\\n\\n\\tResponsible for establishing appreciation and adherence to the principles of data quality management, including metadata, lineage, and business definitions. \\n\\n\\n\\n\\tProvide support to Tech teams in managing security mechanisms and data access governance. \\n\\n\\n\\n\\tDevelop an understanding of the health insurance world in different areas of the business such as claims, eligibility, customer service, and stop loss. \\n\\n\\n\\n\\tPerform analyses of varied healthcare data to evaluate programs and product solutions using medical, dental, flex, pharmacy, lab, provider, and utilization data. \\n\\n\\n\\n\\tMaintain high standards of data quality and integrity. \\n\\n\\n\\n\\tWork closely with stakeholders to create dashboards and reports. \\n\\n\\n\\n\\tDesign and code efficiently using SQL and other data reporting languages. \\n\\n\\n\\n\\tHelp create and test SQL statements for data presentation and further automation. \\n\\n\\n\\n\\tSet up and monitor routine maintenance of SQL jobs and developing / maintaining an alert strategy(s) for failed jobs and database problems and/or failures. \\n\\n\\n\\n\\tData modeling, including an understanding of all normalized forms, design and development of stored procedures, views, and triggers. \\n\\n\\n\\n\\tManage daily / monthly data and reporting processes automated through SQL Server agent. \\n\\n\\n\\n\\tCreate reports using a variety of tools and formats such as Excel, Power BI, PDFs, .txt files, etc. \\n\\n\\n\\n\\tDocument methods, specifications, and findings clearly; contribute to the writing and presentation of results, findings, and conclusions. \\n\\n\\n\\n\\tExcellent attention to detail, ability to detect and correct problems within SQL script. \\n\\n\\n\\n\\tMeet Allied’s expectations for productivity, quality, and goal accomplishment. \\n\\n\\n\\n\\tWork closely with the manager to complete assigned tasks. \\n\\n\\n\\n\\tAdhere to, and apply all applicable privacy and security laws, including but not limited to HIPAA, HITECH and any regulations promulgated thereto. \\n\\n\\n\\n\\tAttend continuing education classes as required, including but not limited to HIPAA training. \\n\\tOther duties as assigned.\\n\\n\\n \\n\\nEDUCATION\\n\\n\\n\\tBachelor’s degree required with a focus in Computer Science, Math, Statistics, or equivalent work experience required. \\n\\n\\n \\n\\nEXPERIENCE AND SKILLS \\n\\n\\n\\t4-5 years of data analyst experience required. Health care experience preferred. \\n\\n\\n\\n\\t4 to 5 years’ experience with MS SQL Server required. \\n\\n\\n\\n\\tExperience with SQL Server Development – creating and modifying complex stored procedures. \\n\\n\\n\\n\\tProficient with reporting and business intelligence tools like Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Integration Services (SSIS), and Power BI. \\n\\n\\n\\n\\tAbility to collaborate well with team members. \\n\\n\\n\\n\\tExperience working in a data warehouse environment as well as the ability to work with large data sets from multiple data sources. \\n\\n\\n\\n\\tProficient computer skills, including Microsoft Office Suite (Word, Excel, Access and Power Point). \\n\\n\\n\\n\\tDemonstrated analytical and problem-solving skills. \\n\\n\\n\\n\\tStrong written, verbal communication, and analytical skills are required. \\n\\n\\n\\n\\tUsage of SQL Profiler.\\n\\n\\n\\n\\tExperience with Power Automate. \\n\\tKnowledge of integrating SQL Server solutions in .NET environments, with working knowledge of C#, ASP.NET and SOA with web services. \\n\\n\\n \\n\\nPOSITION COMPETENCIES\\n\\n\\n\\tAccountability\\n\\tAnalytical Problem Solving\\n\\tCollaboration\\n\\tQuality and Risk Management\\n\\tSystems Thinking\\n\\tTechnical/Functional Expertise\\n\\n\\n \\n\\nPHYSICAL DEMANDS\\n\\n\\n\\tThis is a standard desk role requiring extended sitting and computer work\\n\\n\\nWORK ENVIRONMENT \\n\\n\\n\\tRemote\\n\\n\\nHere at Allied, we believe that great talent can thrive from anywhere. Our remote friendly culture offers flexibility and the comfort of working from home, while also ensuring you are set up for success. To support a smooth and efficient remote work experience, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 100Mbps download/25Mbps upload. Reliable internet service is essential for staying connected and productive.\\n\\nThe company has reviewed this job description to ensure that essential functions and basic duties have been included. It is not intended to be construed as an exhaustive list of all functions, responsibilities, skills, and abilities. Additional functions and requirements may be assigned by supervisors as deemed appropriate.\\n\\nCompensation is not limited to base salary.  Allied values our Total Rewards, and offers a competitive Benefit Package including, but not limited to, Medical, Dental, Vision, Life and Disability Insurance, Generous Paid Time Off, Tuition Reimbursement, EAP, and a Technology Stipend.\\n\\nAllied reserves the right to amend, change, alter, and revise, pay ranges and benefits offerings at any time.  All applicants acknowledge that by applying to the position you understand that the specific pay range is contingent upon meeting the qualification and requirements of the role, and for the successful completion of the interview selection and process.  It is at the Company's discretion to determine what pay is provided to a candidate within the range associated with the role.Qualifications\",\"responsibilities\":\"POSITION SUMMARY \\n\\nThe Senior IT Data Analyst is responsible for performing quantitative analysis of complex business situations, such as strategies, performance, and solutions involving sales and customer performance. They may apply SQL skills and database tools to conduct the analysts. The Senior IT Data Analyst will be responsible for various aspects of data analytics, such as programming, mining, generation, and visualization. As a technical lead, the data analyst will be responsible for resolving issues and ensuring the success of projects assigned to their team. \\n\\n \\n\\nESSENTIAL FUNCTIONS \\n\\n\\n\\tRespond to data and product related inquiries in real-time to support business and technical teams. \\n\\n\\n\\n\\tProvide expertise and translate the business needs to design; and develop tools, techniques, and metrics, and dashboards for insights and data visualization. \\n\\n\\n\\n\\tResponsible for developing and executing tools to monitor and report on data quality. \\n\\n\\n\\n\\tResponsible for establishing appreciation and adherence to the principles of data quality management, including metadata, lineage, and business definitions. \\n\\n\\n\\n\\tProvide support to Tech teams in managing security mechanisms and data access governance. \\n\\n\\n\\n\\tDevelop an understanding of the health insurance world in different areas of the business such as claims, eligibility, customer service, and stop loss. \\n\\n\\n\\n\\tPerform analyses of varied healthcare data to evaluate programs and product solutions using medical, dental, flex, pharmacy, lab, provider, and utilization data. \\n\\n\\n\\n\\tMaintain high standards of data quality and integrity. \\n\\n\\n\\n\\tWork closely with stakeholders to create dashboards and reports. \\n\\n\\n\\n\\tDesign and code efficiently using SQL and other data reporting languages. \\n\\n\\n\\n\\tHelp create and test SQL statements for data presentation and further automation. \\n\\n\\n\\n\\tSet up and monitor routine maintenance of SQL jobs and developing / maintaining an alert strategy(s) for failed jobs and database problems and/or failures. \\n\\n\\n\\n\\tData modeling, including an understanding of all normalized forms, design and development of stored procedures, views, and triggers. \\n\\n\\n\\n\\tManage daily / monthly data and reporting processes automated through SQL Server agent. \\n\\n\\n\\n\\tCreate reports using a variety of tools and formats such as Excel, Power BI, PDFs, .txt files, etc. \\n\\n\\n\\n\\tDocument methods, specifications, and findings clearly; contribute to the writing and presentation of results, findings, and conclusions. \\n\\n\\n\\n\\tExcellent attention to detail, ability to detect and correct problems within SQL script. \\n\\n\\n\\n\\tMeet Allied’s expectations for productivity, quality, and goal accomplishment. \\n\\n\\n\\n\\tWork closely with the manager to complete assigned tasks. \\n\\n\\n\\n\\tAdhere to, and apply all applicable privacy and security laws, including but not limited to HIPAA, HITECH and any regulations promulgated thereto. \\n\\n\\n\\n\\tAttend continuing education classes as required, including but not limited to HIPAA training. \\n\\tOther duties as assigned.\\n\\n\\n \\n\\nEDUCATION\\n\\n\\n\\tBachelor’s degree required with a focus in Computer Science, Math, Statistics, or equivalent work experience required. \\n\\n\\n \\n\\nEXPERIENCE AND SKILLS \\n\\n\\n\\t4-5 years of data analyst experience required. Health care experience preferred. \\n\\n\\n\\n\\t4 to 5 years’ experience with MS SQL Server required. \\n\\n\\n\\n\\tExperience with SQL Server Development – creating and modifying complex stored procedures. \\n\\n\\n\\n\\tProficient with reporting and business intelligence tools like Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Integration Services (SSIS), and Power BI. \\n\\n\\n\\n\\tAbility to collaborate well with team members. \\n\\n\\n\\n\\tExperience working in a data warehouse environment as well as the ability to work with large data sets from multiple data sources. \\n\\n\\n\\n\\tProficient computer skills, including Microsoft Office Suite (Word, Excel, Access and Power Point). \\n\\n\\n\\n\\tDemonstrated analytical and problem-solving skills. \\n\\n\\n\\n\\tStrong written, verbal communication, and analytical skills are required. \\n\\n\\n\\n\\tUsage of SQL Profiler.\\n\\n\\n\\n\\tExperience with Power Automate. \\n\\tKnowledge of integrating SQL Server solutions in .NET environments, with working knowledge of C#, ASP.NET and SOA with web services. \\n\\n\\n \\n\\nPOSITION COMPETENCIES\\n\\n\\n\\tAccountability\\n\\tAnalytical Problem Solving\\n\\tCollaboration\\n\\tQuality and Risk Management\\n\\tSystems Thinking\\n\\tTechnical/Functional Expertise\\n\\n\\n \\n\\nPHYSICAL DEMANDS\\n\\n\\n\\tThis is a standard desk role requiring extended sitting and computer work\\n\\n\\nWORK ENVIRONMENT \\n\\n\\n\\tRemote\\n\\n\\nHere at Allied, we believe that great talent can thrive from anywhere. Our remote friendly culture offers flexibility and the comfort of working from home, while also ensuring you are set up for success. To support a smooth and efficient remote work experience, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 100Mbps download/25Mbps upload. Reliable internet service is essential for staying connected and productive.\\n\\nThe company has reviewed this job description to ensure that essential functions and basic duties have been included. It is not intended to be construed as an exhaustive list of all functions, responsibilities, skills, and abilities. Additional functions and requirements may be assigned by supervisors as deemed appropriate.\\n\\nCompensation is not limited to base salary.  Allied values our Total Rewards, and offers a competitive Benefit Package including, but not limited to, Medical, Dental, Vision, Life and Disability Insurance, Generous Paid Time Off, Tuition Reimbursement, EAP, and a Technology Stipend.\\n\\nAllied reserves the right to amend, change, alter, and revise, pay ranges and benefits offerings at any time.  All applicants acknowledge that by applying to the position you understand that the specific pay range is contingent upon meeting the qualification and requirements of the role, and for the successful completion of the interview selection and process.  It is at the Company's discretion to determine what pay is provided to a candidate within the range associated with the role.\",\"employmentType\":\"FULL_TIME\",\"hiringOrganization\":{\"@type\":\"Organization\",\"name\":\"Allied Benefit Systems\",\"logo\":\"https://www.paycomonline.net/v4/ats/web.php/application/style/logo?clientkey=518A90CE68B712867516B5A3986512DA\"},\"jobLocation\":{\"@type\":\"Place\",\"address\":{\"streetAddress\":\"200 WEST ADAMS ST\",\"addressLocality\":\"CHICAGO\",\"addressRegion\":\"IL\",\"postalCode\":60606,\"addressCountry\":\"USA\"}},\"industry\":\"Information Technology\",\"validThrough\":\"-0001-11-30\"}",
    "applyAvailable": true,
    "educationLevel": "",
    "qualifications": "",
    "descriptionTitle": "Description",
    "travelPercentage": "",
    "jobYoutubeVideoId": "",
    "legalRevisionDate": {
      "date": "2026-01-15T10:45:37.000Z",
      "timezone": "America/Chicago",
      "timezone_type": 3
    },
    "secondaryLocations": [],
    "primaryPhoneCountry": "US",
    "primaryPhoneEnabled": true,
    "qualificationsTitle": "Qualifications",
    "primaryPhoneRequired": true,
    "primaryPhoneNumberDoesNotExist": false
  },
  "preview": {
    "jobId": 167101,
    "isHotJob": false,
    "jobTitle": "Senior IT Data Analyst",
    "postedOn": "",
    "locations": "Allied Benefit Systems - CHICAGO, IL 60606",
    "remoteType": "Fully Remote",
    "description": "POSITION SUMMARY \n\nThe Senior IT Data Analyst is responsible for performing quantitative analysis of complex business situations, such as strategies, ...",
    "positionType": "Full Time"
  },
  "detail_meta": {
    "url": "https://portal-applicant-tracking.us-cent.paycomonline.net/api/ats/job-postings/167101",
    "http_status": 200,
    "content_type": "application/json",
    "response_bytes": 47516
  },
  "detail_errors": []
}