Sr Data Analyst / Lead Developer

Briljent; Springfield (IL); Remote; USD 80,000 - 110,000; Full time

Job summary

A leading company is seeking a Senior Data Analyst/Lead Developer to support Medicaid data analysis within their remote Enterprise Warehouse Team. This role emphasizes SQL development and cross-functional collaboration, requiring extensive healthcare analysis experience and exceptional communication skills to document processes and enhance operations.

Qualifications

• 7+ years of healthcare business analysis experience.
• 4+ years with State Medicaid and CHIP agencies.
• Proven ability in leading client communications.

Responsibilities

• Analyze complex SQL for data warehouse reporting.
• Document business processes and system requirements.
• Assist in user acceptance testing and resolve issues.

Skills

Healthcare analysis

SQL

Data analysis

Business documentation

User acceptance testing

Communication

Education

Bachelor's degree in related field

Tools

Informatica PowerCenter

Azure DevOps

MS Project

SharePoint

Visio

Job description

We are seeking a highly experienced Sr Data Analyst/Lead Developer to join our Enterprise Warehouse Team. This role involves analyzing and developing complex SQL for data warehouse reporting and analytics, supporting Medicaid data analysis, and collaborating with cross-functional teams to document business processes, requirements, and system updates.

• This role is fully remote but does require occasional travel to Springfield, IL.**
  
  

Key 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
  
  

Requirements

• 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
  
  

Physical Requirements & Environmental Conditions

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this position, the employee is regularly required to sit and use hands to handle, or feel objects, a keyboard and other office equipment. The employee frequently is required to sit in meetings for long periods of time. The employee will utilize technology tools such as a laptop computer for extended periods of time. The employee must be able to reach with hands and arms and talk or hear. Specific vision abilities required by this position include close vision, color vision, and the ability to adjust focus. The noise level in the work environment is usually moderate.

Briljent is a solutions-based company. Solutions come from creative ideas; ideas come from being creative with differences. Briljent believes diversity and inclusion are critical to the success of the company. Employment at Briljent is based on merit and professional qualifications. We do not discriminate against any employee or applicant because of race, creed, religion, gender, sexual orientation, gender identity/expression, national origin, disability, age, veteran status, marital status or any other basis protected by federal, state or local law, regulation or ordinance.