Senior Business Analyst

Vizient, Inc; Irving (TX); Hybrid; USD 119,000 - 156,000; Full time

Benefits offered by this job

Benefits plan

Job summary

Vizient, Inc is seeking a data analyst to develop and maintain state data warehouses, manage ETL/ELT workflows, and standardize quality assurance for healthcare data.

You will design data pipelines with SQL Server and Alteryx, lead QE data projects, and deliver dashboards that track quarterly KPIs and contract performance.

Qualifications

• Master's degree required in Statistics, Health Informatics and Analytics, or related field.
• 3 years experience in data analyst or related occupation.
• Hands-on with large-scale healthcare data systems and QE data.
• Experience leading data extraction and analytics projects using SQL, Alteryx, and automation.

Responsibilities

• Develop and maintain State Data Warehouse using SQL Server, Alteryx, and ETL/ELT workflows.
• Ingest, transform, validate, and QA third‑party healthcare data across state datasets.
• Architect and maintain healthcare data warehouses for longitudinal, cross‑state analysis.
• Create dashboards to track KPI metrics and monitor vendor contracts.

Skills

Data analysis

Statistical methods

Dashboard design

ETL/ELT knowledge

Education

Master's degree in Statistics, Health Informatics and Analytics, or related field

Tools

SQL Server

Alteryx

Power Automate

Job description

When you’re the best, we’re the best. We instill an environment where employees feel engaged, satisfied and able to contribute their unique skills and talents while living and working as their authentic selves. We provide extensive opportunities for personal and professional development, building both employee competence and organizational capability to fuel exceptional performance through an inclusive environment both now and in the future.

DUTIES:

Develop and maintain State Data Warehouse by using statistical methods to design, implement, and manage software and data workflows used for ingesting, transforming, validating, and performing quality assurance of third‑party healthcare data. Collect, organize, interpret, and summarize numerical data to provide usable information. Manage the implementation, enhancement, and ongoing maintenance of new and existing data workflows, including state‑level ETL processes and SQL‑based transformations, and identify opportunities to improve data acquisition, standardization, quality assurance, and delivery across large‑scale healthcare datasets. Architect and maintain healthcare data warehouses and master datasets using SQL Server, Alteryx, and orchestration frameworks, enabling longitudinal, cross‑state analysis critical to provider performance measurement and regulatory compliance. Lead healthcare data projects involving CMS Qualified Entity (QE) datasets, including data ingestion, standardization, validation, and de‑identification of healthcare records in compliance with regulatory and privacy requirements. Conduct gap analysis to identify solutions that meet documented business requirements and collaborate with development teams to ensure technical designs meet established standards. Develop automated business and operational workflows using Power Automate to support processes such as use case submissions, approval management, operational tracking, and analytics request fulfillment. Design and develop analytical dashboards to track quarterly and year‑over‑year key performance indicator (KPI) metrics and to support monitoring and management of vendor contracts, including renewal timelines and notifications. Uses the following tools and technologies: SQL Server (SSMS), Relational Database Management Systems, Advanced SQL, Alteryx, ETL/ELT Data Processing Frameworks, Data Warehousing Architectures, Healthcare Claims and Discharge Data, CMS Qualified Entity (QE) Data, ICD-9-CM, ICD-10-CM, ICD-10-PCS, CPT/HCPCS Diagnosis and Procedure Coding Systems.

MINIMUM REQUIREMENTS:

This position requires a Master’s degree or equivalent in Statistics, Health Informatics and Analytics, or a related field and 3 years of experience in a data analyst or related occupation. Must also have 36 months of experience with each of the following:

• 1) Working with large-scale healthcare data systems, including CMS Qualified Entity (QE) claims data, ICD-9-CM, ICD-10-CM, ICD-10-PCS, CPT/HCPCS diagnosis and procedure codes, healthcare claims data, insurance adjudication processes, and clinical data management.
• 2) Developing and maintaining healthcare data warehouses and master datasets using the following: SQL Server, relational database structures, stored procedures, and ETL/ELT workflows.
• 3) Designing and implementing data governance and quality assurance frameworks using validation rules, reconciliation processes, longitudinal data consistency checks, and audit documentation for regulated healthcare data.
• 4) Leading healthcare data extraction and analytics projects using SQL-based querying, Alteryx workflows, and automation. Will accept experience gained before, during or after Master’s program. Employer will accept experience gained concurrently.

Full-time, based in Irving, TX. Telecommuting available within commuting distance from HQ at 290 E John Carpenter Fwy, Irving, TX 75062.

Salary: $118,893 to $155,500/year.

Visa sponsorship not available for this position.

This position is also incentive eligible.

Vizient has a comprehensive benefits plan!

Equal Opportunity Employer: Females/Minorities/Veterans/Individuals with Disabilities

The Company is committed to equal employment opportunity to all employees and applicants without regard to race, religion, color, gender identity, ethnicity, age, national origin, sexual orientation, disability status, veteran status or any other category protected by applicable law.

Working at Vizient means shaping the future of healthcare, every day. Alongside our clients, we're building a healthier, more human healthcare system. We connect people, data, and solutions to enable healthcare organizations to improve financial sustainability, enhance system performance, and deliver better care.

Headquartered in Irving, Texas, with 11 offices across the United States, Vizient has more than 5,000 employees who bring deep expertise and a shared commitment to transforming healthcare. Together, we're solving some of the industry's most complex challenges while creating opportunities to learn, grow, and drive lasting change for healthcare organizations and the communities they serve.

Through our enterprise of companies, we deliver meaningful impact across the continuum of care: Apexus - The exclusive contractor for 340B Drug Pricing Program, managed by the Health Resources and Services Administration. aptitude - The industry's first online direct contracting market, supporting self-contracting activity between hospitals and suppliers. Kaufman Hall - Leading healthcare advisory services to support our clients in achieving financial, clinical, and operational excellence. Provista - Proven supply chain partner specializing in extended, diagnostic, and preventive care facilities, including surgery centers, home health, and senior living.