Sr. Data Engineer

Bamboo Health is the leader in Real-Time Care Intelligence™ solutions aimed at improving lives for everyone experiencing physical and behavioral health challenges. We are driven by our mission to empower clients to deliver seamless, high-quality and cost-effective care during pivotal moments to improve health outcomes. From coast to coast, Bamboo Health partners with all major retail pharmacy chains, 52 states and territories, 100% of the top 10 best hospitals and more than half of the country’s largest health plans to improve more than 1 billion patient encounters annually. Join us in improving lives during pivotal care moments! 

Summary:

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 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 team continuously seeks opportunities to automate, apply new AWS products and features, and strive for technological modernization. You will partner with other Engineering team members, Architects, Data Scientists, Analysts, and other Bamboo Health professionals.

What You’ll Do:

·       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 lifesaving 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

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 the roadmap of Data Engineering projects and how your efforts contribute.

·       Start to contribute fixes and small improvements (EX:  Query multi-threading).

·       Participate in troubleshooting and hotfix of 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, automation through AWS infrastructure and analytics workflows.

·       Understand the securities strategies, grant, and remove access to Data Engineering systems and reports, and follow AWS Infrastructure access patterns needed for new deployments.

In 12 months…

·       Represent Data Engineering in new ETL and data reporting discussions providing technical solution recommendations within project roadmaps.

·       Contribute novel coding patterns and capabilities from emerging API’s and SDK’s.

·       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

·       5+ years tota