Systems Analyst II

IPS Technology Services; Southfield (MI); On-site; USD 80,000 - 100,000; Full time

Job summary

IPS Technology Services in Southfield, MI is seeking a PS-Systems Analyst II for a 1+ year contract. The role involves supporting health plan quality measures and developing IT solutions to enhance business efficiency.

Applicants should have extensive experience in data analysis, particularly in healthcare, alongside strong SQL skills and proficiency in relational databases. A Bachelor’s degree in a relevant field is required.

Qualifications

• 6+ years of data analysis experience with health plan quality improvement.
• 5+ years of experience with relational databases.
• 3+ years of experience in healthcare domains.

Responsibilities

• Support Health Plan Business by enhancing HEDIS quality measures.
• Develop technical solutions that improve business efficiency.
• Analyze and translate business requirements into systems.

Skills

Data analysis experience with health plan quality improvement

Experience with relational databases (SQL Server, Oracle, Access)

Experience in healthcare domains (Member, Provider, Claims, LAB & EMR)

Education

Bachelor’s degree in related field

Master’s degree preferred

Tools

SQL Server

Oracle PLSQL

Tableau

Job description

IPS Technology Services adds value to customers’ businesses by cultivating partnership and delivering quality services to meet or exceed customer expectations. Our FOCUS is on understanding customer requirements, teamwork, and communication. Our GOAL is a repeat customer.

Job Description

Job Title: PS-Systems Analyst II
Location: Southfield, MI
1+ year contract

Engagement Description

• Health Plan Business Quality Data Improvement, support Health Plan Business by enhancing HEDIS quality measures
• Responsible for planning, developing, testing and implementing IT system solutions that improve business efficiency and productivity as well as support business strategies and goals
• Identify and communicate business needs and translate business requirements into technical system and functional specifications
• Analyze business requirements, propose, design and implement technical solutions
• Support one or more moderately to highly complex business processes/systems for multiple business units
• Project team member for projects medium to large in scope and high complexity
• Responsible for analysis, design of data architecture and ETL data flows in support of enterprise HEDIS data management, analytics and reporting
• Collaborate proactively with functional analysts to translate business and application requirements into configurable component designs and solutions
• Design, program and unit test application software across production support, enhancements and projects
• Design and develop technical solutions for business requirements, design and develop scalable components including packages, stored procedures, extensions, views and customizations independently or as part of a team
• Integration of vendor data feeds

Top 3 Required Skills/Experience

• 6+ years of data analysis experience with health plan quality improvement, managed care organization
• 5+ years of experience with relational databases (SQL Server, Oracle, Access, etc.)
• 3+ years of experience in healthcare domains – Member, Provider, Claims, LAB & EMR

Required Skills/Experience

• Experience writing complex queries, using advanced PLSQL concepts and performance tuning
• Excellent understanding of Entity Relationship Diagrams (ERDs) and the translation of business requirements into them
• Strong analytical skills with the ability to collect, organize, analyze, and communicate insights
• 5+ years of complex SQL script writing experience
• 3+ years of experience with HEDIS and CMS Stars Rating System & Specifications
• 5+ years of experience with data profiling & analyzing large datasets
• Excellent design and technical skills with Oracle PLSQL and SQL Server Development (including stored procedures, packages, functions, triggers)
• Experience working with large data sets and data visualization tools

Preferred Skills/Experience

• 3+ years working with analytical software such as SAS or Tableau
• Experience working with Medical Code sets – CPT, HCPCS, ICD10

Education/Certifications – Include

• Bachelor’s degree required in a related field such as Computer Science, Information Systems, Business, Mathematics, Healthcare Information Technology or similar degree required
• Master’s degree preferred

Additional Information

All your information will be kept confidential according to EEO guidelines.