Sql Remote- & Homeoffice Jobs in pearl-river ∙ Seite 1

Job Title: Senior Systems Architect
Location: Remote (occasional in-person workshops/meetings required)
Employment Type: Full-Time / Contract

About Us:
DMV IT Service LLC is a trusted IT consulting firm founded in 2020. We specialize in optimizing IT infrastructure and providing expert guidance to empower businesses to achieve their technology goals. Our services span system administration, cybersecurity, networking, and IT operations. With a client-first approach, we ensure long-term success for our clients through innovative solutions and industry best practices.

Job Purpose:
We are seeking a highly experienced and detail-oriented Senior Systems Architect to lead the design, development, and optimization of enterprise systems supporting operational, financial, and productivity reporting. This role is pivotal in aligning technology solutions with business processes across material management, work management, and accounting functions. The architect will play a hands-on leadership role in system design, integration, and migration initiatives to ensure business-critical applications are reliable, scalable, and compliant.

Requirements

1. Architect and implement systems for Material Requisitioning and Material Variance Reporting to ensure accurate inventory tracking and reconciliation.
2. Design and support Productivity Reporting frameworks within Work Management Systems, enabling real-time performance insights.
3. Develop and maintain Fiscal Calendar Management tools for financial planning and reporting.
4. Lead initiatives for Unit of Property Identification, ensuring compliance with asset tracking and capitalization standards.
5. Build Activity-Based Accounting models, including cost driver derivation and allocation methodologies.
6. Create systems for Calculating and Reporting Units of Work, integrating operational metrics with financial outcomes.
7. Enable Crew-Based Labor Reporting, capturing team-level labor distribution and productivity.
8. Lead workflow migration and functional data mapping activities.
9. Collaborate with business stakeholders, IT leadership, and vendors to align architecture with enterprise strategy.

Technical Skills – Must Have:

• Advanced knowledge of SQL and Stored Procedures.
• Proficiency in Cobol/370, CICS TS, DB2 v12.1.
• Strong experience in data mapping and building workflow migration solutions.
• Expertise in QMF reporting, SPUFI, File-Manager, CA Intertest.
• Proficiency in SAR View, VSAM, DFSORT, IDCAMS.
• Hands-on experience with SCANA applications and developing integration modules for work management.

Technical Skills – Nice to Have:

• Knowledge of CICS Web Interface, Web Services, and API Management.
• Familiarity with MQ or other message queuing technologies.
• Proficiency with PowerPoint and Visio for documentation and presentations.

Soft Skills:

• Strong problem-solving and analytical abilities.
• Ability to translate complex business requirements into technical solutions.
• Excellent communication skills (verbal, written, and presentation).
• Strong leadership and collaboration skills across cross-functional and remote teams.