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.
| Required / Desired |
|
|
| Oracle SQL development against transactional databases | Required |
|
|
| Writing complex SQL (joins, CTEs, subqueries, CASE, aggregate and analytic functions) | Required |
|
|
| Normalized relational database design and table relationships | Required |
|
|
| Oracle PL/SQL (procedures, functions, packages, views) | Highly desired |
|
|
| SQL job scheduling and automated database processes | Required |
|
|
| SQL troubleshooting, query optimization, and data validation | Highly desired |
|
|
| Translating business requirements into SQL solutions | Highly desired |
|
|
| Operational reporting and data analysis | Highly desired |
|
|
| Tableau or other data visualization software |
|
|
|
| Criminal justice or other large transactional database environments | Highly desired |
Oracle SQL Analyst • Atlanta, GA, Georgia, USA
Location:Remote (Must reside in Georgia) Employment Type:Contract / Contract-to-Hire Position Overview We are seeking a Programmer II with strong SQL and cloud data warehousing expertise to support... Show more
Business Analyst Oracle HCM Cloud Applications.HR functional analyst capable of working in partnership with the business users to formulate recommendations for business process design, break-fix a... Show more
Citizens and those authorized to work in the U.We are unable to sponsor currently.Bachelors degree (Engineering or MIS/Computer Science preferred).Strong problem solving and analytical skills.Exper... Show more
Field Support Analyst I (Billing Analyst).Department: Lighting & Smart Services / Utility Services.The Field Support Analyst II (Billing Analyst) is responsible for ensuring the timely and accurate... Show more
Compliance Opportunity in Financial Services.Atlanta: 2300 Windy Ridge Pkwy SE, Suite750, Atlanta, GA 30339.La Vista: 12325 Port Grace Blvd, La Vista, NE 68128.Scottsdale: 18700 N Hayden Rd, Suite ... Show more
Are you ready to take on a role where your work directly strengthens customer experience and drives operational excellence for a leading Atlanta-based public company?.Our Data Administrator plays a... Show more
Secretariat is your source for independent expert advisory services.Secretariat specializes in international arbitration, general commercial arbitration/litigation, forensic accounting, economic da... Show more
Instant Financial Process Analyst.Instant Financial is the industry-leading instant pay platform that is changing the way that millions of Americans get paid.With a push of a button on the Instant ... Show more
Hybrid Management Role in Alpharetta, GA.We need someone with strong management skills, a scrum master, and who is a JIRA jockey.They can't be afraid to do Jira entry and reporting working across s... Show more
OverviewThis is a remote role that may be hired in several markets across the United States.CMDB Analyst will support complex project for the CMDB and ServiceNow Data Foundations supporting CSDM.Th... Show more
Senior Accounting Analyst (SQL).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 an... Show more
Duration: 3 years (Possible Extension/Conversion).Location: 260 Southfield Parkway Forest Park GA 30297.Shift Timing: Mon Fri Standard Shift.The Billing Analyst role is to ensure the timely and ac... Show more
Headquartered in Atlanta, Cousins is a fully integrated, self-administered and self-managed real estate investment trust (REIT).Cousins has a simple, compelling strategy: Premier urban Sun Belt off... Show more
Business Analyst - Data Warehousing.Responsibilities: Seeking qualified candidates for the position of Business Analyst - Data Warehousing in Atlanta, Georgia.The Business Analyst will support the ... Show more
OverviewThe Asset and CMDB Analyst will be responsible for the strategic planning, implementation, and ongoing management of our IT Service Asset and Configuration Management (ACM) processes and to... Show more
Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired by a collaborative community of colleagues... Show more
Are you ready to take on a role where your work directly strengthens customer experience and drives operational excellence for a leading Atlanta-based public company?.Our Data Administrator plays a... Show more
Proven Leader in providing full IT Services, Software Development and Solutions for 15 years.TECHNOGEN is a Small and Woman Owned Minority Business with GSA Advantage Certification.We have offices ... Show more
Verdana, Arial, Helvetica, sans-serif"><span style="font-style:normal"><span style="font-variant-ligatures:normal"><span style="font-weight:400"... Show more
Job Title- Oracle Cloud Functional consultantLocation Remote within USADuration - Contract 12 MonthsMandatory Skills Oracle Cloud Fusion ERP Finance Functional resource who can support Procurement ... Show more
