Live Chat

Senior Data Engineer Job in Grove City, Ohio US

Senior Data Engineer

Appriss Inc. - Grove City, OH

Posted: 10/12/2021 - Expires: 1/10/2022

Job ID: 232784360


Job Description

We are inspired by solving big problems. We are all about progress; we set out to do something and we do it. - Rob Cohen President, Bamboo Health

Bamboo Health is a leader in cloud-based care coordination software and analytics solutions focused on behavioral health, substance use disorders, patients with complex needs, and senior care. We deliver on a mission of enabling better care for patients across the physical and behavioral health continuum. Our software solutions help healthcare professionals collaborate on shared patients across the spectrum of care.


This position (Senior Data Engineer) is on the Bamboo Health Engineering Team. You would be working specifically within Data Warehousing and reporting areas. You will be fully hands-on with PostgreSQL, Redshift, Kubernetes, and other AWS technologies. You will be working within a team that builds, designs, and supports cloud based ETL, containerized solutions and data warehouses that enable data reporting, analytics and data science. Our Data Engineering team is continuously looking for opportunities to automate, apply new AWS products and features, while striving for continuous technological modernization. You will partner with other Engineering team members, Architects, Data Scientists, Analysts, and other Bamboo Health professionals.

The team is distributed with an office location in Louisville, KY. We are remote-work friendly. This position requires a United States based location of work.

About you:

You are passionate about data.As demand for data insights grows, your abilities in ETL, Data Modeling, and Python development fulfill demand. This may involve building new technical skillsets, sharing skills in areas of strength, and performing research to complete organizational objectives. As a Data Engineer you will need to execute on strategic Data Engineering key imperatives (Hoshin/Operational Key Results), and work with other Engineering teams on best practices.

You develop reusable solutions. The ETL solutions you write can be used across a team to solve similar solutions. Understanding organizational needs drive your design instincts and you ask if a solution exists prior to 'reinventing the wheel'. You advocate using your solutions and embrace updates and modifications to fit project requirements.

You have Software and Data expertise.Strong database knowledge with proven experience in writing SQL scripts that optimize database performance. You have scripting language expertise, preferably in Python, with ability to incorporate API's and SDK's to overcome unique business challenges. An understanding of containerized solution development, preferably with Docker and Kubernetes. A willingness and ability to be AWS cost conscious and identify opportunities to lower costs while achieving Key Results and maintaining a high Say-Do sprint metric.

What You'll Do:

Design, develop, debug and support ETL processes utilizing AWS services
Partner in ideation and development of data models used for data science and analytics
Meet the delivery expectations of the Agile Project Management methodology (1-week Data Engineering Sprint cycles)
Maintain reports and extracts that serve as life saving information sources to customers
Write clear and concise documentation regarding technical solutions, while sharing knowledge and documentation with teammates via "Lunch and Learns"
Work with internal and external customers to prove requirements are met
Other duties as assigned

What Success Looks Like...

In 3 months...

Become familiar with the basic architecture and processes of Bamboo Health services, especially Data Warehouses and reporting products.
Understand strategic roadmap projects and how your development efforts contribute.
Start to contribute fixes and small improvements (EX: Query tuning).
Participate in troubleshooting and resolution of production ETL and reporting issues/outages.

In 6 months...

Independently audit and repair ETL and rerun reporting as needed.
Troubleshoot Kubernetes deployments and other operational processes with emphasis on ETL and reporting.
Develop complex queries, scripts that utilize AWS infrastructure and automation for reporting.
Understand the securities strategies, grant and remove access to Data Engineering systems and reports, and define AWS Infrastructure access pattern needs of new deployments.

In 12 months...

Represent Data Engineering in new ETL and data reporting discussions providing technical solution recommendations within project roadmaps.
Contribute novel patterns and capabilities.
Work with architects to identify and correct missing product components, deploy new ETL or reporting products and help deploy dependencies and processes.

What You Need:

Bachelor's degree in Computer Science, Analytics, a related field, or equivalent experience
3-5 years total software and relational database development experience.
2 years with a strong demonstrated ability to develop and maintain ETL solutions, ideally using Python and various Application Programming Interfaces (API)
1+ years' experience with AWS Cloud Solutions/Services
Ability to work in an Agile environment include using ticketing software such as JIRA
Strong technical problem-solving abilities
Hands on experience maintaining databases on Redshift, PostgreSQL, MySQL or Oracle relational database systems.
Experience with software development using Python, Ruby or other modern scripting languages, ideally in container solutions such as Docker or Kubernetes.

What You Get:

Join one of the fastest growing health tech companies in the country.
Have the autonomy to build something with an enthusiastically supportive team.
Learn best practices from world class investors and advisors.
Work closely with the country's largest and most innovative health systems.
Receive competitive cash compensation with health, dental, vision and other benefits.

We are an equal opportunity employer.


Equal Opportunity Employer - M/F/V/H

Job Summary

Employment Type:
Full Time Employee
Job type:
Federal Contractor
Skill Based Partner:
Education Level:
Bachelor's degree
Work Days:
Mon, Tue, Wed, Thu, Fri
Job Reference Code
Licenses / Certifications:
Display Recommended WorkKeys®Recommended WorkKeys®: