Lead Data Warehouse Engineer (Remote) – 247X7 Jobs NH, NJ, NM, NY, NC

process information
role: Lead facts Warehouse Developer

location: far flung

JD:

The Lead statistics Warehouse Developer will work with OSC workforce to (a) maintain current processes and systems as well as help with enforcing new records assets as asked by means of OSC, and (b) remodel, combine, and load data into OSC infrastructure.

The Lead records Warehouse Developer will help the Initiative. obligations consist of:

obtaining facts from numerous resources consisting of cloud offerings and utilizing comfy FTP and different transfer protocols;
keeping and developing PL/sq. for numerous data analytics initiatives presently in production;
serving as a database architect to study contemporary facts analytics infrastructure and making tips on a way to shape going forward;
offering technical assist for interfacing between the backend records and the front give up equipment consisting of Tableau;
leveraging current in-residence generation to support ETL such as Attunity Compose;
reviewing current architecture and structures with the intention of integrating the information analytics surroundings with agency requirements and pleasant practices;
parsing XML documents into significant datasets that can be ate up via OSC analysts;
creating documentation for current surroundings and any modifications going ahead;
offering steerage whilst reviewing person tales as to the first-rate mechanism/platform to use with the intention to meet person wishes; and
developing or helping with the introduction of dashboards and visualizations in Tableau or similar data visualization merchandise.

at least 5 years enjoy troubleshooting complex technical issues concerning networking, database, application, and related servers;

at least three years revel in modeling facts for reporting and analytics;

at least five years experience in tuning sq. for performance;

at least three years experience imparting technical steerage to a group of software program developers to put in force answers to more than one concurrent complex technical troubles;

at the least 3 years enjoy offering technical steerage to a group of software builders concerning all components of overall performance tuning an employer statistics warehouse reporting and analytics system; and

as a minimum 5 years experience acting Oracle database improvement the use of square and PL/square.