Data Integration Engineer II

Job Description

You will be in a Agile Sprint team working with BSAs and Engineers to deliver Data Integration projects. As a member of this agile team, you’ll be doing story grooming, planning, daily stand-up, deployment review, sprint demo, retrospective, and other supporting technical discussions.

• Create test cases, develop test scripts, plan and execute test cases to ensure comprehensive code coverage, and stay on top of all important issues, help triage bugs and drive issues to resolution, keeping everyone aware of QA status
• Investigate failures, perform root cause analysis and utilize internal defect tracking tool to create detailed, high quality error reports. Verify that fixes for defects and new features work as expected and do not cause regressions in affected areas. Analyze bug trends/patterns and customer feedback to drive for better customer experiences
• Assess the status of the release from an automation execution perspective, and help make sure that the release goes out on time with high quality level
• You will be largely working on new customer implementation projects to bring in external data sets and integrate with Accolade systems to support our business operation. All the required work will be sliced into epics, stories and tasks into our backlogs. You will work with the rest of the team to groom, plan and commit to stories for sprint (2 weeks) deliveries.
• You will also be involved in trouble shooting, root cause analysis of issues from the existing operation processes, as well as answer data questions from business users. These activities are in general not projects based, but are considered in the sprint planning.
• Outside day to day sprint work, we provide opportunities for new technology and cross functional trainings, and encourage people to work on innovation projects.
• Your are expected to utilize critical thinking and analytic skills to define requirements and interface definitions for new and existing interfaces, the work will include analyze data files, data layouts and data dictionaries from providers of health care administrative data (eligibility, account/plan, medical claims, pharmacy claims) to understand data structure and operating rules for transforming to common data format, and create source to target mappings.
• You will be working with ETL engineers interactively to review the mappings and all other specs of the requirements to ensure they are implemented correctly, and you will also develop and execute test cases to ensure source data has been accurately mapped, transformed and loaded
• Become the subject matter expert for the specific insurance claims data and/or consumer enrollment data that you have worked on, which will include all transformation logics and processing details of the entire data ingestion.
• You will be able to coordinate and facilitate consistency of the data model across multiple initiatives and leverage the Accolade standards for all existing and future customers
• Gain knowledge of Big Data, open source software solutions, Amazon Web Service and other cloud based platforms and technologies for data processing

Qualifications

• Bachelor’s degree in Information Management, Computer Science/Engineering, Mathematics, Business, or other related fields
• 2+ years of hands on experience with data centric testing methodology and working in database environment, preferably working with healthcare claims and enrollment data, and exposure to Talend or other ETL tools is a plus. Familiarity and background in using automated and static test tools. (Microsoft Test Manager, Jira, etc.)
• Strong SQL skills to support data analysis and test scripting to validate data, knowledge of multi-dimensional models, including experience testing slowly changing dimensions (SCD) and change data capture (CDC) procedures.
• Experience on an Agile development team working in a continuous integration development model. Ability to work collaboratively within a team environment of engineers to meet aggressive goals and high quality standards.
• Ability to analyze data and process flows, able to collaborate development of business requirements and functional specifications to align data processes with business goals
• Possess a strong background in data warehousing principles, architecture and its implementation in large environments.

Additional Information

Creating an enduring company that is hyper-focused on our culture and making a meaningful impact in the lives of our employees, members and customers. The secret to our success is:

Making a difference in our members’ and customers’ lives is what we do. Even when it’s hard, we do the right thing for the right reasons.

Trusting in our colleagues and embracing their different backgrounds and experiences enable us to solve tough problems in creative ways, having fun along the way.

Results motivate us. And we aren't afraid of the hard work or tough decisions needed to get us there.

We're curious and act big not afraid to knock down barriers or take calculated risks to change the world, one person at a time.

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