Lead Data Engineer
Remote
Amwell
Amwell digitally empowers payers, providers and innovators, enabling an ecosystem of care that spans across in-person, virtual and automated care.Company Description
Amwell is a leading telehealth platform in the United States and globally, connecting and enabling providers, insurers, patients, and innovators to deliver greater access to more affordable, higher quality care. Amwell believes that digital care delivery will transform healthcare. We offer a single, comprehensive platform to support all telehealth needs from urgent to acute and post-acute care, as well as chronic care management and healthy living. With over a decade of experience, Amwell powers telehealth solutions for over 150 health systems comprised of 2,000 hospitals and 55 health plan partners with over 36,000 employers, covering over 80 million lives.
Brief Overview:
The Lead Data Engineer should have experience in end-to-end implementation of data-warehousing projects. This individual will manage, utilize, move, and transform data from our source system and applications data to the cloud to create reports for senior management and internal users. This individual will work both independently on assigned projects and collaboratively with other team members. The Lead Data Engineer will collaborate with architects, business users, and source (data) team members on discovering data sources and determine tech feasibility for fetching these data sources into the consolidated data environment/platform. This individual will iteratively design and build core components for our data platform, build various ETL pipelines among the various tools in play to surface data for consumption by our reporting tools, and prioritize competing requests from internal and external stakeholders in addition to keeping the reporting infrastructure on par with new product functionality and release cycles. The Lead Data Engineer will become a subject matter expert in data classification within the platform and utilize their expertise to identify the most efficient path to deliver data from source to target, as needed.
Core Responsibilities:
- Design and write excellent, fully tested code to ETL/ELT data pipelines, and stream on a cloud platform.
- Have good communication skills, as well as the ability to work effectively across internal and external organizations and virtual teams.
- 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.\Able to work on multiple areas, like data pipeline ETL, data modelling design, writing complex SQL queries, etc., and have a good understanding of BI/DWH principles
- Plan and execute both short-term and long-term goals individually and leading the team.
- Provide best practices and direction for data engineering and design across multiple projects and functional areas.
- Understand SDLC (Software Development life cycle) and have knowledge of Scrum, Agile.
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, Cloud, and Kafka experience.
- Cloud experience - any cloud, preferably Bigquery, data flow, pub-sub, and data fusion.
- Migration experience, 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.
- Understand 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.
- 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, and 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.
Additional information
Your Team:
Should you join Amwell and the Engineering team, you can expect:
The development organization is a multi-disciplinary team of engineers dedicated to creating a state-of-the-art TeleHealth experience on every platform we can get our hands on. Our cross-functional teams follow a pragmatic Agile methodology as we balance feature requests, strategic initiatives, tech debt, and exciting partnerships on the path to delivering a market leading product to a quickly growing customer base. We work hand in hand with the whole Amwell organization to ensure that our product meets the needs of all of our users.
Working at Amwell:
Amwell is changing how care is delivered through online and mobile technology. We strive to make the hard work of healthcare look easy. In order to make this a reality, we look for people with a fast-paced, mission-driven mentality. We’re a culture that prides itself on quality, efficiency, smarts, initiative, creative thinking, and a strong work ethic.
Our Core Values include One Team, Customer First, and Deliver Awesome. Customer First and Deliver Awesome are all about our product and services and how we strive to serve. As part of One Team, we operate the Amwell Cares program, which brings needed assistance to our communities, whether that be free healthcare for the underserved or for people affected by natural disasters, support for equality, honoring doctors and nurses, or annual Amwell-matched donations to food banks. Amwell aims to be a force for good for our employees, our clients, and our communities.
Amwell cares deeply about and supports Diversity, Equity and Inclusion. These initiatives are highlighted and reflected within our Three DE&I Pillars - our Workplace, our Workforce and our Community.
Amwell is a "virtual first" workplace, which means you can work from anywhere, coming together physically for ideation, collaboration and client meetings. We enable our employees with the tools, resources and opportunities to do their jobs effectively wherever they are! Amwell has collaboration spaces in Boston, Tysons Corner, Portland, Woodland Hills, and Seattle.
- Unlimited Personal Time Off (Vacation time)
- 401K match
- Competitive healthcare, dental and vision insurance plans
- Paid Parental Leave (Maternity and Paternity leave)
- Employee Stock Purchase Program
- Free access to Amwell’s Telehealth Services, SilverCloud and The Clinic by Cleveland Clinic’s second opinion program
- Free Subscription to the Calm App
- Tuition Assistance Program
- Pet Insurance
Tags: Agile Airflow Architecture Big Data BigQuery CI/CD Classification Computer Science Data analysis Data pipelines Data Warehousing ELT Engineering ETL GCP Git Informatica Kafka Kanban Pipelines Python RDBMS Redshift Scrum SDLC SQL
Perks/benefits: 401(k) matching Career development Health care Parental leave Unlimited paid time off
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open MLOps Engineer jobs
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open Data Manager jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open Power BI Developer jobs
- Open Sr Data Engineer jobs
- Open Principal Data Engineer jobs
- Open Business Intelligence Developer jobs
- Open Data Analytics Engineer jobs
- Open Junior Data Scientist jobs
- Open Product Data Analyst jobs
- Open Data Scientist II jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Business Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Data Product Manager jobs
- Open Junior Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Azure Data Engineer jobs
- Open Principal Data Scientist jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open PyTorch-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open CI/CD-related jobs
- Open LLMs-related jobs
- Open Kubernetes-related jobs
- Open Generative AI-related jobs
- Open Data governance-related jobs
- Open Hadoop-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs