Energy Jobline ZR
Data Analytics & ETL Solutions Architect in New York
Energy Jobline ZR, New York, New York, us, 10261
Duration: 30 Month Contract
Hybrid: 50% onsite in New York, NY
We are looking for a consultant to continue the effort of building the NYSIF Enterprise Data Warehouse, consolidating multiple existing legacy data marts with the goal of eliminating unnecessary duplications and establishing a single source of truth. The consultant will focus on creating a dashboard to facilitate claims/underwriting predictions, operationalize prediction models created by data scientists, implement a data lake, and integrate financial transactions, cash flows, external auditors’ requests, and accounting reporting into the data warehouse. The consultant will also evaluate, recommend, and implement AI solutions, knowledge graph, data governance, and data management solutions.
Responsibilities
Provide recommendations, guidance, and actual implementation for new data marts, as well as improving and consolidating existing data marts.
Participate and contribute to data warehouse / business intelligence projects throughout the project lifecycle.
Establish written best practices, procedures and generally provide guidance on data warehouse / data model design.
Create and maintain up‑to‑date documentation for all supported data warehouse, data model, and ETL processes.
Plan, create, modify, maintain, test and implement code in support of source system extraction processes, ETL processes, and BI dashboards and reports (R, Python).
Develop and maintain Spotfire systems (including prediction models written in R, TERR and automation services).
Automate source system data extraction processes and data loading of the data warehouse.
Operationalize prediction models.
Adhere to NYSIF’s application development standards, including project management methodology, SDLC, Enterprise Architecture standards, and IT governance processes; support BI data warehouse using TIBCO Spotfire, Information Builders software Data Migrator.
Qualifications 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
Desired Qualifications
84 months Data Modeling experience in designing underwriting, claims DataMarts, and data warehouse in the insurance industry (Workers’ Compensation).
84 months of experience with developing and maintaining predictive systems written in R or Python using TIBCO Spotfire/TERR.
84 months experience with TIBCO Spotfire Analyst, Web Player and Business Authors, using IronPython, R, and JavaScripts.
84 months of experience in developing, documenting, and maintaining an end‑to‑end ETL data pipeline (IBI Data Migrator, aka TIBCO Data Migrator).
84 months of experience in Oracle PL/SQL development, including triggers, stored procedures, packages, and advanced query optimization, database design, and implementation.
84 months of experience in Agile/Scrum project management methodology.
84 months of experience in automated testing, build and deployment tools (TFS, PowerShell and Visual Build Pro).
84 months experience in development tools such as VS Code, Visual Studio, Git, Azure, and TFS.
84 months experience developing systems in workers’ compensation, insurance for WC, DBL, PFL accounting and financial reporting using western and eastern method.
Bachelor's Degree.
If you are interested in applying for this job, please press the Apply Button and follow the application process. Energy Jobline wishes you the very best of luck in your next career move.
#J-18808-Ljbffr
We are looking for a consultant to continue the effort of building the NYSIF Enterprise Data Warehouse, consolidating multiple existing legacy data marts with the goal of eliminating unnecessary duplications and establishing a single source of truth. The consultant will focus on creating a dashboard to facilitate claims/underwriting predictions, operationalize prediction models created by data scientists, implement a data lake, and integrate financial transactions, cash flows, external auditors’ requests, and accounting reporting into the data warehouse. The consultant will also evaluate, recommend, and implement AI solutions, knowledge graph, data governance, and data management solutions.
Responsibilities
Provide recommendations, guidance, and actual implementation for new data marts, as well as improving and consolidating existing data marts.
Participate and contribute to data warehouse / business intelligence projects throughout the project lifecycle.
Establish written best practices, procedures and generally provide guidance on data warehouse / data model design.
Create and maintain up‑to‑date documentation for all supported data warehouse, data model, and ETL processes.
Plan, create, modify, maintain, test and implement code in support of source system extraction processes, ETL processes, and BI dashboards and reports (R, Python).
Develop and maintain Spotfire systems (including prediction models written in R, TERR and automation services).
Automate source system data extraction processes and data loading of the data warehouse.
Operationalize prediction models.
Adhere to NYSIF’s application development standards, including project management methodology, SDLC, Enterprise Architecture standards, and IT governance processes; support BI data warehouse using TIBCO Spotfire, Information Builders software Data Migrator.
Qualifications 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
Desired Qualifications
84 months Data Modeling experience in designing underwriting, claims DataMarts, and data warehouse in the insurance industry (Workers’ Compensation).
84 months of experience with developing and maintaining predictive systems written in R or Python using TIBCO Spotfire/TERR.
84 months experience with TIBCO Spotfire Analyst, Web Player and Business Authors, using IronPython, R, and JavaScripts.
84 months of experience in developing, documenting, and maintaining an end‑to‑end ETL data pipeline (IBI Data Migrator, aka TIBCO Data Migrator).
84 months of experience in Oracle PL/SQL development, including triggers, stored procedures, packages, and advanced query optimization, database design, and implementation.
84 months of experience in Agile/Scrum project management methodology.
84 months of experience in automated testing, build and deployment tools (TFS, PowerShell and Visual Build Pro).
84 months experience in development tools such as VS Code, Visual Studio, Git, Azure, and TFS.
84 months experience developing systems in workers’ compensation, insurance for WC, DBL, PFL accounting and financial reporting using western and eastern method.
Bachelor's Degree.
If you are interested in applying for this job, please press the Apply Button and follow the application process. Energy Jobline wishes you the very best of luck in your next career move.
#J-18808-Ljbffr