Senior Data Engineer

Job Title: Senior Data Engineer 

Department: Product Development  

About the Role: Join our dynamic team of talented engineers with a proven track record in constructing data warehouses, lakes, and pipelines. We are on a mission to fuel Unite Us' ongoing expansion and enhance its positive influence on both the healthcare industry and individuals nationwide. As part of our team, your role will be instrumental in collecting, processing, and delivering data to both internal and external stakeholders. This pivotal work empowers us to intelligently invest in emerging opportunities, quantifying the value and ROI that Unite Us networks bring to our customers. By leveraging your expertise, you will help establish Unite Us as a thought leader in the dynamic social care landscape. Become an integral part of our team and help us in shaping the future of healthcare and making a meaningful impact on the lives of people across the country.

What You'll Do:

• Implement a data architecture and infrastructure that aligns with business objectives. Collaborate closely with Application Engineers and Product Managers to ensure that the technical infrastructure robustly supports client requirements
• Create ETL and data pipeline solutions for efficient loading of data into the warehouse along with their testing to ensure reliability and optimal performance
• Collect, validate, and provide high-quality data, ensuring data integrity
• Champion data democratization efforts, facilitating accessibility to data for relevant stakeholders
• Guide the team with regard to technical best practices and contribute substantially to the architecture of our systems
• Supporting operational work like onboarding new customers to our data products and participating in on-call for the team 
• Engage with cross-functional teams, including Solutions Delivery, Business Intelligence, Predictive Analytics, and Enterprise Services, to address and support any data-related technical issues or requirements

You’re a great fit for this role if:

• At least 6-8 years of experience in working with data warehouses, data lakes, and ETL pipelines
• Proven experience with building optimized data pipelines using Snowflake 
• Expert in orchestrating data pipelines using Apache Airflow, including authoring, scheduling, and monitoring workflows
• Experience designing ETL/ELT data pipelines using data transformation tools like DBT
• Advanced SQL knowledge, with experience in pulling complex queries, query authoring, and strong familiarity with Snowflake or various relational databases like Redshift, Postgres, etc.
• Strong proficiency in Python for building, optimizing and maintaining data pipelines and services. 
• Experience with CI/CD pipelines to automate testing, deployment and release of data engineering and analytics workflows using tools such as GitHub Actions, Jenkins etc.
• Exposure to AWS and proficiency in cloud services such as ECS, S3, RDS, etc.
• Experience with tools like Kubernetes, Terraform, Docker, Kafka
• Experience in developing applications for large enterprise clients.
• Previous engagement with healthcare and/or social determinants of health data products.
• Experience designing, building and maintaining data pipelines for healthcare claims and clinical data, ensuring data quality, scalability and compliance. 
• A dedicated focus on building high-performance systems
• Exposure to building data quality frameworks
• Experience using and building solutions to support various reporting and data user tools (Tableau, ThoughtSpot, etc)
• Strong problem-solving and troubleshooting skills, with the ability to identify and resolve data engineering issues and system failures
• Excellent communication skills, with the ability to communicate technical information to non-technical stakeholders and collaborate effectively with cross-functional teams
• The ability to envision and construct scalable solutions that meet diverse needs for enterprise clients with dedicated data teams

Our Mission:

Unite Us’ mission is to unlock the potential of every community. Our co-founders started Unite Us in 2013 to serve the people they served with. They witnessed firsthand the barriers and inefficiencies in trying to navigate health and social services, and set out to improve that experience for veterans and their families. Unite Us quickly expanded to serving all people who need connections to care across our country. Through Unite Us’ national network and software, community-based organizations, government agencies, and healthcare organizations are all connected to better collaborate to meet the needs of the individuals in their communities. We drive the collaboration to predict, deliver, and pay for services that impact whole-person health. If you want to do well and do good, join Unite Us.

Environmental Job Requirements and Working Conditions:

• This position is remote, U.S. based.
• The target pay range for this role is: $145,000-$175,000. This salary range represents our target hiring range for this role. The proposed salary will be dependent on the candidate's skills, experience, and competencies, as well as location.
• All team members will be required to pass a background check which includes criminal, employment, and education verification 

Benefits provided by Unite Us:

Medical, Dental, and Vision

We offer insurance to team members and eligible partners and dependents, including unlimited virtual mental health and acute medical visits.

Wellness

Mental health benefits, such as the Employee Assistance Program (EAP) and wellness platform subscription, are available to all team members.

Flexible Time Off

Take what you need, including volunteer days and mental health days. We also offer 14 paid, company-wide holidays.
Paid Parental Leave

Adoptive parents are included.

Employee Resource Groups

Join our ERGs to connect and engage with colleagues, like Military Veterans

Spending Accounts

We offer tax-advantaged health savings accounts (HSAs), flexible spending accounts (FSAs), and commuter benefits.

401(k) + Employer Match

Enjoy matching, immediate vesting and financial wellness resources

Additional Benefits

Life and AD&D - a company paid benefit, with the option to purchase additional coverage for yourself and your dependents

Disability Coverage

Accident Insurance

Pet Insurance

As part of this work at home job, we will provide you with all the necessary equipment to perform your duties, including a computer, mouse, keyboard as well as other items on our approved list of WFH supplies.

Unite Us is committed to building a diverse team and fostering an inclusive culture, and is proud to be an equal opportunity employer. We embrace and encourage our employees' differences in race, religion, color, national origin, gender, family status, sexual orientation, gender identity, gender expression, age, veteran status, disability, pregnancy, medical conditions, and other characteristics. If you require assistance in applying for open positions due to a disability please email us at [email protected] to request an accommodation.

#LI-Remote