Information Technology Project Coordinator

PruTech Solutions, Inc.; New York (NY); On-site; USD 110,000 - 165,000; Full time

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

Skills

Real world delivery experience

Tools

MS Visio

Star Schema Modeling

Snowflake Modeling

Informatica

Business Objects XI

Oracle Reports

BM Cognos 10.2.2

Websphere

ESB / Message Broker

Eclipse

JIRA

Webservices

Oracle

Job description

Founded in 1998, PruTech is dedicated to problem-solving, creating solutions, and maintaining strong partnerships with its clients. PruTech serves a diverse list of clients in different industries from government to finance, retail, and manufacturing. PruTech has offices in New York City, Washington DC, North Carolina, and two nearshore offices in Mexico City and India.

With over 20 years of Information Technology and system integration experience, PruTech provides multiple ways to assist organizations with future technology requirements including:

• Project based system integration
• Custom software solutions
• Package implementations
• Consulting and advisory services
• Big data and analytics
• Nearshore and offshore services

Tasks & Duties

• Designing and Developing Software Systems
• Design, develop, and maintain Oracle 19c CARES DataMart and SQL Server database objects, ensuring optimal structure, performance, and scalability for both transactional and analytical systems
• Create and maintain critical operational and analytical reports (e.g., 24/7 Resource Room reports) to support agency decision-making
• Support and enhance key housing subsidy programs including applications that automate eligibility, budgeting, and document generation
• Design, implement, and maintain secure interagency data exchange processes, ensuring timely and accurate data sharing that directly supports client services
• Perform database performance tuning using advanced techniques (indexing, query optimization, execution plans) to ensure system efficiency and responsiveness
• Develop and support database services for .NET and Java-based applications, ensuring seamless integration with backend systems
• Implement and manage database security controls, including user roles, permissions, and data access policies to protect sensitive information
• Evaluate and recommend new database technologies, tools, and cloud solutions (AWS, Azure, Oracle Cloud) to improve system capabilities and scalability
• Build and maintain data warehouse components to support operational reporting, analytics, and long-term data strategy
• Analyzing User Requirements and Quality Assurance
• Collaborate with business stakeholders to gather, analyze, and document detailed requirements, ensuring alignment with operational needs and data security standards
• Evaluate current system functionality, identify gaps, and recommend enhancements to improve performance and usability
• Analyze and support system integrations across multiple agencies, ensuring data consistency and compliance
• Develop comprehensive test plans, test cases, and acceptance criteria based on business and technical requirements
• Support and coordinate User Acceptance Testing (UAT), ensuring solutions meet business expectations and quality standards
• Ensure all applications and changes comply with established quality assurance processes and audit requirements
• Perform core DBA functions, including database installation, configuration, schema design, performance monitoring, and deployment of database changes
• Provide ongoing maintenance and production support, including troubleshooting issues, applying fixes, and ensuring system stability
• Coordinate with development teams, infrastructure teams, and external agencies to resolve technical issues and support data exchanges
• Manage and enforce release management processes, ensuring all production changes are properly tested, approved, and deployed
• Support system migrations, upgrades, and implementation of new features or enhancements
• Create Design and Test Documentation
• Develop detailed system design documents, including technical specifications and data architecture diagrams
• Create conceptual, logical, and physical data models to support system development and maintenance
• Prepare process flow diagrams and documentation (using Visio) to clearly illustrate system logic and workflows
• Build business process mockups and data flow examples to help stakeholders understand system impacts
• Execute system, integration, and user acceptance testing for both UI and backend processes
• Prepare test protocols, results documentation, and audit-compliant reports to support final system validation

Required Skills

• A minimum of 6 years of experience with the following skill sets:
• Real world delivery experience
• MS Visio, Star Schema Modeling, Snow Flake Modeling
• Informatica 8, Business Objects X, XI, Oracle Reports, BM Cognos Version 10.2.2
• Websphere, ESB or Message Broker, Eclipse, JIRA, Webservice, and Oracle

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin.