Data Engineer

Overview
Data Engineer IV
Envision Healthcare
Remote
Envision Healthcare is a leading national medical group focused on delivering high quality care to patients when and where they need it most. More than 30,000 clinicians and clinical support teammates call Envision home. We welcome teammates of every background and work in communities that reflect the racial, ethnic, gender, sexual orientation, and economic diversity of our country.
Through Envision Physician Services and AMSURG, our clinician-led organization is changing the face of healthcare by delivering high-quality care that puts the patient first.
Envision's core values drive continual advancement and ingenuity across the enterprise:

• Be Curious-embrace learning, seek out diversity of thought, listen openly, ask questions, and ask for feedback
• Instill Trust-have the hard conversation, presume good intent, honor commitments, and do the right thing for patients and each other
• Pursue Extraordinary-challenge the status quo, champion change, innovate and constantly aim higher
• Care Deeply-serve patients, partners, communities, and each other with empathy, compassion, and respect
• Embrace Teamwork-work cross-functionally, break down walls, develop others, be inclusive and unite to improve patient health
• Inspire Joy-seek fulfillment and the joy of medicine, appreciate others, celebrate wins, and promote wellness and belonging

Benefits
We offer you an outstanding total compensation package, and a variety of health and welfare benefit options to help protect your health and promote your wellbeing. The benefits package includes: medical, dental and vision, life & disability, 401k, HSA, Flexible Spending and an Employee Assistance Program.
Responsibilities
We currently have an exciting opportunity available for an experienced Senior Data Engineer
As a Senior Data Engineer you will be working in a fast paced and growing environment helping to design, build, and implement data integration solutions, including data pipelines and ETL jobs, to meet the data needs of application, services, data assets, and business intelligence and analytical tools. You will be working closely with data architects, application development teams, data analytics teams, business analytics, product managers, and data governance, the Senior Data Engineer will design and develop interfaces between applications, databases, data assets, external partners, and third-party systems in a combination of cloud and on-premises platforms. You will be working in cutting edge technologies including, but not exclusive to, AWS (Redshift, data pipeline, Python, EMR, Athena, Glue, S3s, etc.), Snowflake, SQL, PostgreSQL, Tableau, Talend, and more.
Essential Duties and Responsibilities

• Develops and maintains scalable data pipelines and builds out new integrations to support continuing increases in data volume and complexity
• Designs and develops scalable ETL packages for point-to-point integration of data between source systems, extraction and integration of data into various data assets, including data warehouse and fit for purpose data repositories, both on prem and cloud
• Designs and develops data migrations in support of enterprise application and system implementations from legacy systems
• Writes functional specifications for data pipelines and APIs and writes and performs unit/integration tests
• Performs data analysis required to troubleshoot data related issues and assist in the resolution of data issues.
• Provides technical guidance and mentorship in Data Engineering best practices while demonstrating these as an individual contributor.
• Communicate/Demo features built to various stakeholders.
• Assist with deployment of data pipelines to various environments.
• Assist QA team with testing and validating of features built.
• Work closely with architects to help brainstorm solutions to various problem sets.
• Work closely with small, nimble, cross-functional teams of Data Engineers, product managers, designers, and business teams.
• Have opportunities to learn and work with technologies used at Envision like AWS (Redshift, data pipeline, Python, EMR, Athena, Glue, S3s, etc.), Snowflake, SQL, PostgreSQL, Tableau, Talend, and more.
• Responsible for adhering to Information Security Policies and ensuring Envision is as secure as possible.

Qualifications

• Bachelor's Degree from four-year college or university in Software Engineering, Computer Science, and 8 or more years of related experience; or equivalent combination of education and experience
• 8 years' experience designing, building, and testing ETL pipelines.
• Expert Knowledge and a minimum of four years' experience in one of the following domains: Data management, software engineering, I&O (infrastructure and operations)
• 4+ of working with data transformation and modeling
• Strong teamwork skills
• Must be motivated, self-driven, curious, and creative
• Must be skilled communicator, and demonstrate an ability to work with end users and business leaders
• Demonstrate the ability to support and complement the work of a diverse development and/or operations team
• You love participating with high-performing teams of engineers
• Customer-centricity and product focus
• You look at everything you create through the lens of how it improves things for the end-customer
• You are comfortable communicating how various technical approaches might impact product behavior (and vice versa)
• Learning mentality because nobody checks every box
• You aren't intimidated by new domains or technology; you're willing to dive into documentation/videos, talk to your teammates, and experiment to become well-versed
• Willingness to work across the development stack
• You're comfortable with working on data pipelines, transformations and implementing insights
• You're willing to jump into Envision backend applications on occasion
• Operational expertise
• You value robust observable solutions with actionable monitoring and the importance of tooling for troubleshooting and resolving issues

Education/Experience

• Experience with AWS - specific preference for Redshift, data pipeline, Python, EMR, Athena, Glue, S3s, etc.
• Experience with Snowflake
• Experience with relational databases (MSSQL, Postgres, etc.) and able to navigate, query, design, alter, and tune for performance.
• Programming experience with command in at least two languages: SQL, Python, Java, R or Spark
• Expert proficiency in SQL; experience with Oracle, PostgreSQL, MySQL, or Microsoft SQL Server
• Experience using Git, or a comparable code repository
• Experience working in a collaborative, cross-functional team; Active participation in sprint reviews
• Solid background in Agile methodologies

Avg. Annual Compensation Range- $102,000 - $148,000/ yr.
Please note, this position is remote and the pay range presented is specific to 100% national labor mkt avg. Salary bands across the enterprise may differ due to cost of living adjustments and are specific to an employee's address and state and can vary for higher labor mkts.
If you are ready to join an exciting, progressive company and have a strong work ethic, join our team of experts! We offer a highly competitive salary and a comprehensive benefits package.
Envision Healthcare uses E-Verify to confirm the employment eligibility of all newly hired employees. To learn more about E-Verify, including your rights and responsibilities, please visit www.dhs.gov/E-Verify.
Envision Healthcare is an Equal Opportunity Employer.
#LI-DK1
#LI-remote