Data Analyst (TMSIS)

Responsible for performing research and requirement analysis, creation and design of mapping documents, and presenting findings to appropriate team members, clients and vendors. Determines best practices and provides suggestions on how to improve current practices., The candidate is expected to be able to understand data and decode errors. Should be able to understand specifications and mapping documents, perform analysis on data to transformation requirements, work with ETL/Reporting/Conversion staff to ensure code has been developed that meets the business requirements documented, test the interface/report to ensure requirements are met, and work with other team members.

Duties and Responsibilities (essential duties and responsibilities in order of importance): o Creates accurate mapping documents according to the mapping process.

• Works toward delivering a first draft solution to ETL/Reporting/Conversion for coding, by rapidly understanding which details about the mapping can be deferred. oPresents analysis and design recommendations to lead MITA teams, customer and/or vendors into the acceptance of the design.
• Supports the ETL developers based on the mappings created. oWorks closely with configuration team and DBAs to ensure synchronicity of configuration to interfaces and mappings.
• Refines mapping documents, adding more detail and filling out deferred material as questions are resolved. oUses SQL, data models, data element dictionary and schema to perform data and business analysis.
• Creates unit test cases for area of responsibility. oValidates test plan results that satisfy the detailed design goals.
• Updates technical specifications and mappings.
• Supports Unit Testing, System Integration Testing, System Testing, and User Acceptance Testing., Employees first. Customer always. Mission driven. Everyone matters. Join the vibrant team at ESI where we prioritize our employees’ well-being and champion customer satisfaction above all else. Our culture is defined by a mission-driven approach, ensuring that every member contributes to our collective success. At ESI, we value the unique perspectives each individual brings to the table. Through collaboration and innovation, we’re reshaping the digital landscape of public sector services. If you’re passionate about making a difference, eager to grow professionally, and thrive in a supportive environment, join us in our journey to create impactful solutions and drive positive change.

Do you have experience in SQL?, 1) Healthcare/business knowledge in one or more of the following areas: member, eligibility, TPL, claims processing, provider, pharmacy claims. TMSIS knowledge is highly preferred and will be given first preference.

2) Must analyze and figure out data issues independently by comparing with existing data and ETL models.

3) Good/Excellent SQL skills mandatory.

4) Good Oral/Written communication skills.

5) Must be eager and ambitious. Ability to quickly grasp new concepts, procedures, and technologies. To be successful, candidate will be required to quickly learn the Preferred Skills below and then work independently to fulfill job requirements., 1) TMSIS working knowledge

2) Data Mapping experience

3) Data Analysis experience, * Analytical and data analysis skills within a technical environment preferably SQL.

• Healthcare knowledge within a claims processing environment preferably in Medicaid.