We are seeking a Senior Data Warehouse Engineer, Modernization and Performance to lead critical initiatives focused on modernizing data warehouse systems, optimizing performance, and improving overall data process efficiency. This role requires deep expertise in database programming, performance tuning, and enterprise job scheduling , with a strong focus on re-platforming legacy systems to scalable, high-performing architectures. You will be responsible for driving architectural evolution while ensuring operational excellence and reliability across data environments.

Key Responsibilities

• Lead and execute data warehouse modernization projects, re-platforming legacy components to more scalable, high-performance architectures.
• Conduct comprehensive performance analysis of warehouse processes, ETL/ELT jobs, and SQL queries to identify bottlenecks and implement improvements.
• Design, develop, and maintain data models, ETL/ELT frameworks, and integration solutions to support enterprise data initiatives.
• Develop and optimize SQL and PL/SQL scripts, stored procedures, and functions for efficient data manipulation and transformation.
• Build and maintain robust batch processes using UNIX/Linux Shell Scripting for data automation, loading, and operational monitoring.
• Utilize Control-M (or similar enterprise job scheduling tools) to design, manage, and monitor complex workflows, ensuring performance and reliability.
• Perform root cause analysis (RCA) for performance and system failures, implementing long-term corrective measures.
• Define and enforce data warehouse best practices, coding standards, and architectural patterns to ensure consistency and scalability.
• Create and maintain detailed documentation for architecture, modernization processes, and performance improvements.

Technical Profile

• Minimum 5+ years of experience in data warehousing with a strong focus on modernization and performance optimization.
• Expert-level proficiency in SQL for writing complex, optimized queries.
• Advanced experience with PL/SQL for developing efficient database applications and transformations in Oracle or similar environments.
• Shell Scripting (UNIX/Linux) expertise for job control, automation, and process orchestration.
• Proven experience with Control-M or equivalent enterprise job schedulers for managing complex batch processes.
• Strong understanding of data warehouse architecture, dimensional modeling, and performance tuning.
• Excellent analytical and problem-solving skills, with the ability to identify and implement scalable solutions.
• Strong collaboration and communication skills for working with cross-functional technical and business teams.

Functional Profile

• Strategic thinker with a performance-driven mindset and strong attention to technical detail.
• Capable of leading modernization efforts and influencing architectural decisions.
• Skilled in cross-functional communication to align technical outcomes with business goals.
• Experienced in maintaining operational stability while driving transformation projects.
• Comfortable managing workloads in fast-paced, production-critical environments.

Skills Summary Core Expertise: Data warehouse modernization, system performance optimization, data modeling, ETL/ELT design, Oracle database architecture.

Languages & Frameworks SQL, PL/SQL, Shell Scripting (UNIX/Linux), Python, Perl

Database & Job Scheduling Oracle, Control-M, enterprise schedulers, SQL performance tuning, query optimization.

Automation & Scripting Tools Shell, Python, Perl, automation scripts, job orchestration.

Version Control & Management Tools Git, JIRA, ServiceNow (incident and change management).

Soft Skills Analytical thinking, process ownership, technical leadership, stakeholder communication, documentation discipline, problem-solving, adaptability.

The pay range that the employer in good faith reasonably expects to pay for this position is $32.39/hour - $50.61/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis. Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.