Data Warehouse Developer with R or Python

Phone/Skype Hire. Onsite from day 1

Location: NYC, NY

Duration: 12+ months

Responsibilities

• Provide recommendations, guidance, and actual implementation for new data marts, as well as improving and consolidating existing Data marts.
• Participate and contribute to DW/BI projects throughout the project lifecycle.
• Establish written best practices, procedures and generally provide guidance on DW/DM data model design.

• Create and maintain up-to-date documentation for all supported DW/DM, ETL Plan, create, modify, maintain, test and implement code in support of any of the following:
  • Source System extraction processes for the Data Warehouse.
  • ETL processes.
  • BI Dashboards and reports. (R, Python)
  • Develop and maintain Spotfire systems (including prediction models written in R, TERR and automation services)
  • Automation of source system data extraction processes and data loading of the Data Warehouse.
  • Operationalize prediction models

• The consultant will adhere to NYSIF's application development standards, including, but not limited to, project management methodology, SDLC (software development life cycle), Enterprise Architecture standards, and the IT governance process.
• Support the BI Data Warehouse using TIBCO Spotfire, Information Builders software Data Migrator

Skills Needed

• 84-month Data Modeling experience in designing and creating DataMart, Data warehouse in Insurance industry (preferably Workers' Compensation and disability)
• 84-month experience with developing maintaining predictive systems written R or Python (preferably in TIBCO Spotfire/TERR).
• 84-month experience with TIBCO Spotfire Analyst, Web Player and Business Authors, using Iron Python, JavaScript.
• 84-month experience in developing, documenting, maintaining end-to-end ETL data pipeline (preferably Informatica PowerCenter and/or IBI Data Migrator).
• 84-month MS SQL Server and T-SQL experience

• 84-month experience in Oracle PL/SQL development, including triggers, stored procedures, packages, and advanced query optimization, database design, and implementation.
• 48-month experience in Agile/scrum project management methodology.
• 60-month experience in automated testing, build and deployment tools (TFS, PowerShell, and Visual Build Pro)
• 60-month experience in VB.Net, C#, .Net TFS, Visual Studio, Azure DevOps
• 60-month experience in HTML, JavaScript, CSS