Data Integration Engineer II

About Accolade
Accolade (Nasdaq: ACCD) provides millions of people and their families with an exceptional healthcare experience that is personal, data driven and value based to help every person live their healthiest life. Accolade solutions combine virtual primary care, mental health support and expert medical opinion services with intelligent technology and best-in-class care navigation. Accolade’s Personalized Healthcare approach puts humanity back in healthcare by building relationships that connect people and their families to the right care at the right time to improve outcomes, lower costs and deliver consumer satisfaction. Accolade consistently receives consumer satisfaction ratings over 90%. For more information, visit accolade.com.

This is a hybrid role working from our Plymouth Meeting, PA office. On site expectations are 2-3 days per week.

The pay range for this position is $80,000- $85,000. This range is annualized, assuming normal full-time employment.

We are unable to provide H1B sponsorship at this time.

Role overview

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.

A day in the life…

• Work with partners and stakeholders to determine requirements for the ingestion or extraction of data sets in support of Accolade’s services.

• You will be largely working on new customer implementation projects to build data integrations 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.

• Build, test and deploy data pipelines to deliver high quality data integrations to meet business requirements.

• Investigate data quality issues reported by partners, perform root cause analysis and work with partners and stakeholders to resolve issues.

• Work internally with partner teams to trouble shoot platform issues that may impact ingestion or extraction of data. Determine root cause of issues and work on continuous improvement activities to improve data quality and consistency.

• Work with partners and stakeholders to answer data questions and support Issue Management activies to resolve data quality issues.

• 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.

• Become the subject matter expert for Accolade’s platform and data

• 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

What we are looking for…

• 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.

The salary range for this role is:

Annually

Total Rewards
Individual compensation packages are based on a few different factors unique to each candidate, including primary work location and an evaluation of a candidate’s skills, experience, market demands, and internal equity. Salary is just one component of Transcarent's total package. All regular employees are also eligible for the corporate bonus program or a sales incentive (target included in OTE) as well as stock options.

Our benefits and perks programs include, but are not limited to:

• Comprehensive medical, dental, vision, life, and disability benefits, including access to Accolade Advocacy, Accolade Care, and Accolade EMO.

• HDHP medical plan with generous employer contributions towards an HSA

• 401(k) Retirement Plan with matching employer contributions

• Open Time Off

• Accrued Sick & Safe Time Off

• Generous Holiday Schedule + 5 floating holidays

• Paid parental leave

• Subsidized commuter benefits programs

• Virtual access to coaching, self-care activities, and video-based therapy and psychiatry through Headspace

• 1 Volunteer day per year

Location
You must be authorized to work in the United States. Depending on the position we may have a preference to a specific location, but are generally open to remote work anywhere in the US.

Transcarent is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. If you are a person with a disability and require assistance during the application process, please don’t hesitate to reach out!Research shows that candidates from underrepresented backgrounds often don’t apply unless they meet 100% of the job criteria. While we have worked to consolidate the minimum qualifications for each role, we aren’t looking for someone who checks each box on a page; we’re looking for active learners and people who care about disrupting the current health and care with their unique experiences.