Description

Transform business specifications into production algorithms and manage complex data workflows for multiple accounts.

This role is on-site.

Responsibilities

• Develop and maintain client algorithms using Oracle and Snowflake environments.
• Write and optimize complex SQL and PL/SQL procedures for data processing.
• Manage weekly data loads, ensuring accuracy and balancing across accounts.
• Investigate data anomalies, determine root causes, and coordinate fixes with engineering and operations.
• Document technical specifications, transformations, and design patterns for stakeholder review.

Required Skills

• 10+ years of hands-on Oracle Database experience.
• 5+ years of advanced PL/SQL and SQL coding.
• 5+ years of UNIX command line experience, including VI editor and shell scripting.
• Experience with healthcare claim data structures and processing.
• Ability to write clear technical documentation for specifications and processes.
• Bachelor's degree or equivalent graduate education.

Preferred Skills

• Experience with Snowflake and Azure Data Factory.
• Familiarity with ETL tools such as Talend, Informatica, or ODI.
• Experience working within agile frameworks or cloud environments like Azure.

Key Skills

Education

Any Graduate