ZipRecruiter

Log In

1

Bi Data Warehouse Jobs in Springfield, IL (NOW HIRING)

Vergence

Senior ETL/Python Developer

Springfield, IL · On-site

$120K - $162K/yr

... BI teams across both legacy and cloud-based platforms. Job/Position Description * Design, develop ... Data modeling experience in enterprise data warehouse environments * Scripting experience ...

All JobsBi Data Warehouse JobsBi Data Warehouse Jobs in Springfield, IL

Bi Data Warehouse information

See Springfield, IL salary details

$24.8K

$124.7K

$169.5K

How much do bi data warehouse jobs pay per year?

As of Aug 6, 2026, the average yearly pay for bi data warehouse in Springfield, IL is $124,733.00, according to ZipRecruiter salary data. Most workers in this role earn between $106,000.00 and $158,600.00 per year, depending on experience, location, and employer.

What is the difference between Bi Data Warehouse vs Data Analyst?

AspectBi Data WarehouseData Analyst
Required CredentialsBachelor's in Computer Science, Data Management, or related field; certifications like Microsoft Certified Data AnalystBachelor's in Statistics, Mathematics, or related field; certifications like Microsoft Certified Data Analyst or Tableau Desktop Specialist
Work EnvironmentData warehouses are used in enterprise IT settings, often involving database management teamsBusiness environments, analyzing data to generate reports and insights
Employer & Industry UsageUsed by organizations managing large-scale data storage and integrationUsed across industries for data interpretation and decision-making

Bi Data Warehouse professionals focus on designing and maintaining data storage systems, while Data Analysts interpret data to support business decisions. Both roles require strong technical skills, but their primary functions differ in data management versus data analysis.

What is a BI data warehouse?

A BI data warehouse is a centralized repository that stores large volumes of integrated data from multiple sources to support business intelligence and analytics. BI professionals use tools like SQL and ETL processes to organize, analyze, and generate reports from the data, enabling informed decision-making.
What are popular job titles related to Bi Data Warehouse jobs in Springfield, IL? For Bi Data Warehouse jobs in Springfield, IL, the most frequently searched job titles are:
What job categories do people searching Bi Data Warehouse jobs in Springfield, IL look for? The top searched job categories for Bi Data Warehouse jobs in Springfield, IL are:
What cities near Springfield, IL are hiring for Bi Data Warehouse jobs? Cities near Springfield, IL with the most Bi Data Warehouse job openings:
Bi Data Warehouse jobs near you

Medicaid Business/QA Analyst

MSR Technology Group

Springfield, IL • Remote

Contractor

Re-posted 26 days ago

Job description

Medicaid Business / QA Analyst
  • 7–12+ Month Contract | Remote | No ThirdParty Firms | Medicaid SME Required
  • Candidates with previous State Medicaid program experience will be given strong consideration.
  • Drug screen and background check required as part of onboarding
Position Summary
The Medicaid Business/QA Analyst serves as a subject matter expert (SME) for Medicaid data and processes while performing quality assurance testing within a large-scale Enterprise Data Warehouse (EDW) environment. This position combines program knowledge—eligibility, claims, encounters, provider enrollment, managed care, and reporting—with QA discipline to ensure accuracy, completeness, and usability of EDW deliverables such as data marts, inbound source data loads, outbound extracts, reporting outputs, and operational dashboards.
Key Responsibilities1. Business SME – Medicaid Data & Processes
  • Interpret Medicaid data elements, business rules, and program logic for EDW initiatives.
  • Review inbound data from core systems (eligibility, provider, claims, managed care) for accuracy and mapping alignment.
  • Validate outbound extracts and reporting outputs for accuracy, timeliness, and format requirements.
  • Support development of data marts across eligibility, claims/utilization, provider, managed care, LTSS, and behavioral health.
2. QA Planning & Execution
  • Develop QA plans, scenarios, and test cases aligned to business rules.
  • Perform data reconciliation between source files and EDW target tables.
  • Validate transformations, aggregations, and derived fields.
  • Participate in User Acceptance Testing (UAT) with business stakeholders.
3. Data Quality & Issue Resolution
  • Identify data anomalies, mapping issues, and business rule gaps; work with data engineering and ETL teams to resolve.
  • Ensure referential integrity across eligibility, claims, provider, and plan datasets.
  • Define business data quality rules for ongoing monitoring.
  • Track and document issues in defect management tools.
4. Collaboration & Documentation
  • Work with business stakeholders, vendors, and technical teams to validate requirements and deliverables.
  • Review BRDs, mapping documentation, and data models for accuracy.
  • Maintain QA evidence, testing documentation, and business rule records.
  • Support knowledge transfer related to Medicaid data usage within the EDW.
Required Skills & Qualifications
  • Strong Medicaid business knowledge (eligibility, claims, encounters, provider, managed care).
  • Experience working with EDW environments, including inbound feeds, staging layers, integration layers, data marts, and outbound extracts.
  • Proficiency with SQL for validation and reconciliation.
  • Experience in data warehouse QA/testing, including validating data transformations and dimensional models.
  • Ability to translate Medicaid program rules into testable acceptance criteria.
  • Familiarity with HIPAA compliance and PHI guidelines.
  • Excellent analytical, documentation, and communication skills.
Preferred Qualifications
  • Experience with Medicaid EDW or MMIS modernization projects.
  • Familiarity with provider handbooks, policy documentation, or administrative rules.
  • Experience with managed care data (capitation, encounters, member assignments).
  • Experience validating dashboards or reports in tools such as Tableau, Power BI, or Cognos.
  • Background in data governance or metadata management.