i-Link Solutions
Join to apply for the
Systems Architect
role at
i-Link Solutions Job Title:
Systems Architect - Expert Task ID: HBITS-07-14359 Position Duration: 30 Months Client: State of NY Agency: New York State Insurance Fund Please call
(703) 466-0951 | (571) 351-1868 | (703) 348-3018
or email at nysreqs@ilinksolutions.com Description
The duties of the consulting resource 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 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 Adhere to NYSIF\'s application development standards, including project management methodology, SDLC, Enterprise Architecture standards and the IT governance process. Support the BI Data Warehouse using TIBCO Spotfire and Information Builders Data Migrator Mandatory Qualifications
84 months Data Modeling experience in designing underwriting, claims DataMarts, Data warehouse in Insurance industry (Workers\' Compensation and disability) 84 months experience with developing 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 Iron Python, R, and JavaScript 84 months experience in developing, documenting, maintaining end-to-end ETL data pipeline (Information Builder International \"IBI\" Data Migrator aka TIBCO Data Migrator) 84 months experience in Oracle PL/SQL development, including triggers, stored procedures, packages, and advanced query optimization, database design and implementation 84 months experience in Agile/scrum project management methodology 84 months 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 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 Disclaimer:
i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability
#J-18808-Ljbffr
Systems Architect
role at
i-Link Solutions Job Title:
Systems Architect - Expert Task ID: HBITS-07-14359 Position Duration: 30 Months Client: State of NY Agency: New York State Insurance Fund Please call
(703) 466-0951 | (571) 351-1868 | (703) 348-3018
or email at nysreqs@ilinksolutions.com Description
The duties of the consulting resource 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 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 Adhere to NYSIF\'s application development standards, including project management methodology, SDLC, Enterprise Architecture standards and the IT governance process. Support the BI Data Warehouse using TIBCO Spotfire and Information Builders Data Migrator Mandatory Qualifications
84 months Data Modeling experience in designing underwriting, claims DataMarts, Data warehouse in Insurance industry (Workers\' Compensation and disability) 84 months experience with developing 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 Iron Python, R, and JavaScript 84 months experience in developing, documenting, maintaining end-to-end ETL data pipeline (Information Builder International \"IBI\" Data Migrator aka TIBCO Data Migrator) 84 months experience in Oracle PL/SQL development, including triggers, stored procedures, packages, and advanced query optimization, database design and implementation 84 months experience in Agile/scrum project management methodology 84 months 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 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 Disclaimer:
i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability
#J-18808-Ljbffr