Job Title:Sr. Oracle SQL Analyst (807268)
Location:Atlanta GA
Duration: 12 months
Under limited supervision the Senior Oracle SQL Data Analyst develops maintains and supports SQL solutions for operational reporting research executive decision-making legislative reporting and strategic initiatives.
This position primarily works with large normalized Oracle transactional databases and is responsible for extracting validating analyzing automating and maintaining operational data.
This is not a traditional Business Intelligence or Dashboard Development position. Approximately 70-80% of the work involves writing Oracle SQL and PL/SQL directly against transactional databases. Candidates should have experience developing SQL from scratch rather than primarily working with data warehouses semantic models or pre-built Business Intelligence datasets.
The candidate must be able to independently analyze business requirements determine the appropriate database tables and relationships needed to answer complex business questions and develop SQL solutions from scratch without relying on pre-built analytical tables semantic models visual query builders or AI-generated SQL.
Primary Duties and 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.
| Skill | Required / Desired | Amount | of Experience |
| Oracle SQL development against transactional databases | Required | 5 | Years |
| Writing complex SQL (joins CTEs subqueries CASE aggregate and analytic functions) | Required | 5 | Years |
| Normalized relational database design and table relationships | Required | 5 | Years |
| Oracle PL/SQL (procedures functions packages views) | Highly desired | 3 | Years |
| SQL job scheduling and automated database processes | Required | 3 | Years |
| SQL troubleshooting query optimization and data validation | Highly desired | 5 | Years |
| Translating business requirements into SQL solutions | Required | 3 | Years |
| Operational reporting and data analysis | Required | 3 | Years |
| Tableau or other data visualization software | Highly desired | ||
| Criminal justice or other large transactional database environments | Highly desired |
Required Skills:
Oracle SQL development against transactional databasesWriting complex SQL (joinsCTEssubqueriesCASEaggregate and analytic functions)Normalized relational database design and table relationshipsOracle PL/SQL (proceduresfunctionspackagesviews)SQL job scheduling and automated database processesSQL troubleshootingquery optimizationand data validationTranslating business requirements into SQL solutionsOperational reporting and data analysisTableau or other data visualization softwareCriminal justice or other large transactional database environments
Employment Type : Full Time
Experience: years
Vacancy: 1
Sr. Oracle SQL Analyst • Atlanta, Georgia, USA
This is a hybrid position that requires 12 days per week onsite at one of our offices in Oakland, CA, or Alpharetta, GA.The Senior Applications Analyst is responsible for applying past experience a... Show more
We are seeking a hard-working, motivated Sr Billing Analyst to work with a fast-growing Revenue Operations team reporting directly into our SVP Revenue Operations to support the growing Corporate o... Show more
Oracle Cloud PPM with Public Sector Experience.Location: remote in Eastern time with up to 50% travel to Gwinnet County, GA (expenses covered) prefer someone local to the Atlanta area.Required exp... Show more
Analyst, Rental Infrastructure Facilities.With a career at The Home Depot, you can be yourself and also be part of something bigger.Analyst, Rental Infrastructure Facilities will drive the operat... Show more
Oracle Cloud SCM Consultant Functional (PM).Staffing Industry Analysts for our accelerated growth of 300% in the last 3 years with over 5500+ employees globally, with over 30+ locations in the US ... Show more
We're looking for a detail-oriented Senior Accounting Analyst with experience in accounting principles and SQL.You'll be responsible for financial reporting, data analysis, and improving accounting... Show more
Oracle EBS Alpharetta GA Travel: Travel to Henderson NV (Vegas), expense paid, travel frequency, once in three weeks (about thrice in 8 weeks).Duration: 8 weeks with extension possible Start date: ... Show more
Collaborating with business partners to understand and anticipate their needs and translate them into IT requirements; Incorporate requests into product roadmap; Support and align efforts to meet b... Show more
Oracle Cloud Financials O2C Implementation Specialist.Demonstrate strong hands-on expertise in Oracle Cloud Financials O2C modules, particularly Customer Data Management (CDM), Accounts Receivable,... Show more
Immediate need for a talented Sr.This is a 12+ Months Contract opportunity with long-term potential and is located in Atlanta, GA.Duties include but are not limited to: gathering, developing, coord... Show more
Analyst Corporate Integrations.McKesson is an impact-driven, Fortune 10 company that touches virtually every aspect of healthcare.We are known for delivering insights, products, and services that m... Show more
Southeast Multiple Locations Job No.Qualifications: The Oracle CX Delivery Lead will have responsibility for managing a program or workstream within a program.The candidate should have 2-3 years of... Show more
Business Systems Analyst works with business partners across multiple business functions to align technology solutions with business strategies.Supports one or more highly complex business processe... Show more
Oracle Field Service Functional Senior Consultant.Our Deloitte Sales & Service team empowers organizations to build deeper relationships with customers through innovative strategies, advanced analy... Show more
TOP 5 SKILLSETS: Experience in Disaster Recovery and Governance Support Continuous Integration/Continuous Delivery efforts and advocate for automation where possible Knowledge of the ServiceNow pla... Show more
Contracts Sales Operations Team Member.The Contracts Sales Operations (CSO) team enables Client's global growth by overseeing the full governance and lifecycle of client contractsfrom intake and ne... Show more
Oracle Enterprise Performance Management Senior Manager.At PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping clien... Show more
The Opportunity As an Oracle CPQ - Senior Manager, you will guide organizations in leveraging Oracle solutions to transform their business models and achieve digital success.Within our Digital Core... Show more
Interconnected Strategy Team Position.With a career at The Home Depot, you can be yourself and also be part of something bigger.Are you ready to shape the future of retail at a massive scale? As th... Show more
Solution Leadership (ARCS & FCCS).Lead end-to-end ARCS and FCCS implementations from discovery through go-live and hypercare.Own solution architecture, design decisions, and best-practice recommend... Show more
){kind=logo}
