Data Analyst

Contracttohire. Manager is open to candidates who are not able to convert.

100% Telecommute

Hours: 9am5pm 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 analyst with varying technical knowledge but SMEs in the identification of fraud waste and abuse two report developers (Cognos and Power BI).

Project: Multiple projects: MALTSS

• 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 nontechnical leadership

Ideal Background:
Versatile software developer with skills in several technologies. Strong SQL PL/SQL TransactSQL 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.

Preferred:

• Experience working in a matrixed environment on a fastpaced project
• Experience developing within an agile framework
• Experience with Snowflake
• Experience with data loading tools (Talend Informatica Data Factory ODI)
• Exposure to cloud environments experience (Azure)