DATA ANALYST

Role:Data Analyst

Location:100% remote Duration:12 months

strong (10+ years preferred) Oracle PL/SQL Unix VI editor (Shell Scripts). They are also looking for candidates with strong experience in healthcare/claims data – this will win!

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

Requirements

• • 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 Skills: • Experience working in a matrixed environment on a fast-paced 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)

• 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 Skills required: • 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)

• What experience will set candidates apart from one another: Experience with Azure Data Factory, Snowflake and ETL of healthcare data.

Thanks and Regards Ramyasree US IT RECRUITER Thought wave Software and Solutions 314 N. Lake St, Suite 6, Aurora IL 60506 Desk: 6302164696 Email:ramyasree@thoughtwavesoft.com LinkedIn: https://www.linkedin.com/in/ramya-sree-kolla-519839221/

A Certified Minority Business Enterprise, Disadvantaged Business Enterprise, SAM.gov, SOC2 & ISO2005, Vendors for: · STATES: IL, PA, TN, AK, OR, CT, GA, VA, ID, IA, UT, FL, MN & CO, · NATIONAL LABS: ARGONNE & FERMI, · COUNTIES: HENNEPIN, MN, FULTON & GA, · PUBLIC SCHOOLS: ATLANTA.