Lead Data Engineer
SilverCloud
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.
Brief Overview:
The lead Data Engineer should have experience in end-to-end implementation of data-warehousing projects, he 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. working both independently on assigned projects, and collaboratively with other team members. Collaborate with architects, business users, and source (data) team members for discovering data sources and tech feasibility for fetching the same into the consolidated data environment/platform. 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 tool. Prioritize competing requests from internal and external stakeholders in addition to keeping the reporting infrastructure on par with new product functionality and release cycles. Become a Subject Matter Expert in data classification within the platform and utilize your expertise to identify the most efficient path to deliver data from Source to target as needed.
Core Responsibilities:
- 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
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
Job Level: P4
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!
Additional Benefits
Medical Plan Coverage provided by Colmédica
► 100% paid by Amwell for employee coverage
► 50% paid for spouse or dependent coverage Life Insurance
- Plan Coverage provided by Pan American
- ► Paid 100% by Amwell for 12 monthly salaries
- Hybrid Allowance
- ►311,850 COP provided by Amwell
- Paid Time Off
- ► 20 days of Annual Leave
- ► 4 Mental Health Days
- ► 1 Day of Service/Volunteering
- ► 1 Day for Birthday (taken within birthday month)
- ► 1 day of family day per 6 months
- Maternity Leave 18 weeks
- ►paid by Amwell Paid
- Parental/Paternity Leave 2 mandatory weeks + 4 weeks
- ►paid by Amwell for a total of 6 weeks paid by Amwell
- Mental Health and Resiliency
- ► You have access to Calm at no cost
- Virtual Second Opinion with the Cleveland Clinic Coverage
- ►provided by Amwell at no cost for employees
- LinkedIn Learning
- ►Provided by Amwell at no cost
- Rewards and Recognition
- ►Employees will be eligible to participate in Amwell’s recognition program, Bucketlist
- Service Anniversaries
- ►Employees will receive recognition and points via Bucketlist for service milestones
- Annual Bonus
- ►Employees will be eligible for Amwell’s Corporate Performance Bonus Program
- Referral Program
- ►Employees may be eligible for a referral bonus for referring candidates to open role