Oracle Data Warehouse Analyst
Expert In Recruitment SolutionsCanonsburg, PA
Automate your job search with Sonara.
Submit 10x as many applications with less effort than one manual application.1
Reclaim your time by letting our AI handle the grunt work of job searching.
We continuously scan millions of openings to find your top matches.
Overview
Remote
On-site
Job Description
Title- Oracle Data Warehouse Analyst Location: Hybrid 3 days on-site per week required in Pittsburgh, PA Job Type : 12 Month Contract with possible extensions The company has an immediate need for an Oracle Global Data Warehouse Senior Analyst. Ideal 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. Responsibilities: In 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 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 Education :
- Bachelors degree- Preferred
- Minimum 5 years of experience in Information Technology
- SQL, PL/SQL - complex query writing/writing queries from scratch- 3+ years
- Data Warehousing/ETL Process support- 2+ years
- Oracle ERP module exposure (Finance, Project Accounting, Procurement, Order-to-Cash, Procure-to-Pay)
- Oracle R12 (on prem), Oracle 19c database, Linux experience
- DBA skill knowledge: performance tuning, data modeling, database analysis
- Project leadership experience- 2+ years (Preferred)
Automate your job search with Sonara.
Submit 10x as many applications with less effort than one manual application.
FAQs About Oracle Data Warehouse Analyst Jobs at Expert In Recruitment Solutions
What is the work location for this position at Expert In Recruitment Solutions?
This job at Expert In Recruitment Solutions is located in Canonsburg, PA, according to the details provided by the employer. Some roles may also include multiple work locations depending on the requirement.
What pay range can candidates expect for this role at Expert In Recruitment Solutions?
Employer has not shared pay details for this role.
What employment applies to this position at Expert In Recruitment Solutions?
The employer has not provided this information. This may be discussed during the hiring process.
What is the process to apply for this position at Expert In Recruitment Solutions?
You can apply for this role at Expert In Recruitment Solutions either through Sonara's automated application system, which helps you submit applications 10X faster with minimal effort, or by applying manually using the direct link on the job page.