Oracle Global Data Warehouse Systems Analyst

LHH; Pittsburgh (Allegheny County); Hybrid; USD 143,270,000 - 157,597,000; Full time

Benefits offered by this job

medical

dental

vision

life insurance

short‑term disability

additional voluntary benefits

EAP program

commuter benefits

401K plan

Our program provides employees theflex

Available paid leave may include PaidS

Job summary

LHH in Pittsburgh, PA (Hybrid) seeks a Systems Analyst II for Oracle Global Data Warehouse. The role requires hands-on SQL, data warehouse expertise, and ETL experience within a hybrid work model.

You will collaborate with cross-functional teams, support Oracle Data Warehouse solutions, and lead offshore staff to deliver timely, high-quality upgrades and enhancements.

Qualifications

• Bachelor's degree from an accredited institution.
• Minimum of 5 years of experience in Information Technology.
• Strong proficiency in writing and executing SQL.
• Working knowledge of Data Warehousing concepts.
• Working knowledge of ETL processes.
• Understanding of Data Security concepts.
• Experience investigating and resolving production support issues.
• Strong analytical, troubleshooting, and problem-solving skills.
• Demonstrated ability to take ownership and independently drive technical issues to resolution.
• Strong communication skills and ability to work with technical teams, business users, management, and vendors.
• Must be legally authorized to work in the United States. Visa sponsorship is not available.

Responsibilities

• Investigate, troubleshoot, and resolve complex production support issues.
• Write, execute, optimize SQL queries.
• Support Oracle Global Data Warehouse solutions and ETL processes.
• Coordinate technical support activities across infrastructure, application, database, and development teams.
• Lead offshore technical teams and ensure deliverables are completed accurately and on time.
• Oversee deployments, upgrades, and technology expansions.
• Analyze stored procedures and troubleshoot data and system issues.
• Collaborate with DBAs and technical teams on database performance tuning.
• Support data pipelines feeding reporting and analytical applications.
• Understand business processes and data requirements with finance and procurement teams.
• Drive process improvement and project planning.

Skills

SQL

Data Warehousing

ETL

Problem solving

Education

Bachelor's degree

Tools

Oracle EBS

Oracle ERP

Oracle R12/12.2

Oracle 19c

Linux

Power BI

Microsoft SQL Server

Hyperion

Job description

LHH is seeking a Systems Analyst II: Oracle Global Data Warehouse in Pittsburgh, PA (Hybrid)

Job Title: Systems Analyst II: Oracle Global Data Warehouse

Job Location: Pittsburgh, PA (Hybrid)

Pay Range: $50 - $55/hour

Schedule: Eastern Hours | Corporate: Hybrid – Monday, Wednesday & Thursday onsite | Plant location: Monday–Friday onsite

Duties And Responsibilities

• Investigate, troubleshoot, and resolve complex production support issues across data warehouse, applications, and infrastructure environments
• Write, execute, optimize, and enhance complex SQL queries
• Support Oracle Global Data Warehouse solutions and ETL processes
• Coordinate technical support activities across infrastructure, application, database, and development teams
• Lead and coordinate offshore technical teams, providing direction, oversight, quality control, and ensuring deliverables are completed accurately and on time
• Oversee deployments, system enhancements, customizations, upgrades, and technology expansions
• Support legacy system integrations and enhancements within the Oracle Data Warehouse environment
• Analyze stored procedures, troubleshoot data and system issues, and make recommendations for performance improvements
• Collaborate with DBAs and technical teams on database performance tuning and optimization
• Support data pipelines feeding Oracle Hyperion, Microsoft SQL Server, Power BI, and other reporting and analytical applications
• Work with Finance, Accounts Receivable, Credit, Procurement, and other business teams to understand business processes and data requirements
• Drive process improvement and optimization initiatives and recommend system enhancements or alternative solutions
• Support project planning, requirements gathering, schedule tracking, risk identification, and stakeholder communication
• Ensure system development, change control, compliance, and support standards are followed
• Maintain support documentation including ITIL artifacts, CMDB records, knowledge base articles, architecture diagrams, audit documentation, and disaster recovery materials
• Maintain awareness of cybersecurity vulnerabilities and support efforts to ensure applications and infrastructure remain secure and compliant
• Build and maintain strong working relationships with business users, management, technical teams, and third-party vendors

Success Factors

• Strong hands‑on SQL skills with the ability to write complex queries from scratch
• Strong understanding of Data Warehousing and ETL processes
• Ability to independently investigate and troubleshoot complex production and data issues
• Strong analytical and problem‑solving skills with demonstrated ownership and accountability
• Experience supporting enterprise applications and Data Warehouse environments
• Ability to identify issues proactively and catch and correct errors early
• Experience leading or coordinating offshore technical teams
• Strong understanding of database structures, stored procedures, and performance tuning
• Ability to collaborate effectively with DBAs, developers, business users, and infrastructure teams
• Understanding of Finance, Procurement, Accounts Receivable, Order‑to‑Cash, and Procure‑to‑Pay business processes
• Strong verbal and written communication skills
• Ability to manage multiple priorities and work independently with minimal guidance
• Solid understanding of SDLC, change management, deployments, and system upgrades

Required Qualifications

• Bachelor's degree from an accredited institution
• Minimum of 5 years of experience in Information Technology
• Strong proficiency in writing and executing SQL
• Working knowledge of Data Warehousing concepts
• Working knowledge of ETL processes
• Understanding of Data Security concepts
• Experience investigating and resolving production support issues
• Strong analytical, troubleshooting, and problem‑solving skills
• Demonstrated ability to take ownership and independently drive technical issues to resolution
• Strong communication skills and ability to work with technical teams, business users, management, and vendors
• Must be legally authorized to work in the United States. Visa sponsorship is not available

Preferred Qualifications

• 2+ years of experience supporting Data Warehouse solutions
• Experience with Oracle EBS and Oracle ERP modules
• Knowledge of Finance, Project Accounting, Procurement, Order‑to‑Cash, and Procure‑to‑Pay processes
• Experience with Oracle R12 / 12.2
• Experience with Oracle 19c databases
• Strong PL/SQL and SQL skills
• Working knowledge of Linux environments
• Experience with database performance tuning and stored procedure analysis
• Experience supporting ETL pipelines and integrations
• Experience with Hyperion, Microsoft SQL Server, Power BI, or other reporting/data visualization tools
• Experience leading or coordinating offshore technical teams
• Experience working in a project team environment
• Strong leadership, organizational, and stakeholder management skills

• medical
• dental
• vision
• life insurance
• short‑term disability
• additional voluntary benefits
• EAP program
• commuter benefits
• 401K plan
• Our program provides employees the flexibility to choose the type of coverage that meets their individual needs.
• Available paid leave may include Paid Sick Leave, where required by law; any other paid leave required by Federal, State, or local law; and Holiday pay upon meeting eligibility criteria.

Equal Opportunity Employer/Veterans/Disabled

To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to https://www.lhh.com/us/en/candidate-privacy

• The California Fair Chance Act
• Los Angeles City Fair Chance Ordinance
• Los Angeles County Fair Chance Ordinance for Employers