Trella Health is hiring a Senior Data Engineer to design, build, and maintain the data pipelines that power our applications. In this role, you will translate big data concepts into effective, scalable data models and ensure seamless data releases from development through production, empowering meaningful change in healthcare.
What You'll Do
- Champion a comprehensive data vision and operating principles to improve quality, consistency, accessibility, and stewardship.
- Manage the data pipeline by developing processes for data input, transformation, and storage.
- Serve as the 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 the data pipeline by utilizing the most efficient tools and technologies.
What We're Looking For
- Bachelor’s degree in Computer Science, Engineering, Mathematics, or a related technical discipline (proven professional experience will be considered in lieu of a degree).
- 2+ years of recent advanced Snowflake development experience.
- 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 performance bottlenecks.
- Ability to automate data ingestion from Amazon S3, FTP, and other technologies.
- Experience with scripting languages, with 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 inefficient or sub-optimal processes.
- Track record of implementing creative solutions to complex problems.
- Experience working in a nimble, fast-paced, growth start-up environment.
Nice to Have
- Experience manipulating healthcare data including claims and 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 HIPAA, PHI, and PII policies.
Technical Stack
- Snowflake, AWS, Python, Bitbucket, Git, AWS RDS (MySQL/MariaDb), Amazon S3, FTP, SnowSQL, Snowflake Javascript, TeamCity, Jupyter, SageMaker, R, Node.js, Jira, Confluence
Team & Environment
You will report to the Manager, Data Engineering and join a collaborative culture anchored by trust, transparency, and inclusion.
Benefits & Compensation
- Health, Dental, Vision & Voluntary Benefits
- Competitive Salary & Bonus Plans
- 401k Retirement Savings
- Flexible PTO & 10 Paid Holidays
- Flexible Work Hours
- Equity Shares
- Paid Leave Programs
- Marketplace for discounted retail and entertainment
Work Mode
This is a hybrid position. Locations include Atlanta, GA, Philadelphia, PA, Nashville, TN, and other U.S. locations.
Trella Health is an equal opportunity employer. All persons will receive consideration for employment without regard to race, color, gender, sexual orientation, gender identity or expression, religion, national origin, marital status, age, disability, handicap, veteran status, genetic information, or any other protected status as recognized by federal, state, or local laws.
