Sr. Oracle SQL Analyst
InventSoft
Dice Job Match Score™
👾 Reticulating splines...
Job Details
Skills
- Analytical Skill
- Artificial Intelligence
- Business Intelligence
- Business Rules
- Collaboration
- Criminal Justice
- Dashboard
- Data Quality
- Data Visualization
- Data Warehouse
- Database
- Database Design
- Job Scheduling
- KPI
- Oracle
- PL/SQL
- Pick
- Query Optimization
- Reporting
- Research
- SQL
- Scratch
- Scripting
- Semantics
- Tableau
- Writing
Summary
ON-SITE INTERVIEWS ONLY!
This position is available for extensions.
Candidate MUST come ON-SITE Day 1 for Orientation and Equipment Pick up. The Client does not ship equipment.
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 statements, aggregate functions, and analytic functions) | Required | 5 Years |
Normalized relational database design and table relationships | Required | 5 Years |
Oracle PL/SQL (procedures, functions, packages, and 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 | Not Specified |
Experience working with criminal justice or other large transactional database environments | Highly Desired | Not Specified |
- Dice Id: RTX1d250f
- Position Id: 9026104
- Posted 15 hours ago
Company Info
About InventSoft
We bring innovation and fuels collaboration with our teamwork to provide you the best for your business.
We are the world’s leading software development and consulting company designed for your business to deliver you outperforms results. Our tailored and integrated expertise with a vibrant structured system of digital innovators is here for all your business needs.
We helped various companies to identify several gaps in their business by providing useful insights into their enterprise. Besides providing software development and consulting services, we also allow you to manage your workforce effectively with our swiftly designed staffing solutions.
Our main focus lies in the core corporation, along with providing in-staffing solutions as per your requirements. But, we are not limited to this. Be it technolog
y, automation, or entrepreneurial management, we are always staying beside you. We bring talent, expertise, and scalability to the solution we provide so that you are ready to accept all challenges for your business. Our professional experts are always here for the persons who defy the perception of their own limits. Our main goal is to provide sustainable results for your business with an ambition to lead and courage your organizational structure with the right innovative approach. With our agile methodology, we promote continuous iteration of development and follow a creative process that anticipates the need for flexibility to deliver the finished product. Our professionals provide accuracy, consistency, punctuality as well as transparency at work so that you get an update on each and every step we make to improve your business and fulfill its needs.
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs