Senior Oracle SQL Data Analyst (Onsite)
Location: Atlanta, GA
Work Arrangement: Onsite (Only qualified candidates located near the Atlanta, GA area will be considered.)
Position Summary
The Senior Oracle SQL Data Analyst is responsible for developing, maintaining, and supporting SQL solutions for operational reporting, research, executive decision-making, legislative reporting, and strategic initiatives. This role works extensively with large, normalized Oracle transactional databases, where approximately 70–80% of the work involves writing Oracle SQL and PL/SQL.
This is not a traditional Business Intelligence or dashboard development role. The ideal candidate will be able to independently analyze business requirements, identify the appropriate database tables and relationships, and develop SQL solutions from scratch without relying on pre-built analytical models or AI-generated SQL.
Note: Candidates must report onsite on Day 1 for orientation and equipment pickup. Equipment will not be shipped.
Key ResponsibilitiesOracle SQL Development
- Develop, maintain, and optimize complex Oracle SQL and PL/SQL programs
- Write simple and complex SQL queries from scratch against normalized Oracle transactional databases
- Create efficient, reusable, and well-documented SQL code
- Optimize SQL queries for performance and maintainability
Data Analysis & Reporting
- Analyze business requirements and translate them into SQL solutions
- Extract, validate, transform, and analyze operational data
- Support:
- Operational reporting
- Executive reporting
- Legislative reporting
- Research initiatives
- Grant reporting
- Key Performance Indicators (KPIs)
Database Automation
- Develop and maintain automated SQL processes
- Create and manage scheduled database jobs
- Maintain recurring data refresh processes
- Troubleshoot automated jobs and SQL processes
Database Design & Data Validation
- Analyze normalized relational database structures
- Determine appropriate:
- Tables
- Relationships
- Joins
- Business rules
- Validate data accuracy and troubleshoot data quality issues
Collaboration
- Work closely with business users to understand reporting requirements
- Present analytical findings to stakeholders
- Support Tableau dashboards and other data visualization initiatives as needed
Required Technical SkillsOracle SQL
- Oracle SQL development against transactional databases (5+ years)
- Complex SQL development, including:
- Joins
- Common Table Expressions (CTEs)
- Subqueries
- CASE statements
- Aggregate functions
- Analytic functions
Database Design
- Normalized relational database design (5+ years)
- Table relationships and database modeling
Database Automation
- SQL job scheduling (3+ years)
- Automated database processes
Data Analysis
- Translating business requirements into SQL solutions (3+ years)
- Operational reporting and data analysis (3+ years)
Preferred Technical SkillsOracle Development
- Oracle PL/SQL (3+ years), including:
- Procedures
- Functions
- Packages
- Views
SQL Performance
- SQL troubleshooting
- Query optimization
- Data validation (5+ years)
Reporting & Visualization
- Tableau or other data visualization tools
Industry Experience
- Criminal justice systems
- Large transactional database environments
Required Soft Skills
- Strong analytical and problem-solving skills
- Ability to independently translate business requirements into technical SQL solutions
- Excellent verbal and written communication skills
- Strong attention to detail and data accuracy
- Ability to work independently with limited supervision
- Strong documentation and organizational skills
Key Focus Areas
- Oracle SQL Development
- Oracle PL/SQL
- Complex SQL Query Development
- Normalized Relational Databases
- Transactional Database Analysis
- SQL Performance Optimization
- Operational Reporting
- Data Validation
- Database Automation
- Scheduled SQL Jobs
- Executive & Legislative Reporting
- Tableau Support
- Business Requirements Analysis
Work Arrangement
- Onsite position
- Only candidates located near Atlanta, GA will be considered
- Must be onsite on Day 1 for orientation and equipment pickup (equipment will not be shipped)
Pay: $40.00 - $42.00 per hour
Application Question(s):
- Are you currently located within commuting distance of Atlanta, GA, and able to work onsite starting on Day 1?
- How many years of professional experience do you have developing Oracle SQL against transactional databases?
- How confident are you writing complex Oracle SQL queries from scratch (without using visual query builders or AI-generated SQL)?
- Which of the following SQL features have you used professionally — Joins, Common Table Expressions (CTEs), Subqueries, CASE statements, Aggregate functions, or Analytic/Window functions?
- Do you have experience working with normalized Oracle relational databases and determining the appropriate tables, relationships, and joins to meet business requirements?
- How many years of experience do you have developing or maintaining Oracle PL/SQL objects (procedures, functions, packages, or views)?
- Have you developed or maintained scheduled SQL jobs, automated database processes, or recurring data refreshes?
- Which of the following best describes your experience — Operational reporting, Data validation, SQL performance tuning/query_optimization, KPI or executive reporting, or Legislative or regulatory reporting?
- Have you used Tableau or another data visualization tool to support reporting or analytics?
- This role requires developing SQL solutions directly against large transactional databases rather than primarily working with data warehouses or pre-built BI datasets. Does your experience align with this requirement?
Work Location: In person
