SIRITECH SOLUTIONS CORP is seeking an experienced Business Intelligence Analyst / Developer to support the modernization of the Health Analytics Library Medicaid reporting data mart. The selected candidate will be responsible for converting legacy SAS-based ETL processes into SQL and Python-based solutions while supporting Medicaid claims analytics and healthcare data modernization initiatives.
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
Requirements:
- Total Required Experience in Years: 8+ Years
- 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, 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
- Bachelor's Degree in Data Science, Computer Science, Mathematics, Statistics, Information Systems, Healthcare Analytics, or related field
- Bachelor's Degree required
- Recent Medicaid experience
- Strong ETL background
- SQL Programming
- Python Programming
- 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
- Master's Degree preferred
- Healthcare Data Analytics certifications preferred
- SQL certifications preferred
- AWS or Azure certifications preferred