Senior Data Modeling Architect - DW, AI & BI Lead

Govserviceshub; New York (NY); On-site; USD 140,000 - 210,000; Full time

Job summary

Govserviceshub in New York is seeking a senior data warehouse consultant to advance the NYSIF Enterprise Data Warehouse, consolidating legacy data marts and eliminating duplications to create a single source of truth.

You will operationalize prediction models, build a data lake, and integrate financial transactions, audits, and reporting into the DW. The role also supports AI solutions, knowledge graphs, data governance, and BI dashboards.

Qualifications

• 14+ years of experience in data warehousing and DW/DM design.

Responsibilities

• Provide recommendations and implement new data marts; consolidate existing ones.
• Participate in DW/BI projects through the full project lifecycle.
• Establish best practices for DW/DM data model design.
• Create and maintain documentation for DW/DM, ETL.
• Plan, modify, test and implement source system extraction, ETL, and BI dashboards (R, Python).
• Develop and maintain Spotfire systems and automation services.

Skills

Data Modeling

DW/BI Architecture

Project Management

SDLC & IT Governance

Agile/Scrum

Tools

TIBCO Spotfire

DataMigrator

R

Python

PL/SQL

T-SQL

Oracle

VSCode

Git

Azure

TERR

IronPython

JavaScript

WebPlayer

Job description

Govserviceshub in New York is seeking a senior data warehouse consultant to advance the NYSIF Enterprise Data Warehouse, consolidating legacy data marts and eliminating duplications to create a single source of truth.

You will operationalize prediction models, build a data lake, and integrate financial transactions, audits, and reporting into the DW. The role also supports AI solutions, knowledge graphs, data governance, and BI dashboards.