ZipRecruiter

Log In

1

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

Vergence

Senior ETL/Python Developer

Springfield, IL

$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 ...

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 Jun 26, 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.

Is data warehouse a good career?

A career as a data warehouse professional involves designing, developing, and maintaining data storage systems that support business intelligence and analytics. It typically requires skills in SQL, ETL processes, and tools like Snowflake or Redshift, with opportunities across various industries. The role offers strong job growth, competitive salaries, and the chance to work with emerging data technologies.

Is a BI analyst entry level?

A BI analyst role can be entry level or require several years of experience, depending on the company and specific job requirements. Entry-level BI analysts typically have a basic understanding of data analysis tools like SQL, Excel, and visualization software such as Tableau or Power BI, and may hold a relevant bachelor's degree. More advanced positions may require additional experience or certifications in data warehousing or business intelligence.

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 the difference between DWH and BI?

A Data Warehouse (DWH) is a centralized repository that stores large volumes of integrated data from multiple sources, enabling efficient data analysis. Business Intelligence (BI) involves tools and processes that analyze data from the DWH to generate reports, dashboards, and insights for decision-making. For a BI Data Warehouse role, skills in data modeling, SQL, and BI tools like Tableau or Power BI are essential.

What is the role of data warehousing in BI?

In a BI Data Warehouse role, data warehousing is essential for consolidating and storing large volumes of structured data from multiple sources, enabling efficient analysis and reporting. It provides a centralized platform for data integration, supporting tools like SQL and ETL processes to facilitate business insights and decision-making.
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

Posted 15 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.