Job Description:

Job Title

Contract-to-hire. Manager is open to candidates who are not able to convert.

100% Telecommute Hours: 9am-5pm, occasional weekend work

Interview Process: 2 rounds via video. Very technical.

Team

Small team, made up of two data engineers (ETL, Algo development), two software engineers, 8 data analysts with varying technical knowledge but SMEs in the identification of fraud, waste and abuse, two report developers (Cognos and Power BI).

Project

Multiple projects: MA-LTSS

  • Develop the ETL for a mature product NH Upgrade
  • Conversion of data from older case management system to new system
  • Assistance with running and balancing weekly loads for 8 clients in different environments.
  • Write procedures for new algorithms (14 required this year).
Responsibilities
  • Work closely with data analysts to transform specification into client algorithms (4 Oracle, 2 Snowflake)
  • Code complex procedures to support new client algorithms (4 Oracle, 2 Snowflake)
  • Contribute to technical documentation of specifications and processes
  • Responsible for weekly data loads and balancing of 9 accounts (6 Oracle, 3 Snowflake)
  • Investigate data anomalies to determine root cause, specify appropriate changes and work with engineering and operations teams as the change is implemented and tested
  • Research client questions on data results by identifying underlying data elements leveraged and providing descriptions of data transformations involved
  • Work closely with engineering and operations teams to answer questions and resolve data issues that arise
  • Responsible for extracting and replicating data into a common data mart.
  • Drive adoption of best practices and agreed upon design patterns
  • Communicate clearly and effectively in oral and written forms, and be able to present and demonstrate work to technical and non-technical leadership
Ideal Background

Versatile software developer with skills in several technologies. Strong SQL, PL/SQL, Transact-SQL, and Linux/Unix command line skills. Experienced working in Azure Cloud.

Top Requirements
  • 10+ years of Oracle Database experience.
  • 5+ years of advanced PL/SQL and SQL experience
  • 5+ years of UNIX command prompt navigation, including VI editor- (Shell Scripts)
Experience That Will Set Candidates Apart

Experience with Azure Data Factory, Snowflake and ETL of healthcare data.

Required
  • 10+ years of Oracle Database experience.
  • 5+ years of experience with data warehouses/marts supporting business requirements
  • 5+ years of advanced PL/SQL and SQL experience
  • 5+ years of UNIX command prompt navigation, including VI editor- (Shell Scripts)
  • 5+ years of experience working with healthcare data, to include 2+ years with Claims data.