Business Intelligence Analyst / Developer

Duration: 17 Months (1.4 Years)

State: Oregon, locals only

 Business Intelligence Analyst / Developer (Medicaid ETL Modernization):

Total Required Experience in Years: 8%2B Years

Mode of Work: Remote (Oregon Local Candidates Required)

Job Description:

The client is seeking an experienced Business Intelligence Analyst / Developer to support modernization of the Health Analytics Library (HAL) Medicaid reporting data mart. The selected candidate will play a key role in converting legacy SAS-based ETL processes into SQL and Python-based solutions while supporting Medicaid claims analytics, enrollment reporting, and healthcare data modernization initiatives.

This role requires strong hands-on experience with Medicaid administrative data, ETL development, SQL programming, Python development, data warehousing, and healthcare analytics. Candidates must demonstrate recent experience working with Medicaid claims data and enterprise ETL processes.

Key Responsibilities:

• Analyze existing HAL data systems, architecture, schemas, tables, ETL processes, and reporting environments.

• Gather, document, and validate business, technical, data, and integration requirements.

• Design, develop, and implement ETL pipelines for Medicaid data processing.

• Convert legacy SAS ETL processes into SQL and Python-based solutions.

• Develop and maintain SQL stored procedures, transformations, and data integration workflows.

• Build and optimize data pipelines supporting Medicaid enrollment and claims reporting.

• Create and maintain data models, tables, views, and reporting structures.

• Perform testing, troubleshooting, validation, and production deployment activities.

• Collaborate with project managers, business analysts, DBAs, architects, and healthcare stakeholders.

• Support modernization initiatives involving AWS and future Azure migration readiness.

• Develop technical documentation, code documentation, and implementation guides.

• Participate in code reviews and release management activities.

Required Skills:

• 5%2B years of hands-on SQL programming experience.

• 5%2B years of Python development experience.

• 5%2B years of ETL/ELT development experience.

• 5%2B years of healthcare data analytics experience.

• 5%2B years of Medicaid claims and enrollment data experience.

• Strong experience with:

  • Data Warehousing

  • Data Modeling

  • Data Integration

  • Data Transformation

  • Data Quality

• Experience with Microsoft DevOps, Git, or other source code management tools.

• Strong analytical and problem-solving skills.

• Excellent verbal and written communication skills.

• Experience gathering and documenting technical requirements.

Preferred Skills:

• SAS programming experience.

• Jupyter Notebook experience.

• AWS cloud platform experience.

• Azure cloud platform experience.

• Experience modernizing legacy healthcare systems.

• Experience with Agile development methodologies.

• Experience supporting Medicaid reporting environments.

• Knowledge of healthcare financial, claims, enrollment, and utilization reporting.

Qualifications:

• Bachelor\'s Degree in Data Science, Computer Science, Mathematics, Statistics, Information Systems, Healthcare Analytics, or related field.

Education:

• Bachelor\'s Degree required.

• Master\'s Degree preferred.

Certifications:

• Healthcare Data Analytics certifications preferred.

• SQL certifications preferred.

• AWS or Azure certifications preferred.

Mandatory Requirements:

Recent Medicaid experience

Strong ETL background

SQL Programming

Python Programming

Candidates without recent Medicaid and ETL experience will not be considered.

Additional Information:

• Location: Remote (Oregon Local Candidates Only)

• Client: Oregon Health Authority (OHA)

• Duration: 1.4 Years

• Visa Accepted: USC, GC, GC-EAD, H4-EAD

• Focus Area: Medicaid Claims, Enrollment Data, ETL Modernization, Healthcare Analytics

• Future Environment: AWS Azure Modernization Initiative