ORACLE GLOBAL DATA WAREHOUSE ANALYST - HYBRID

The A.C.Coy Company; Pittsburgh (Allegheny County); Hybrid; USD 90,000 - 130,000; Full time

Job summary

The A.C.Coy Company has an immediate opening for an Oracle Data Warehouse Analyst. Ideal candidates must have a Bachelor's degree from an accredited institution, 5+ years of information technology experience, 2+ years of data warehousing in an Oracle data warehouse and strong proficiency in writing/executing PL/SQL.

Location is Hybrid in Pittsburgh, PA or Cleveland, OH, with responsibilities spanning system upgrades, security, project coordination, and cross-team collaboration across IT and

Qualifications

• Bachelor's degree from an accredited institution.
• 5+ years Information Technology experience.
• 2+ years data warehousing in an Oracle data warehouse.
• Strong proficiency in writing/executing PL/SQL.
• Exposure to Oracle ERP modules (Finance, Project Accounting, Procurement) preferred.

Responsibilities

• Establish and maintain effective relationships with leadership, customers, and 3rd party vendors.
• Oversee deployments of customizations and enhancements; ensure change control standards and compliance.
• Coordinate and assist in investigating and resolving support issues across IT teams.
• Participate in system upgrades, deployments, and technology expansions.
• Preserve and improve cybersecurity posture by keeping applications and their infrastructure up to date.
• Manage small to large-scale projects with stakeholders; plan requirements, track schedules, and monitor budgets.
• Lead discovery and implementation of process improvements across areas of responsibility.
• Collaborate with IT Business Architect to define and maintain application roadmaps.
• Maintain ITIL artifacts (CMDB and support KB articles), architecture diagrams, audit and disaster recovery docs.

Skills

PL/SQL

Data Warehousing

Oracle ERP

ITIL

Project Management

Education

Bachelor's degree

Tools

Oracle Database

Job description

Overview

Location: Hybrid in Pittsburgh, PA or Cleveland, OH

Job Type: Full Time / Permanent

Work Authorization: No Sponsorship

The A.C.Coy company has an immediate opening for an Oracle Data Warehouse Analyst. Ideal candidates must have a Bachelors degree from an accredited institution, 5+ years of experience in Information Technology, 2+ years of data warehousing in an Oracle data warehouse and strong proficiency in writing/executing PL/SQL.

Responsibilities

• Establish and maintain an effective working relationship across the organization, with leadership, customers, and 3rd party vendors
• Oversee the deployment of customizations and enhancement requests and provide guidance to the developer teams. Ensure that all system development, change control standards and compliance processes are followed
• Coordinate and assist in investigating and resolving support issues, technical work across various infrastructure and application support teams
• Participate in and support system upgrades, deployments, and technology expansions
• Preserve and improve the cybersecurity posture by keeping the applications and their infrastructure up to date
• Manage small to large-scale projects working with stakeholders to – plan requirements, manage and track project schedules, monitor budgets, identify risks, and communicate clearly with partners from across the company
• Lead the discovery, planning and implementation of process improvements in individual or cross-functional areas of responsibilities for continuous optimization of support and testing
• Collaborate with IT Business Architect to define and maintain application roadmaps
• Maintain ITIL artifacts (CMDB and support KB articles), architecture diagrams, audit, disaster recovery and various support documentations
• Pursue continuous learning consistent with the movement in the job requirements and changes in technology

Qualifications

Education:

• Bachelor's degree from an accredited institution - Required

Experience Required:

• Information Technology experience - 5+ years
• PL/SQL - writing and executing - strong proficiency
• Data Warehousing in an Oracle data warehouse - 2+ years
• Exposure or working knowledge of Oracle ERP modules - Finance, Project Accounting, Procurement - Preferred
• Project Management experience- Preferred