Description

You will develop, maintain, and optimize complex Oracle SQL and PL/SQL programs to support operational reporting, research, and executive requests.

This role is on-site.

Responsibilities

• Write and optimize complex SQL queries against normalized Oracle transactional databases.
• Analyze business requirements to determine necessary tables, relationships, joins, and business rules.
• Extract, validate, transform, and analyze operational data for reporting and research initiatives.
• Develop and maintain automated SQL processes, scheduled database jobs, and recurring data refreshes.
• Troubleshoot SQL scripts, automated jobs, and data quality issues while creating reusable, well-documented code.

Required Skills

• 5+ years of experience writing complex SQL (joins, CTEs, subqueries, CASE, aggregate and analytic functions).
• 5+ years of Oracle SQL development against transactional databases.
• 5+ years of experience with normalized relational database design and table relationships.
• 3+ years of experience with SQL job scheduling and automated database processes.
• 3+ years of experience translating business requirements into SQL solutions.
• 3+ years of experience in operational reporting and data analysis.
• Bachelor's degree.

Preferred Skills

• 3+ years of experience with Oracle PL/SQL (procedures, functions, packages, views).
• 5+ years of experience with SQL troubleshooting, query optimization, and data validation.
• Experience with Tableau or other data visualization software.

Key Skills

Education

Bachelor's degree