Job Description

Data Engineer (Contract) Reporting Instance (RI)

We are seeking a highly skilled Data Engineer with deep expertise in SQL performance tuning and Oracle database optimization to join our Reporting Instance (RI) team on a contract basis. This role will play a critical part in the Self-Managed Hosting (SMH) initiative, working closely with RI and Infrastructure teams to set up new environments, validate end-to-end data flows, and ensure high-performing, scalable data solutions.

This is an ideal opportunity for a hands-on engineer who thrives in solving complex data performance challenges at scale.

Engament Details

• Schedule : 8AM-5PM EST
• Location : 100% Remote
• Visa Requirements : H1B and other visa types OK as long as no sponsorship is needed.
• Start Date : ASAP
• References : Two references will be requested

Key Responsibilities

• Lead SQL performance tuning efforts for large-scale, complex queries in Oracle
• Design, create, and optimize materialized views to support reporting and downstream data consumption
• Analyze and improve query execution plans , indexing strategies, and data access patterns
• Support end-to-end environment setup and validation for RI as part of the SMH initiative
• Ensure data integrity, consistency, and performance across the entire data pipeline
• Troubleshoot and resolve performance bottlenecks, data issues, and batch failures
• Optimize ETL processes, batch jobs, and data refresh cycles
• Collaborate with Infrastructure teams on environment configuration and performance tuning in AWS
• Contribute to operational readiness, documentation, and knowledge transfer

Required Qualifications

• Strong expertise in Oracle SQL and PL/SQL , with a focus on performance tuning
• Proven experience in query optimization , including execution plan analysis and indexing strategies
• Hands-on experience designing and tuning materialized views (refresh strategies, performance impact, dependencies)
• Experience working with large-scale datasets and high-volume data environments
• Solid understanding of ETL pipelines and data validation techniques
• Strong troubleshooting and problem-solving skills in complex data environments

Preferred Skills

• Experience with partitioning strategies and parallel processing in Oracle
• Familiarity with batch scheduling and orchestration tools
• Exposure to data platforms supporting downstream reporting systems
• Experience with AWS Cloud
• Experience working in cross-functional environments

What We re Looking For

• A strong, hands-on engineer who can independently diagnose and solve performance issues
• Deep attention to detail with a focus on efficiency, scalability, and reliability
• Proactive mindset with ownership of problems end-to-end
• Ability to work in a fast-paced, operational environment
• Clear communication and collaboration skills

Job Tags

Similar Jobs