Job Description

Location: Hybrid in Pittsburgh, PA

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, strong proficiency in writing and 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