Lead Data Engineer

at  Amwell

COMPANY DESCRIPTION

Amwell digitally empowers payers, providers and innovators, enabling an ecosystem of care that spans across in-person, virtual and automated care.
Amwell provides a leading hybrid care enablement platform in the United States and globally, connecting and enabling providers, payers, patients, and innovators to deliver greater access to more affordable, higher quality care.
Amwell believes that hybrid care delivery will transform healthcare. The company offers a single, comprehensive platform to support all digital health needs from urgent to acute and post-acute care, as well as chronic care management and healthy living.
With nearly two decades of experience, Amwell powers the hybrid care of more than 55 health plans, which collectively represent more than 90 million covered lives, and many of the nation’s largest health systems, representing over 2,000 hospitals, have access to Amwell solutions.
For more information, please visit Amwell.com.

QUALIFICATIONS:

• 13+ years of development experience building data pipelines.
• Bachelor’s Degree or equivalent experience is required. Preferred in Computer Science or related degree
• Minimum of 5 years of experience in architecture of modern data Warehousing platforms using technologies such as Big Data and Cloud, Kafka experience.
• Cloud experience - any cloud, preferably Bigquery, data flow, pub-sub, data fusion
• Migration experience, Utilizing GCP to move data from on-prem servers to the cloud
• Strong Python development for data transfers and extractions (ELT or ETL)
• Experience developing and deploying ETL solutions like Informatica or similar tools
• Experience working within an agile development process (Scrum, Kanban, etc)
• Familiarity with CI/CD concepts
• Demonstrated proficiency in creating technical documentation
• Modern concepts (how new-gen DB is implemented – like how BQ/Redshift works?).
• Airflow, Dag development experience
• Informatica or any ETL tool previous experience.
• Ability and experience in BI and Data Analysis, end-to-end development in data platform environments.
• Modern concepts (how new-gen DB is implemented – like how BQ/Redshift works?).
• Write excellent, fully tested code to build ETL /ELT data pipelines on Cloud.
• Provide in-depth and always-improving code reviews to your teammates
• Build cloud data solutions and provide domain perspective on storage, big data platform services, serverless architectures, RDBMS, DW/DM
• Participate in deep architectural discussions to build confidence and ensure customer success when building new solutions on the GCP platform
• Fix things before they break

• Good communication skills, as well as the ability to work effectively across internal and external organizations and virtual teams.
• Design and write excellent, fully tested code to ETL/ELT data pipelines and stream on a cloud platform.
• Take ownership of design & development processes, ensuring incorporation of best practices, the sanity of code and versioning into different environments through tools like git etc.
• Implement product features and refine specifications with our product manager and product owners.
• continuously improve team processes to ensure information is of the highest quality, contributing to the overall effectiveness of the team.
• Stay familiar with industry changes, especially in the areas of cloud data and analytics technologies.
• Ability to work on multiple areas like Data pipeline ETL, Data modelling design, writing complex SQL queries etc, and a good understanding of BI/DWH principles
• Capable of planning and executing both short-term and long-term goals individually and leading the team.
• Provides best practices and direction for data engineering and design across multiple projects and functional areas.
• Understanding of the SDLC(Software Development life cycle) and Knowledge of Scrum, Agile