Primary Responsibilities

• Program SQL statements in MS SQL databases to transform data from varied formats into standardized formats.

• Create stored procedures and scripts to perform ETL.

• Use internal SQL-based systems to import, process, and clean client-supplied data files in various formats.

• Work closely with client-facing team to identify data sources.

• Requires excellent QA skills to closely review post processed data to ensure data accuracy and integrity.

• Set up and use internal tools to extract data from websites.

  Tools used:

• Microsoft SQL Server

• Outlook (and other Office products)

• JIRA

• Various Internal data management systems

• Internal Web Scraping Applications

  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

• Must have professional manner and respect the confidentiality of administrative matters and files

• 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 multi-tasks as required.

• Excellent project management skills.

• Attention to detail and concern for impact is essential.

  Communication Skills:

• Must work well with others.

• Effectively communicates with others by giving and receiving feedback.

• Communicates ideas and information clearly.

• Must have good verbal and presentation skills to effectively interface with the entire staff, and external representatives from the business and client communities.

  Education and Professional Experience:

• 4+ years of relevant experience

• Experience with ETL (DTS/SSIS), SQL Server, or other databases.

• Understanding of T-SQL, stored procedures

• Must demonstrate good analytical skills as it relates to data identification and mapping and good 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.

• Knowledge of Regular Expressions, JavaScript, and HTML encouraged but not required.

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, 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.

As the leading healthcare payments company, we price, pay and explain care for payers, providers, and healthcare consumers. Zelis was founded on a belief there is a better way to determine the cost of a healthcare claim, manage payment-related data, and make the payment because more affordable and transparent care is good for all of us. We partner with over 700 payers, 1.5 million providers, and millions of members -- enabling the healthcare industry to pay for care, with care.Zelis brings adaptive technology, a deeply ingrained service culture, and an integrated pre-payment through payments platform to manage the complete payment process.