IT Project Coordinator: Data & Systems

PruTech Solutions, Inc.

New York (NY)

On-site

USD 110,000 - 165,000

Full time

2 days ago

Be an early applicant

Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

Job summary

PruTech Solutions, Inc. is seeking a senior data integration and data warehousing specialist in New York. You will design and maintain Oracle and SQL Server data stores, develop critical reports, and implement secure interagency data exchange processes.

The role requires 6+ years of delivery experience with ETL tools, BI suites, and middleware. You will collaborate with business units to ensure scalable, auditable data architecture and performance across systems.

Qualifications

Minimum 6 years of experience in data integration, warehousing, and reporting
Proficient in dimensional modeling using star/snowflake schemas
Experience with ETL tools (Informatica) and BI suites (Cognos/Business Objects)
Knowledge of Oracle DB objects, reports, and integration patterns
Exposure to middleware (WebSphere/ESB) and data exchange across agencies

Responsibilities

Design, develop, and maintain Oracle 19c CARES DataMart and SQL Server objects
Create and maintain operational and analytical reports to support decision making
Develop data exchange processes across multiple agencies ensuring data security and accuracy
Perform database performance tuning and optimize queries for latency and scalability
Build and support data warehouse components for reporting and analytics
Coordinate with stakeholders and QA to ensure requirements are met and documented