Sr. Oracle SQL Analyst

Atlanta, GA, US • Posted 12 hours ago • Updated 12 hours ago
Contract Corp To Corp
Contract W2
12 Months
On-site
Depends on Experience
Fitment

Dice Job Match Score™

👤 Reviewing your profile...

Job Details

Skills

  • Sr. Oracle SQL Analyst

Summary

We are looking for Sr. Oracle SQL Analyst for our client in Atlanta, GA

Job Title: Sr. Oracle SQL Analyst

Job Location: Atlanta, GA

Job Type: Contract

Job Overview:

Requirement/Must Have:

  • 5+ years of Oracle SQL development against transactional databases.
  • 5+ years of writing complex SQL (joins, CTEs, subqueries, CASE, aggregate and analytic functions).
  • 5+ years of normalized relational database design and table relationships.
  • 3+ years of Oracle PL/SQL (procedures, functions, packages, views) - highly desired.
  • 3+ years of SQL job scheduling and automated database processes.
  • 5+ years of SQL troubleshooting, query optimization, and data validation - highly desired.
  • 3+ years of translating business requirements into SQL solutions.
  • 3+ years of operational reporting and data analysis.

Responsibilities:

  • Develop, maintain, and optimize complex Oracle SQL and PL/SQL programs.
  • Write simple and complex SQL queries from scratch against normalized Oracle transactional databases.
  • Analyze business requirements and determine the appropriate tables, relationships, joins, and business rules needed to answer complex business questions.
  • Extract, validate, transform, and analyze operational data for reporting, research, grants, and executive requests.
  • Develop and maintain automated SQL processes, scheduled database jobs, and recurring data refreshes.
  • Troubleshoot SQL scripts, automated jobs, and data quality issues.
  • Create efficient, reusable, and well-documented SQL code.
  • Support recurring operational reports, Key Performance Indicators (KPIs), legislative reporting, and research initiatives.
  • Collaborate with business users to understand reporting needs and communicate analytical findings.
  • Support Tableau dashboards and other data visualization initiatives as needed.

Nice to Have:

  • Experience with Tableau or other data visualization software.
  • Experience in criminal justice or other large transactional database environments.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10516350
  • Position Id: GA_SOLA_0715
  • Posted 12 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Atlanta, Georgia

Today

Easy Apply

Contract, Third Party

$60

Hybrid in Atlanta, Georgia

Today

Easy Apply

Contract, Third Party

$50 - $55

Atlanta, Georgia

Today

Easy Apply

Contract

Depends on Experience

Hybrid in Atlanta, Georgia

Today

Easy Apply

Third Party, Contract

Depends on Experience

Search all similar jobs