Sr. Oracle SQL Data Analyst (Hybrid) - Location: Atlanta, GA (In-Person Interview) - 100% Only Locals (GA) With Valid DL Copy.


HSK Technologies, Inc.
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Sr. Oracle SQL Data Analyst
- Oracle SQL
- Oracle PL/SQL
- SQL Development
- Complex SQL
- SQL Queries
- Joins
- CTEs
- Subqueries
- CASE Statements
- Aggregate Functions
- Analytic Functions
- Oracle Transactional Databases
- Normalized Relational Database Design
- Table Relationships
- Stored Procedures
- Functions
- Packages
- Views
- SQL Job Scheduling
- Automated Database Processes
- Query Optimization
- SQL Troubleshooting
- Data Validation
- Data Extraction
- Data Transformation
- Data Analysis
- Business Requirements Analysis
- SQL Solution Development
- Operational Reporting
- Executive Reporting
- Legislative Reporting
- KPI Reporting
- Research Reporting
- Database Jobs
- Data Refresh Automation
- Tableau
- Data Visualization
- Business Intelligence
- Dashboard Support
- Business User Collaboration
- Analytical Reporting
- Transactional Database Environments
- Criminal Justice Domain
Summary
Role: Sr. Oracle SQL Data Analyst (Hybrid)
Location: Atlanta, GA (In-Person Interview)
Job Type: Contract
Job Description
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.
On-Site Interviews Only!
This position is available for extensions.
Candidate MUST come ON-SITE Day 1 for Orientation and Equipment Pick up.
This position primarily works with large, normalized Oracle transactional databases and is responsible for extracting, validating, analysing, 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 analyse 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.
- Analyse business requirements and determine the appropriate tables, relationships, joins, and business rules needed to answer complex business questions.
- Extract, validate, transform, and analyse 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 Skills
Skills |
Oracle SQL development against transactional databases |
Writing complex SQL (joins, CTEs, subqueries, CASE, aggregate and analytic functions) |
Normalized relational database design and table relationships |
Oracle PL/SQL (procedures, functions, packages, views) |
SQL job scheduling and automated database processes |
SQL troubleshooting, query optimization, and data validation |
Translating business requirements into SQL solutions |
Operational reporting and data analysis |
Tableau or other data visualization software |
Criminal justice or other large transactional database environments |
- Dice Id: 91086948
- Position Id: 9027029
- Posted 3 hours ago
Company Info
We empower businesses to achieve their business innovation goals by offering world-class software development services
HSK Technologies was founded in 2009 to help businesses extract as much value as possible from their existing technology investments. From one-off projects, new implementations, HSK helps companies around the world achieve their business objectives.
With offices in North America and India, our expertise extends across most business segments including technology, financial services, insurance, healthcare, telecom, manufacturing, public sector, retail, and consumer packaged goods.
HSK is a true and seamless backend technology partner, helping your business accelerate the development of desktop, mobile & web-based apps with on-demand developers that focus on moving your business forward. Hundreds of large customers around the world, spanning Media and Entertainment, Banking and Financial services, Insurance, HealthCare, Retail, and Government entities, chose HSK as a preferred partner for IT support. With the support of industry experts and a huge pool of professionally qualified workers operating around the world, HSK Technologies offers world-class services.
We’ve earned our reputation one relationship at a time, delivering successful outcomes to over 100 customers (and counting).
Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs