Sr. Data Analyst Lead Developer

Myticas Consulting; Springfield (IL); Remote; USD 90,000 - 120,000; Full time

Job summary

A leading consulting firm is seeking a Senior Data Analyst/Lead Developer for a remote position with occasional travel to Springfield, IL. The role includes complex SQL analysis for healthcare data, system requirements documentation, and user acceptance testing support. Ideal candidates will have over 7 years of experience in healthcare analysis and proficiency in SQL, with a bachelor's degree required. Strong communication and organizational skills are essential for success in this role.

Qualifications

• 7+ years of healthcare business analysis experience.
• Proven ability to lead communication at customer leadership level.
• 4+ years working with State Medicaid and CHIP agencies.

Responsibilities

• Analyze and develop complex SQL for data warehouse and reporting.
• Document requirements for new processes and systems.
• Assist with user acceptance testing and defect reporting.

Skills

Healthcare business analysis

SQL

Communication

Time management

Problem-solving

Organizational skills

Multi-tasking

Education

Bachelor’s degree in related field

Tools

Informatica PowerCenter

Azure DevOps

SharePoint

MS Project

Visio

Job description

Senior Data Analyst/Lead Developer

Location: Remote (occasional travel to Springfield, IL may be required)

Contract: W2– Candidates must be authorized to work in the U.S. on a W2 basis. We cannot accept candidates requiring sponsorship or those from C2C vendors.

Duration: 12 months with possible multi-year extension/s

Primary Responsibilities:

• Analyze and develop complex SQL supporting data warehouse downstream reporting and analytics
• Analysis of current business processes and systems, and documenting requirements for new processes and systems
• Work with internal team and customer on business documentation and updates
• Assist with user acceptance testing, including defect reporting and follow up. Help with development of test scenarios and acceptance criteria
• Help with developing presentations for internal team or for the customer. Solicit input from others and pull information together to create a professional presentation.
• Work with team to document updates needed for Operations Guide
• Assist with analysis of Medicaid enrollment, provider and claims data, and document requirements, use cases
• Assist with identifying and documenting data anomalies and collaborate with cross functional teams for effective resolution
• Share use cases to data analysts for profiling, review results and infer compliance to Medicaid / CMS processes and guidelines
• Ability to juggle multiple priorities and ensure availability to questions and clarifications from data analysts
• Positive attitude and willingness to jump in and help where needed

Required Qualifications:

• 7+ years of healthcare business analysis experience supporting business initiatives through data analysis, writing business requirements and user acceptance testing of various systems
• 4+ years of experience working with State Medicaid and CHIP agencies including federal reporting (CMS 64/21, TMSIS, PERM)
• 5+ years of experience in writing SQL
• Proven ability to lead communication (written and verbal) at the customer leadership level • Knowledge of health insurance, HMO and managed care principles including Medicaid and Medicare regulation
• Effective organizational, analytical, time management, problem-solving, and multi-tasking skills, and habits; ability to complete assignments under tight deadlines with little/no direct supervision
• Bachelor’s degree in related field

Preferred Qualifications:

• 5+ Years of experience in Informatica PowerCenter creating extracts
• Knowledge of data integration, software enhancements/planning and agile methodologies
• Experience with using Azure DevOps, SharePoint, MS Project, Visio