Senior Data Engineer - AWS

  • Requisition ID: 177410
  • Department: 100612 Enterprise Data Analytics
  • Schedule: Full Time - Eligible for Benefits
  • Shift: Day
  • Category: Professionals
  • Salary:$58.83 - $82.37

Position Purpose

Renown Health is looking for a Senior Data Engineer familiar with the Amazon Web Services (AWS) Cloud-based platform. This position will develop, design, implement, and maintain an AWS Data Warehousing environment, along with supporting telephony infrastructure, that helps support Renown Health’s digital engagement strategy and call center. The role will include working with AWS Connect and AWS Lambda. In addition, this role will include setting up and automating data pipelines via ETL / ELT processes across four environments: Epic EHR, Salesforce, AWS cloud infrastructure, and Microsoft Azure SQL databases. The engineer will be expected to know SQL and be comfortable discussing complex computer science or statistical concepts with data scientists and analysts. Innovation is critical to this role as an ideal candidate will possess the ability to lead the development of cloud-based infrastructure and associated data warehouses as it related to supporting the digital engagement strategy and call center.

 

 

 

Nature and Scope

This role can be either remote or hybrid.

 

Primary Responsibilities:

  • Experience with AWS infrastructure including AWS Connect and AWS Lambda.
  • Manage and optimize the movement and validation of data from an Epic EMR system to SQL databases in AWS or Azure and either from or to the Salesforce platform.
  • Accountable for data engineering lifecycle including research, proof of concepts, architecture, design, development, test, deployment, and maintenance. This role will focus on AWS optimization with some work occurring in other cloud-based environments.
  • Oversee the development of novel data pipelines that integrate and normalize large data from a variety of sources (e.g., electronic health record, claims, wearable device, publicly available data, etc.) to enable learning health, machine learning model development, and deployment.
  • Design, direct and implement ETL processes, including data capture, data quality, testing and validation methods.
  • Layer in instrumentation in the development process so that data pipelines can be monitored. Measurements are used to detect internal problems before they result into user visible outages or data quality issues.
  • Build processes and diagnostic tools to troubleshoot, maintain and optimize engineering environments and respond to production issues.
  • Provide subject matter expertise and hands on delivery of data capture, curation, and consumption pipelines for AWS.
  • Participate in deep architectural discussions to build confidence and ensure customer success when building new solutions and migrating existing data applications on the Azure platform.
  • Develop documentation, such as data dictionaries, guides, or data flow diagrams that assists staff in identifying, locating, and using the organization’s data.

 

Incumbent Must Possess:

  • Minimum of 3 years of SQL programming experience and associated SQL tools (SSIS, SSMS, SSRS, etc.).
  • Experience with Visual Studio is preferred.
  • At least 3 years of experience in developing data ingestion, data processing and analytical pipelines for big data, relational databases, NoSQL and data warehouse solutions.
  • Minimum of 3 years of RDBMS experience.
  • Extensive hands-on experience implementing data migration and data processing using Amazon Web Services. Includes knowledge of Amazon Connect and Amazon Lambda.
  • Knowledge of medical terminology, especially ICD-10 codes, CPT codes, DRG codes, and an understanding of adjudicated claims data.
  • Excellent verbal and written communication. An applicant may be asked to provide examples of written work to demonstrate technical writing proficiency.

 

 

Disclaimer

The foregoing description is not intended and should not be construed to be an exhaustive list of all responsibilities, skills and efforts or work conditions associated with the job. It is intended to be an accurate reflection of the general nature and level of the job.

 

 

 

Minimum Qualifications
Requirements - Required and/or Preferred

Name

Description

Education:

Master’s degree with 10 years’ experience preferred; Bachelor’s degree with 13 years of equivalent experience will be considered in place of master’s degree requirement.

Experience:

Requires a minimum of 10 years’ experience with at least five (5) years working in data management, data engineering, or data architecture. Enterprise Data Warehouse development preferred; Requires at least five (5) years working with healthcare data; more is preferred. SQL proficiency is required.

License(s):

None

Certification(s):

Certification work related to Epic may be required within 1 year of starting employment.

Computer / Typing:

Must be proficient with Microsoft Office Suite, including Outlook, PowerPoint, Excel, and Word and can use the computer to complete online learning requirements for job-specific competencies, access online forms and policies, complete online benefits enrollment, etc.

 

 

 

Benefits

Renown Health exists to make a genuine difference in the health and well-being of the people and communities we serve. And it is through your passion that this mission is made real every day. The relationship with employees is the foundation for success as we proceed with our strategic direction. We strive to build upon this solid partnership by offering a comprehensive and competitive benefits package that meets the diverse needs of employees and their family members.

With my CAREER Rewards there's peace of mind in knowing that Renown Health is also fighting for the most important things in your life - family, finances and future. Navigate options and make sure you are getting the most value from your Nursing career with us.

  • Icon- Edu Assistance@1x

    Education Assistance

  • Icon - PTO@1x

    Paid Time Off

  • Icon - 401@1x

    401(k) Company Match

  • Icon - Flexible Env@1x

    Flexibile Work Environment