Description

Key Responsibilities:
• Develop, optimize, and maintain complex Oracle SQL and PL/SQL scripts.
• Write queries from scratch against normalized transactional databases.
• Analyze business requirements and identify appropriate tables, joins, relationships, and business rules.
• Extract, validate, transform, and analyze data for operational, research, grant, and legislative reporting.
• Automate scheduled database jobs and recurring data refresh processes.
• Troubleshoot query performance, data inconsistencies, and automated job failures.
• Maintain reusable, efficient, and well-documented SQL code.
• Support KPI reporting, executive requests, and recurring operational reports.
• Collaborate with business stakeholders to clarify requirements and communicate findings.
• Assist with Tableau dashboards and data visualization as needed.

Required Qualifications:
• 6+ years of experience in SQL development, data analysis, or a related field.
• Strong hands-on experience with Oracle SQL and PL/SQL.
• Proven ability to develop complex queries independently against normalized transactional databases.
• Strong understanding of database structures, table relationships, joins, data validation, and query optimization.
• Experience automating SQL processes, scheduling database jobs, and troubleshooting data issues.
• Ability to translate business requirements into accurate and efficient SQL solutions without relying primarily on prebuilt analytical datasets or visual query tools.
• Strong analytical, problem-solving, documentation, and communication skills.
• Local candidates only. Onsite interviews are required, and the selected candidate must report onsite on Day 1 for orientation and equipment pickup. Equipment will not be shipped.

Preferred Certifications:
• No specific certification is required.
• Oracle Database or SQL-related certifications are a plus

Key Skills

Education

Bachelor's degree