Data Engineer

About the role:

As a Data Engineer, you will play a critical role in our database upgrade roadmap, in support of our work for a large federal healthcare program. The Data Engineer will work with complex and nuanced data pipelines and will be responsible for the continuous development, review, and documentation of data wrangling and pipeline solutions. You should have experience working in a rapid development team in the past in which you were responsible for significant contributions to client data pipeline solutions.

In this position you will:

1. Develop, test, and operationalize the data pipelines that power our analytics.
2. Provide visibility into data transformations by designing and implementing data tests throughout existing pipelines.
3. Extract business logic (ETL/ELT, metrics, metadata) from current data systems into portable cloud-agnostic layers.
4. Analyze, build, and deploy data models, including relational models for data warehousing.
5. Plan and maintain data architectures that are aligned with business requirements.
6. Produce scalable, replicable code and engineering solutions that help automate repetitive data management tasks.
7. Work closely with data analysts to understand, identify and effectively respond to their specific needs.
8. Partner with other engineers to deploy and troubleshoot pipeline-related tools, automations, and integrations.
9. Work as part of a team to maintain a well documented, consistent codebase.
10. Support our analysts with support requests accessing data in our snowflake cluster.

What we are seeking:

1. 3+ years of experience as a contributor to technical projects, such as working with complex data pipelines or software applications.
2. Experience working with production grade data warehouses using SQL queries and scripting languages (e.g., Python).
3. Experience with SQL transformation tools like dbt.
4. Strong background in database design and data modeling.
5. Experience with Snowflake, implementing a modern data stack, and contributing to large scale data migration efforts.
6. Effective communication skills when working with team members of varied backgrounds, roles, and functions.
7. Ability to manage your individual priorities and comfortably context-switch between active development, client discussion, and issue response.
8. Experience delivering on client priorities that operate on a regular deployment schedule.
9. Passion in applying your skills to our social mission to problem-solve and collaborate within a cross-functional, client-facing team environment.
10. The ability to successfully attain and maintain a Federal Public Trust background investigation that our government clients require; this includes a requirement that the individual has U.S. Citizenship or U.S. residency for three of the past five years.
11. Ability to hold a Public Trust certification (including residency requirement of 3+ Years in the USA)