Advisor Application Architect

This is a fully remote position, open to applicants in United States.

📋 Description

• Oversee a small group of data analysts or work in collaboration with other analysts.

• Create program specifications and mapping documents.

• Analyze data to identify transformation needs.

• Collaborate with ETL/Reporting/Conversion staff to ensure that code adheres to documented business requirements.

• Test interfaces and reports to confirm that requirements are satisfied.

• Identify best practices and recommend enhancements to existing processes.

• Partner with the development lead to assign and complete project tasks on time.

• Coordinate project work assignments with the development lead.

• Fulfill documentation requirements in collaboration with project management.

• Generate precise mapping documents as per the mapping process.

• Provide solutions to ETL/Reporting/Conversion teams for coding purposes.

• Assist in DSD creation and response.

• Present analysis and design suggestions to MITA teams, customers, and vendors.

• Support ETL/Reporting/Conversion developers based on the mappings created.

• Work in conjunction with configuration teams and DBAs to ensure configuration aligns with interfaces and mappings.

• Refine mapping documents as queries are resolved.

• Utilize SQL, data models, data element dictionaries, and schemas for data and business analysis.

• Develop unit test cases.

• Validate test plan outcomes against detailed design objectives.

• Update technical specifications and mappings as needed.

• Assist with Unit Testing, System Integration Testing, System Testing, and User Acceptance Testing.

⛳️ Requirements

• A minimum of five years of experience in supporting pharmacy benefit, claims administration, Medicaid, Medicare, healthcare payer, or another highly regulated healthcare domain.

• At least seven years of experience utilizing SQL to analyze, validate, reconcile, transform, or troubleshoot complex relational data.

• Experience in supporting large-scale system implementation, modernization, conversion, or DDI programs.

• Proven experience in producing source-to-target mappings, interface specifications, data analysis results, and test artifacts.

• Proficiency in authoring or maintaining ICDs, companion guides, and detailed mapping workbooks.

• Experience in supporting CMS or state certification activities.

• Capability to lead a small team of data analysts or collaborate with other analysts.

• Proficiency in developing program specifications and mapping documents.

• Ability to conduct research and requirements analysis.

• Skill in presenting findings to team members, clients, and vendors.

• Competence in using SQL, data models, data element dictionaries, and schemas for data and business analysis.

• Video cameras are required to be used during all interviews and the initial week of orientation.

🏝️ Benefits

• Flexible work arrangements.

• Opportunities for learning and career development.

• Support for obtaining technical credentials and certifications.

• Generous and flexible vacation policy.

• Educational assistance programs.

• Leadership and technical development academies.

• Employer matching for 401(k).

• Comprehensive health benefits package.

• Occasional travel opportunities.