Summary:

• Design, develop and implement scalable batch/real time data pipelines (ETLs) to integrate data from a variety of sources into Data Warehouse and Data Lake

• Design and implement data model changes that align with warehouse dimensional modeling standards.

• Proficient in Data Lake, Data Warehouse Concepts and Dimensional Data Model.

• Responsible for maintenance and support of all database environments, design and develop data pipelines, workflow, ETL solutions on both on-prem and cloud-based environments.

• Design and develop SQL stored procedures, functions, views, and triggers

• Design, code, test, document and troubleshoot deliverables

• Collaborate with others to test and resolve issues with deliverables

• Maintain awareness of and ensure adherence to Zelis standards regarding privacy.

• Create and maintain Design documents, Source to Target mappings, unit test cases, data seeding.

• Ability to perform Data Analysis and Data Quality tests and create audit for the ETLs.

• Perform Continuous Integration and deployment using Azure DevOps and Git

• Experience with Banking and Finance Processes specifically NACHA, BAI2 and Bank 822 Files required.

• This position will support the Payments Advanced Record Keeping Project

Requirements:

• Minimum of 5+ years experience in the following:

  • 5+ years data engineering experience to include data analysis

  • 2+ years working with an ETL tool (DBT preferred)

  • 5+ years programming SQL objects (procedures, triggers, views, functions) in SQL Server. Plus experience optimizing SQL queries a plus

  • 2+ years designing and developing Azure/AWS Data Factory Pipelines.

  • 2+ years Columnar MPP Cloud data warehouse using Snowflake

• Advanced understanding of T-SQL, indexes, stored procedures, triggers, functions, views, etc.

• Experience designing and implementing Data Warehouse.

• Working Knowledge of Azure/AWS Architecture, Data Lake

• Must be detail oriented. Must work under limited supervision. Must demonstrate good analytical skills as it relates to data identification and mapping and excellent oral communication skills. Must be flexible and able to multi-task and be able to work within deadlines; must be team-oriented, but also be able to work independently.

Preferred Skills:

• Microsoft BI stack (SSIS/SSRS/SSAS)

• Working knowledge managing data in the Data Lake.

• Business analysis experience to analyze data to write code and drive solutions

• Knowledge of: Git, Azure DevOps, Agile, Jira and Confluence.

• Healthcare and/or Payments experience

Independence/ Accountability:

• Requires minimal daily supervision

• Receives detailed instruction on new assignments and determines next steps with guidance

• Regularly reviews goals and objectives with supervisor

• Demonstrates competence in relevant job responsibilities which allows for increasing level of independence

• Ability to manage and prioritize multiple tasks

• Ability to work under pressure and meet deadlines

Problem Solving:

• Makes logical suggestions of likely causes of problems and independently suggests solutions

• Excellent organizational skills are required to prioritize responsibilities, thus completing work in a timely fashion

• Outstanding ability to multiplex tasks as required

• Excellent project management and/or business analysis skills.

• Attention to detail and concern for impact is essential

As a leading payments company in healthcare, we guide, price, explain, and pay for care on behalf of insurers and their members. We’re Zelis in our pursuit to align the interests of payers, providers, and consumers to deliver a better financial experience and more affordable, transparent care for all. We partner with more than 700 payers, including the top-5 national health plans, BCBS insurers, regional health plans, TPAs and self-insured employers, over 4 million providers, and 100 million members, enabling the healthcare industry to pay for care, with care. Zelis brings adaptive technology, a deeply ingrained service culture, and a comprehensive navigation through adjudication and payment platform to manage the complete payment process.

Commitment to Diversity, Equity, Inclusion, and Belonging
At Zelis, we champion diversity, equity, inclusion, and belonging in all aspects of our operations. We embrace the power of diversity and create an environment where people can bring their authentic and best selves to work. We know that a sense of belonging is key not only to your success at Zelis, but also to your ability to bring your best each day.

Equal Employment Opportunity
Zelis is proud to be an equal opportunity employer. All applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

We encourage members of traditionally underrepresented communities to apply, even if you do not believe you 100% fit the qualifications of the position, including women, LGBTQIA people, people of color, and people with disabilities.

Accessibility Support

We are dedicated to ensuring our application process is accessible to all candidates. If you are a qualified individual with a disability or a disabled veteran and require a reasonable accommodation with any part of the application and/or interview process, to request the reasonable accommodation request form, please email TalentAcquisition@zelis.com

SCAM ALERT: There is an active nationwide employment scam which is now using Zelis to garner personal information or financial scams. This site is secure, and any applications made here are with our legitimate partner. If you’re contacted by a Zelis Recruiter, please ensure whomever is contacting you truly represents Zelis Healthcare. We will never asked for the exchange of any money or credit card details during the recruitment process. Please be aware of any suspicious email activity from people who could be pretending to be recruiters or senior professionals at Zelis.