Technical Business Data Analyst (Remote)

The Business/Data Analyst will perform business and data analysis tasks daily. Functions will include analysis, planning, assisting in managing project deliverables, updating the project plan using Microsoft Project, coordinating between the technical team and the business users. This role will support analysis of two different data structures to support conversion and new data model development of a large-scale data warehouse using complex SQL. This includes providing direction for the solution, ensuring data quality, and support of the design, development, and implementation (DDI) of the project.

Primary Responsibilities:

Perform complex analysis primarily in SQL to support operational and development needs

Analysis of Medicaid enrollment, eligibility, provider, claims, and other related data to support business requests, requirements, and design, development, and implementation.

Analytics of current business processes and systems, identify requirements for new processes and systems, identifying and documenting data anomalies and collaborate with cross functional teams for effective resolution.

Collaborate with internal teams, customer, and business partners on business documentation and updates.

Facilitate meetings with user groups and document meeting minutes, action items, and decisions.

Support the DDI Project Manager, as needed, including maintaining the Microsoft Project Plan/Schedule for DDI project.

Develop/deliver professional presentations using Microsoft PowerPoint.

Assist with data quality testing and follow up with business, ETL, BI, and QA teams.

Share use cases to data/quality analysts for data profiling; review test results and infer compliance to project requirements, and applicable Medicaid/CMS processes and guidelines

Ability to effectively manage multiple priorities and ensure availability to questions and clarifications from project members.

Support business requirements documentation and serve as a liaison between business team and technical teams in technical specifications.

Support training end users such as using the to-be system and cross-referencing to the as-is system with the data and related processes as primary focus

Perform peer reviews of the project artifacts/documents to identify quality issues

Interpret, analyze, and provide recommendations regarding data accuracy and data collection needs and processes

Integrate insights into processes, measure results and drive action to help champion data driven culture

Ability to make decisions and problem solve in ambiguous situations

Possess positive-attitude and willingness to jump in and help and share knowledge with colleagues where needed

Other duties as assigned

Required Qualifications:

Bachelor’s degree or higher degree in business intelligence, analytics, computer science, engineering, or related field.

5+ years of healthcare business and data analysis experience supporting business initiatives through data analysis, writing business requirements and supporting testing of various systems.

5+ years developing/writing complex queries using Structured Query Language (SQL).

3+ years of experience in working with State Medicaid/CHIP agencies or equivalent.

Good understanding of Fee for Service (FFS), Managed Care claim adjudication processes from eligibility and enrollment to claims processing to funding/finance.

Experience working on a Medicaid Enterprise System (MES)/MMIS, or EDW DDI or equivalent.

Proficient in MS Word, MS Excel, MS Project, SharePoint, Teams, and MS PowerPoint.

Be a self-starter and able to thrive in an environment with little guidance.

Excellent interpersonal, oral, and written communication skills.

o Ability to effectively communicate findings clearly and concisely in writing and verbally to both technical and non-technical audiences

Ability to work in a challenging environment with multiple teams and competing priorities

Experience with facilitating meetings.

Effective organizational, analytical, time management, problem-solving, and multi-tasking skills

Ability to complete assignments under tight deadlines with little/no direct supervision.

Preferred Qualifications:

Experience working with Data warehousing, Analytics, MMIS/MES, PERM, T-MSIS, CMS Federal Reporting or similar projects

Understanding of CMS reporting requirements for Medicaid.

Knowledge of health insurance, Health Management Organizations (HMO) and managed care principles including Medicaid and Medicare.

Experience with Teradata and SQL Assistant/Query Studio

Experience/knowledgeable in Extract Transform Load (ETL) processes

Experience/knowledgeable in Reporting processes

Experience/knowledgeable in Databases (such as Teradata, Snowflake, or other similar Database Management System)

Knowledge of quality measures (such as CMS Core Set, HEDIS)

Knowledge of data integration, software enhancements/development/planning

Knowledge/experience with agile methodologies and projects

Experience with using Azure DevOps, JIRA, and Visio