Oracle Data Warehouse Analyst

Oracle Data Warehouse AnalystHybrid – 3 days on-site per week required in Pittsburgh, PA12 Month Contract with possible extensionsThe Company Has An Immediate Need For An Oracle Global Data Warehouse Senior AnalystIdeal candidates must have 5+ years of IT experience, strong proficiency in writing and executing SQL queries (complex and from scratch), 2+ years of experience supporting data warehousing / ETL processes and project leadership experience.ResponsibilitiesIn this role you will act as a liaison to Client's businesses and various customer groups as well as coordinate and lead the offshore teams in the support of the Oracle Global Data Warehouse which enables reporting consistency across Oracle, Hyperion, and Microsoft SQL Server / Power BI analytical applications that serve multiple finance and procurement functions. Major activities/Key challenges:Establish and maintain an effective working relationship across the organization, with leadership, customers, and 3rd party vendorsOversee 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 followedCoordinate and assist in investigating and resolving support issues, technical work across various infrastructure and application support teamsParticipate in and support system upgrades, deployments, and technology expansionsPreserve and improve the cybersecurity posture by keeping the applications and their infrastructure up to dateManage 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 companyLead the discovery, planning and implementation of process improvements in individual or cross-functional areas of responsibilities for continuous optimization of support and testingCollaborate with IT Business Architect to define and maintain application roadmapsMaintain ITIL artifacts (CMDB and support KB articles), architecture diagrams, audit, disaster recovery and various support documentationsPursue continuous learning consistent with the movement in the job requirements and changes in technologyEducationBachelors degree - PreferredExperience RequiredMinimum 5 years of experience in Information TechnologySQL, PL/SQL - complex query writing/writing queries from scratch - 3+ yearsData Warehousing/ETL Process support - 2+ yearsOracle ERP module exposure (Finance, Project Accounting, Procurement, Order-to-Cash, Procure-to-Pay)Oracle R12 (on prem), Oracle 19c database, Linux experienceDBA skill knowledge: performance tuning, data modeling, database analysisProject leadership experience - 2+ years (Preferred) RIT Solutions