Senior Data Engineer

Trella Health•Nashville, TN

4h•Remote

About The Position

The Senior Data Engineer will own the design, build, and maintenance of the data pipelines that power Trella Health’s applications. This person turns big data concepts into effective data models that are efficient and scalable. They’ll also help ensure data releases and deployments run smoothly from development through production. We’re looking for someone who’s organized, proactive, and not afraid to roll up their sleeves to solve problems. You should be comfortable documenting processes, managing your time well, and constantly looking for ways to improve and optimize data flows. Location: This role is remote with a strong preference for candidates within commuting distance of Atlanta, GA; Philadelphia, PA; or Nashville, TN. We will also consider applicants based in other U.S. locations.

Requirements

Bachelor’s degree in Computer Science, Engineering, Mathematics, or other technical discipline (proven professional experience will be considered in lieu of a technical degree).
2+ years of recent advanced Snowflake development experience.
Experience manipulating healthcare data In-depth knowledge of Amazon Web Services (AWS) and Platform as a Service (PAAS).
Demonstrable experience with Snowflake utilities including SnowSQL & Snowflake Javascript.
Ability to analyze all aspects of the Snowflake Query Engine to improve bottlenecks that may exist.
Ability to automate data ingestion from Amazon S3, FTP, and other technologies.
Experience with scripting languages. Extensive Python experience.
Working knowledge of Bitbucket and Git.
Experience managing and loading data in AWS RDS (MySQL/MariaDb).
Ability to optimize MySQL query execution plans for robust performance.
Strong analytical skills and ability to rapidly switch contexts.
Excellent communication and problem-solving skills.
Passion to uncover and improve processes that are inefficient or sub-optimal.
Track record of implementing creative solutions to complex problems.
Experience working in a nimble, fast-paced, growth start-up environment.

Nice To Haves

Experience manipulating healthcare data including claims, ADT data.
Foundational knowledge of CI/CD platforms, preferably TeamCity.
Development and consumption of API services.
Experience with data science tools (Jupyter, SageMaker, R).
Node.js experience.
Understanding of Atlassian suite of tools, including Jira and Confluence.
Knowledge of HIPPA, PHI, PII policies.

Responsibilities

Champion a comprehensive data vision and operating principles that improve data quality, consistency, accessibility, decision making, use, and stewardship.
Manage data pipeline by developing processes for data input, transformation, and storage.
Act as an interface between the Data Science team and Application Developers.
Architect and implement front-end (application layer) and back-end (ETL layer) database technologies in a highly customized data environment.
Develop automated processes for moving data between systems.
Implement ETL processes that transform source data into functional data stores consumed by front-end applications .
Scale data pipeline by utilizing the most efficient tools and technologies.