Senior Oracle Reports & ETL Developer — On-Site, 24/7 Support

vTech Solution; North Carolina; On-site; USD 100,000 - 140,000; Full time

Job summary

vTech Solution seeks a NC FAST Reports Developer to analyze, design, and maintain complex reports for the NC Families Accessing Services through Technology (NC FAST) system. You will work with Oracle databases, PL/SQL, and ETL processes to deliver accurate reporting for operations and decisions.

The role requires collaboration with stakeholders to gather requirements, optimize SQL queries, and ensure data integrity with validation and audit strategies.

Qualifications

• Minimum 5 years of experience with Oracle databases and Oracle Utilities.
• Minimum 5 years of PL/SQL scripting and relational database modeling.
• Experience with structured system development methodologies (minimum 5 years).
• Strong ability to build relationships and respond to customer needs independently (minimum 5 years).
• Experience organizing, prioritizing, and following detailed technical procedures (minimum 5 years).
• Experience with Business Intelligence tools such as Business Objects or BIRT (minimum 5 years).
• Experience with Agile development methodologies (Scrum, Kanban, or SAFe) (minimum 2 years).
• Data warehouse experience (minimum 2 years).

Responsibilities

• Analyze and identify reporting requirements for NC FAST Case Management System reports.
• Design, code, test, debug, and document data interfaces and reporting solutions.
• Develop and maintain complex SQL queries and data extracts involving large tables with CLOBS/XML data.
• Enhance existing reports and data extracts to meet evolving business needs.
• Gather and document requirements for new and modified reports and data extracts.
• Analyze operational performance metrics and develop reports and dashboards.
• Ensure quality and integrity of data extracts using validation and audit strategies.
• Provide 24x7 on-call support and participate in rotation schedules.
• Collaborate with business and technical teams to resolve operational issues.

Skills

Oracle DB

Oracle Utilities

PL/SQL

Relational modeling

SDLC procedures

Customer relations

Documentation

Business Objects

BIRT

Agile (Scrum/Kanban/SAFe)

Data warehousing

Tools

Power BI

Azure Synapse

Amazon RedShift

Tableau

BI tools

Oracle/ETL tools

Job description

vTech Solution seeks a NC FAST Reports Developer to analyze, design, and maintain complex reports for the NC Families Accessing Services through Technology (NC FAST) system. You will work with Oracle databases, PL/SQL, and ETL processes to deliver accurate reporting for operations and decisions.

The role requires collaboration with stakeholders to gather requirements, optimize SQL queries, and ensure data integrity with validation and audit strategies.