Sr. Data Engineer

Transcarent; United States; Remote; USD 150,000 - 165,000; Full time

Job summary

Transcarent is seeking a Data Engineer to build a single source of truth for data across teams. This remote role involves optimizing data architecture and creating data pipelines to empower various stakeholders. Ideal candidates will have advanced expertise in Python and SQL, with a strong focus on delivering results and improving health and care experiences.

Benefits

Competitive medical, dental, and vision coverage

401(k) Plan with company match

Flexible Time Off/Paid Time Off

Mental Health and Wellness benefits

Qualifications

• 5+ years of experience in a Data Engineer role.
• Experience building and optimizing big data pipelines.

Responsibilities

• Create and maintain optimal data pipeline architecture.
• Identify and implement internal process improvements.
• Work with cross-functional teams to support data needs.

Skills

Python

SQL

Data Analysis

Project Management

Education

Graduate degree in Computer Science

Tools

Snowflake

dbt

Job description

Transcarent and Accolade have come together to create the One Place for Health and Care, the leading personalized health and care experience that delivers unmatched choice, quality, and outcomes. Transcarent’s AI-powered WayFinding, comprehensive Care Experiences – Cancer Care, Surgery Care, Weight – and Pharmacy Benefits offerings combined with Accolade’s health advocacy, expert medical opinion, and primary care, allows us to meet people wherever they are on their health and care journey. Together, more than 20 million people have access to the combined company’s offerings. Employers, health plans, and leading point solutions rely on us to provide trusted information, increase access, and deliver care.

We are looking for teammates to join us in building our company, culture, and Member experience who:

• Put people first, and make decisions with the Member’s best interests in mind
• Are active learners, constantly looking to improve and grow
• Are driven by our mission to measurably improve health and care each day
• Bring the energy needed to transform health and care, and move and adapt rapidly
• Are laser focused on delivering results for Members, and proactively problem solving to get there

About this role

We are looking for data engineers excited to create a single source of truth that will power the decisions for the company for other developers, products, clinical teams, data analysts, data scientists, member experience, and more. They will need to be able to ingest various sorts of application and health data, leverage our Snowflake data warehouse to load it, and transform the data into various data sets to offer it self-serve in a secure, compliant manner. They must be self-directed and comfortable supporting the data needs of multiple teams, systems, and products. The right candidate will be excited by the prospect of optimizing or even re-designing our company’s data architecture to support our next generation of products and data initiatives.

What you’ll do

• Be a data champion and seek to empower others to leverage the data to its full potential.
• Create and maintain optimal data pipeline architecture with high observability and robust operational characteristics.
• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Build the infrastructure required for optimal data extraction, transformation, and loading using SQL, python, and dbt from various sources.
• Work with stakeholders, including the Executive, Product, Clinical, Data, and Design teams, to assist with data-related technical issues and support their data infrastructure needs.
• Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.

What we’re looking for

• You are entrepreneurial and mission-driven and can present your ideas with clarity and confidence.
• You are a high-agency person. You refuse to accept undue constraints and the status quo and will not rest until you figure things out.
• Advanced expertise in python and dbt for data pipelines
• Advanced working SQL knowledge and experience working with relational databases.
• Experience building and optimizing big data pipelines, architectures, and data sets. A definite plus with healthcare experience
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Strong analytic skills related to working with unstructured datasets.
• Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
• A successful history of manipulating, processing, and extracting value from large disconnected datasets.
• Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores
• Strong project management and organizational skills
• Experience supporting and working with cross-functional teams in a dynamic environment
• We are looking for a candidate with 5+ years of experience in a Data Engineer role, who has attained a Graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field
• Good to have healthcare domain experience.

The following is a list of software/tools that would be nice to have but not required:

• Experience with cloud-based data warehouse: Snowflake
• Experience with relational SQL and NoSQL databases
• Experience with object-oriented/object function scripting languages: Golang, Python, Java, C++, Scala, etc.
• Experience with big data tools: Spark, Kafka, etc.
• Experience with data pipeline and workflow management tools like Airflow
• Experience with AWS cloud services: EC2, EMR, RDS, Redshift
• Experience with stream-processing systems: Storm, Spark-Streaming, etc.

As a remote position, the salary range for this role is:

$150,000 - $165,000 USD

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:

• Competitive medical, dental, and vision coverage
• Competitive 401(k) Plan with a generous company match
• Flexible Time Off/Paid Time Off, 12 paid holidays
• Protection Plans including Life Insurance, Disability Insurance, and Supplemental Insurance
• Mental Health and Wellness benefits

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.

Apply for this job

*

indicates a required field

First Name *

Last Name *

Email *

Phone *

Resume/CV *

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Education

School Select...

Degree Select...

Select...

End date year

LinkedIn Profile

Website

Home Address *

Are you currently authorized to work in the country outlined for this job? * Select...

Will you now or in the future require sponsorship for employment visa status? (e.g. H-1B visa status?) * Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey.Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

As set forth in Transcarent’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305

Page 1 of 1

OMB Control Number 1250-0005

Expires 04/30/2026

Voluntary Self-Identification of Disability

Form CC-305 Page 1 of 1 OMB Control Number 1250-0005 Expires 04/30/2026
Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp .

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

• Alcohol or other substance use disorder (not currently using drugs illegally)
• Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
• Blind or low vision
• Cancer (past or present)
• Cardiovascular or heart disease
• Celiac disease
• Cerebral palsy
• Deaf or serious difficulty hearing
• Diabetes
• Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
• Epilepsy or other seizure disorder
• Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
• Intellectual or developmental disability
• Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
• Missing limbs or partially missing limbs
• Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
• Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
• Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
• Partial or complete paralysis (any cause)
• Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
• Short stature (dwarfism)
• Traumatic brain injury

Disability Status Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.