V Group Inc. · 1 week ago
Data Warehouse Architect
V Group Inc. is seeking a Data Warehouse Architect to support the New York State Insurance Fund (NYSIF). The role involves providing recommendations and guidance for new data marts, participating in DW/BI projects, and ensuring adherence to application development standards.
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. oETL processes. oBI Dashboards and reports
Develop and maintain Spotfire systems (including prediction models 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
Qualification
Required
72- months Data Modeling experience in designing underwriting, claims DataMarts, Data warehouse in Insurance industry (Workers' Compensation and disability)
72-months experience with developing maintaining predictive systems written R or Python using TIBCO Spotfire/TERR
72-months experience with TIBCO Spotfire Analyst, Web Player and Business Authors, using Iron Python, R, and Java Scripts
72-months experience in developing, documenting, maintaining end-to-end ETL data pipeline (Information Builder International “IBI” Data Migrator aka TIBCO Data Migrator)
72-months experience in Oracle PL/SQL development, including triggers, stored procedures, packages, and advanced query optimization, database design and implementation
72-months experience in Agile/scrum project management methodology
72-months experience in automated testing, build and deployment tools (TFS, PowerShell and Visual Build Pro)
72-months experience in development tools, such as: VS Code, Visual Studio Code, Visual Studio, Git, Azure, and TFS
72- months experience developing systems in workers' compensation, insurance for WC, DBL, PFL, PBM accounting and financial reporting using western and eastern method
Bachelor's Degree
Company
V Group Inc.
Since 1999, V Group Inc.
H1B Sponsorship
V Group Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (1)
2023 (3)
2022 (1)
2020 (1)
Funding
Current Stage
Growth StageCompany data provided by crunchbase