• Job Description

  Req#: R-035201
  Support Center

  If you are a current Adventist HealthCare employee, please click this link to apply through your Workday account.

  Adventist Healthcare seeks to hire an experienced Data Engineer III for our Information Technology Department who will embrace our mission to extend God’s care through the ministry of physical, mental and spiritual healing.
  
  As a Data Engineer III you will:
  • Architect and build scalable, reusable, and maintainable ETL pipelines using Talend Data Integration.
  • Creates and supports the ETL process to facilitate the onboarding of data into the data warehouse and distribution of data across data stores from a wide variety of sources using different ETL tools and technologies.
  • Optimizes pipeline orchestration, handling dependencies, and failures.
  • Implement complex data transformations using components like tMap, tJavaRow, tSQLRow, and JSON.Automate data ingestion from REST APIs, cloud platforms, and relational databases into cloud or on-premises storage.
  • Optimize Talend jobs for high-volume data processing through efficient memory settings, parallelization, and dependency injection.
  • Debug and enhance existing Talend jobs to address bugs or evolving requirements.
  • Manage deployments using Talend Administrator Console (TAC) for scheduling and lifecycle management.
  • Develop and maintain data ingestion pipelines from local storage to Snowflake, ensuring data transformation and archival as per mapping documents.
  • Write and optimize Snowflake stored procedures and Snowflake SQL for efficient data processing. Integrate Talend with cloud platforms like Snowflake.
  • Creating and supporting routine and ad hoc data load processes through database refreshes and updates.
  • Optimize data integration platform to provide optimal performance under increasing data volumes. Optimizes ETL workflows for efficiency, using parallel processing
  • Check in code to Git and create artifacts using tools like NEXUS for deployment through CI/CD pipelines. Build and maintain CI/CD pipelines to publish jobs to higher environments. Resolve merge conflicts and follow best practices for version control using Git.
  • Provide expertise in the design and development of best practices for big data stacking, data warehousing, data lake, ETL architecture, data federation, virtualization, data modeling procedures, and workflows, including technical documents.
  • Maintains detailed charts, diagrams, and flow charts outlining systems, hardware, interfaces, and configurations related to data warehousing and ETL jobs and tasks.
  • Provide Data Integration and data warehousing application portfolio support in the timely resolution of technology incidents while adhering to SLA prioritization and success measures, including 24/7 on-call support.
  
  Qualifications include:
  • Mission-driven individual with strong values that align with the AHC mission
  • Ability to work in a fast-paced, critical patient care-driven organization
  • Strong ETL and Datawarehouse implementation experience and skill, especially Talend ETL
  • Preferred working in a cloud-based environment such as AWS or Azure
  • Must be able to think critically, detail-oriented, and present arguments in an articulate manner
  • Ability to articulate ideas to both technical and non-technical addressees
  • Exceptionally self-motivated and directed
  • Customer service-oriented individual
  • Bachelor’s degree in computer science, information technology, or related field.
  • 5+ years of professional data engineering experience, with hands-on experience using Talend Data Integration
  • 5+ years of Extensive experience designing and optimizing ETL/ELT processes and data pipelines. Advanced knowledge of Talend Data Integration, Talend Administration Center, Data Quality, API Designer, and Big Data Frameworks
  • 5+ years of Experience working on cloud-based environments such as Oracle Cerner, AWS, Azure, or Google Cloud.
  • 5+ years of Experience working with large-scale data warehouses and related technologies.
  • 4+ years of experience with Snowflake (SQL and stored procedures) and Oracle.
  • 3+ years of experience with database schema design, data modeling, and data warehousing.
  • 3+ years of hands-on experience with cloud storage solutions like Snowflake.
  • 3+ years proficiency in Python and Java for data extraction, transformation, and loading (ETL). Experience with JSON, XML, CSV, and other file formats for data transformation.
  • 3+ years’ experience integrating with RESTful and SOAP web services. Proven expertise in CI/CD pipelines and version control using Git.
  • Preferred Talend ETL developer certification. Familiarity with Snowflake, Azure cloud platforms, and tools

  Work Schedule:

  Day Shift-Remote

  #GR8 Information Technology

  Pay Range:

  $96,058.56 - $144,081.60

  If the salary range is listed as $0 or if the position is Per Diem (with a fixed rate), salary discussions will take place during the screening process.

  Under the Fair Labor Standards Act (FLSA), this position is classified as:

  United States of America (Exempt)

  At Adventist HealthCare our job is to care for you.

  We do this by offering:

  • Work life balance through nonrotating shifts

  • Recognition and rewards for professional expertise

  • Free Employee parking

  • Medical, Prescription, Dental, and Vision coverage for employees and their eligible dependents effective on your date of hire

  • Employer-paid Short & Long-Term Disability, Basic Life Insurance and AD&D, (short-term disability buy-up available)

  • Paid Time Off

  • Employer retirement contribution and match after 1-year of eligible employment with a 3-year vesting period

  • Voluntary benefits include flexible spending accounts, legal plans, and life, pet, auto, home, long term care, and critical illness & accident insurance

  • Subsidized childcare at participating childcare centers

  • Tuition Reimbursement

  • Employee Assistance Program (EAP) support

  As a faith-based organization, with over a century of caring for the communities in the Maryland area, Adventist HealthCare has earned a reputation for high-quality, compassionate care. Adventist HealthCare was the first and is the largest healthcare provider in Montgomery County.
  
  If you want to make a difference in someone’s life every day, consider a position with a team of professionals who are doing just that, making a difference.

  
  Join the Adventist HealthCare team today, apply now to be considered!

  COVID-19 Vaccination

  Adventist HealthCare strongly recommends all applicants to be fully vaccinated for COVID-19 before commencing employment. Applicants may be required to furnish proof of vaccination.

  Tobacco and Drug Statement

  Tobacco use is a well-recognized preventable cause of death in the United States and an important public health issue. In order to promote and maintain a healthy work environment, Adventist HealthCare will not hire applicants for employment who either state that they are nicotine users or who test positive for nicotine and drug use.

  While some jurisdictions, including Maryland, permit the use of marijuana for medical purposes, marijuana continues to be classified as an illegal drug under the federal Controlled Substances Act. As a result, medical marijuana use will not be accepted as a valid explanation for a positive drug test result.

  Adventist HealthCare will withdraw offers of employment to applicants who test positive for Cotinine (nicotine) and marijuana. Those testing positive are given the opportunity to re-apply in 90 days, if they can truthfully attest that they have not used any nicotine products in the past ninety (90) days and successfully pass follow-up testing. ("Nicotine products" include, but are not limited to: cigarettes, cigars, pipes, chewing tobacco, e-cigarettes, vaping products, hookah, and nicotine replacement products (e.g., nicotine gum, nicotine patches, nicotine lozenges, etc.).

  Equal Employment Opportunity
  Adventist HealthCare is an Equal Opportunity/Affirmative Action Employer. We are committed to attracting, engaging, and developing the best people to cultivate our mission-centric culture. Our goal is to have a welcoming, equitable, and safe place to work and grow for all employees, no matter their background. AHC does not discriminate in employment opportunities or practices on the basis of race, ethnicity, color, religion, sex, national origin, age, disability, sexual orientation, gender identity, pregnancy and related medical conditions, protected veteran status, or any other characteristic protected by law.

  Adventist HealthCare will make reasonable accommodations for applicants with disabilities, in accordance with applicable law. Adventist HealthCare is a religious organization as defined under applicable law; however, it will endeavor to provide reasonable accommodations for applicants’ religious beliefs.

  Applicants who wish to request accommodations for disabilities or religious belief should contact the Support Center HR Office.
  

• About the company

  Adventist HealthCare, based in Gaithersburg, Md., is a faith-based, not-for-profit organization of dedicated professionals who work together each day to improve the health and well-being of people and communities through a ministry of physical, mental, and spiritual healing.

Notice