Business Intelligence Analyst / Developer
SIRITECH SOLUTIONS CORP · United States
- Hybrid
- Full-time
- $120,000 / year
- United States
Tailored resume — keyword-matched to this role.
Hiring manager — we find who's hiring.
Intro email — drafted to reach them directly.
Job highlights
- Modernize Medicaid reporting data mart ETL.
- Convert SAS ETL to SQL and Python.
- Analyze and develop Medicaid data pipelines.
- Utilize SQL, Python, and data warehousing skills.
- Requires recent Medicaid and ETL experience.
About the role
Business Intelligence Analyst Developer Medicaid ETL Modernization
The client is seeking an experienced Business Intelligence Analyst / Developer to support the 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+ years of hands-on SQL programming experience.
- 5+ years of Python development experience.
- 5+ years of ETL/ELT development experience.
- 5+ years of healthcare data analytics experience.
- 5+ years of Medicaid claims and enrollment data experience.
- Strong experience with Data Warehousing, Data Modeling, Data Integration, Data Transformation, and 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. Master's Degree preferred. Healthcare Data Analytics, SQL, 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
Focus Area: Medicaid Claims, Enrollment Data, ETL Modernization, Healthcare Analytics
Future Environment: AWS Azure Modernization Initiative
Key skills/competency
- Business Intelligence
- Data Analysis
- ETL Development
- SQL Programming
- Python Development
- Data Warehousing
- Healthcare Analytics
- Medicaid Data
- Requirements Gathering
- Technical Documentation
Skills & topics
- Business Intelligence Analyst
- Business Intelligence Developer
- Medicaid ETL Modernization
- SQL
- Python
- ETL
- Data Warehousing
- Healthcare Analytics
- Oregon
- Remote
How to get hired
- Customize your resume: Highlight your 5+ years of SQL, Python, ETL, Medicaid claims, and healthcare analytics experience. Tailor it to match keywords from the job description.
- Craft a compelling cover letter: Emphasize your recent Medicaid experience and your ability to convert legacy SAS ETL to SQL/Python solutions. Mention your familiarity with data warehousing and healthcare data.
- Prepare for technical questions: Be ready to discuss your experience with ETL processes, data modeling, SQL stored procedures, and Python scripting, specifically in a healthcare context.
- Showcase collaboration skills: Be prepared to share examples of how you've worked with project managers, business analysts, and stakeholders to gather requirements and deliver technical solutions.
Technical preparation
Master SQL: stored procedures, transformations.,Practice Python: data manipulation, scripting.,Build ETL pipelines for Medicaid data.,Familiarize with AWS/Azure concepts.
Behavioral questions
Describe Medicaid data analysis challenge.,How to document complex technical requirements?,Share experience converting legacy ETL.,How do you collaborate with stakeholders?
Frequently asked questions
- What are the key technical skills required for the Business Intelligence Analyst Developer role at SIRITECH SOLUTIONS CORP?
- The Business Intelligence Analyst Developer role at SIRITECH SOLUTIONS CORP requires a strong foundation in SQL programming (5+ years), Python development (5+ years), and ETL/ELT development (5+ years). Significant experience in healthcare data analytics and specifically with Medicaid claims and enrollment data is also crucial. Proficiency in Data Warehousing, Data Modeling, Data Integration, Data Transformation, and Data Quality is essential.
- Is recent Medicaid experience mandatory for this Business Intelligence Analyst Developer position?
- Yes, recent Medicaid experience is a mandatory requirement for this Business Intelligence Analyst Developer position. Candidates without recent Medicaid and ETL experience will not be considered for this role.
- What is the work arrangement for the Business Intelligence Analyst Developer role?
- The Business Intelligence Analyst Developer role is a remote position. However, it specifically requires candidates who are local to Oregon.
- What is the expected duration of the Business Intelligence Analyst Developer contract?
- The duration for this Business Intelligence Analyst Developer contract is approximately 17 months, which is about 1.4 years.
- What are the 'preferred' skills for the Business Intelligence Analyst Developer role?
- Preferred skills for the Business Intelligence Analyst Developer role include SAS programming, Jupyter Notebook experience, AWS and Azure cloud platform experience, experience modernizing legacy healthcare systems, and familiarity with Agile development methodologies. Knowledge of various healthcare reporting aspects is also a plus.
- What is the educational requirement for the Business Intelligence Analyst Developer position?
- A Bachelor's Degree in a related field such as Data Science, Computer Science, Mathematics, Statistics, Information Systems, or Healthcare Analytics is required. A Master's Degree is preferred.
- What specific data systems will the Business Intelligence Analyst Developer work with?
- The Business Intelligence Analyst Developer will primarily work with the Health Analytics Library (HAL) Medicaid reporting data mart. This involves analyzing existing HAL data systems, architecture, schemas, tables, ETL processes, and reporting environments.
- What kind of modernization efforts are involved in this Business Intelligence Analyst Developer role?
- This role involves modernizing legacy SAS-based ETL processes into SQL and Python-based solutions. It also includes supporting modernization initiatives for AWS and future Azure migration readiness for the HAL data mart.