We are seeking an experienced Senior Oracle SQL Analyst to join a dynamic team supporting operational reporting, research, executive decision-making, legislative reporting, and strategic initiatives.
⚠️ Important: This is a highly technical SQL-focused role, not a traditional BI or Dashboard Development position. Approximately 70-80% of the work involves hands-on Oracle SQL and PL/SQL development against large transactional databases.
Required Skills & Experience
✅ 5+ years of Oracle SQL development against transactional databases
✅ 5+ years writing complex SQL queries (Joins, CTEs, Subqueries, CASE statements, Aggregate & Analytic Functions)
✅ 5+ years working with normalized relational database design and table relationships
✅ 3+ years translating business requirements into SQL solutions
✅ 3+ years developing and maintaining SQL job scheduling and automated database processes
✅ 3+ years in operational reporting and data analysis
Highly Desired
⭐ 3+ years of Oracle PL/SQL (Procedures, Functions, Packages, Views)
⭐ 5+ years of SQL troubleshooting, query optimization, and data validation
⭐ Experience with Tableau or other data visualization tools
⭐ Experience working within criminal justice or other large transactional database environments
Key Responsibilities
🔹 Develop, maintain, and optimize complex Oracle SQL and PL/SQL programs
🔹 Write SQL queries from scratch against normalized Oracle transactional databases
🔹 Analyze business requirements and identify appropriate tables, relationships, joins, and business rules
🔹 Extract, validate, transform, and analyze operational data for reporting and research
🔹 Develop and maintain automated SQL jobs and recurring data refresh processes
🔹 Troubleshoot SQL scripts, automated jobs, and data quality issues
🔹 Support KPIs, operational reporting, legislative reporting, and research initiatives
🔹 Collaborate with business users and communicate analytical findings
🔹 Support Tableau dashboards and data visualization projects as needed
Additional Notes
📌 In-Person Interviews Only
📌 Candidate must report onsite on Day 1 for orientation and equipment pickup
📌 Equipment will not be shipped
📌 Opportunity available for extensions
Never miss an opportunity! Create an alert based on the job you applied for.
