Oracle SQL Data Analyst

JPS Tech Solutions Pvt Ltd; Pennsylvania; On-site; USD 110,000 - 150,000; Full time

Job summary

JPS Tech Solutions Pvt Ltd in Pennsylvania is seeking a Senior Oracle SQL Data Analyst to develop and maintain SQL solutions for operational reporting, research, executive requests, and regulatory reporting. You will write complex Oracle SQL and PL/SQL queries against transactional databases and automate recurring processes.

The role requires 6+ years of SQL development experience with Oracle SQL and PL/SQL, strong analytical and communication skills, and onsite presence for interviews and Day 1

Qualifications

• At least 6 years of experience in SQL development or data analysis.
• Hands-on Oracle SQL and PL/SQL experience.
• Ability to translate business requirements into accurate and efficient SQL solutions.

Responsibilities

• Develop, optimize, and maintain Oracle SQL and PL/SQL scripts.
• Write queries from scratch against normalized transactional databases.
• Analyze requirements and identify appropriate tables, joins, relationships, and business rules.
• Extract, validate, transform, and analyze data for operational, research, grant, and legislative reporting.
• Automate scheduled database jobs and recurring data refresh processes.
• Troubleshoot query performance, data inconsistencies, and automated job failures.
• Maintain reusable, efficient, and well‑documented SQL code.
• Support KPI reporting, executive requests, and recurring operational reports.
• Collaborate with business stakeholders to clarify requirements and communicate findings.
• Assist with Tableau dashboards and data visualization as needed.

Skills

Analytical thinking

Problem-solving

Documentation

Communication

Tools

Oracle SQL

PL/SQL

Job description

Job Description:

One of our clients is seeking a Senior Oracle SQL Data Analyst to develop and maintain SQL solutions for operational reporting, research, executive requests, and regulatory reporting. The role primarily involves writing complex Oracle SQL and PL/SQL queries directly against transactional databases, validating data, automating recurring processes, and delivering accurate business insights.

Key Responsibilities:

• Develop, optimize, and maintain complex Oracle SQL and PL/SQL scripts.
• Write queries from scratch against normalized transactional databases.
• Analyze business requirements and identify appropriate tables, joins, relationships, and business rules.
• Extract, validate, transform, and analyze data for operational, research, grant, and legislative reporting.
• Automate scheduled database jobs and recurring data refresh processes.
• Troubleshoot query performance, data inconsistencies, and automated job failures.
• Maintain reusable, efficient, and well‑documented SQL code.
• Support KPI reporting, executive requests, and recurring operational reports.
• Collaborate with business stakeholders to clarify requirements and communicate findings.
• Assist with Tableau dashboards and data visualization as needed.

Required Qualifications:

• 6+ years of experience in SQL development, data analysis, or a related field.
• Strong hands‑on experience with Oracle SQL and PL/SQL.
• Proven ability to develop complex queries independently against normalized transactional databases.
• Strong understanding of database structures, table relationships, joins, data validation, and query optimization.
• Experience automating SQL processes, scheduling database jobs, and troubleshooting data issues.
• Ability to translate business requirements into accurate and efficient SQL solutions without relying primarily on prebuilt analytical datasets or visual query tools.
• Strong analytical, problem‑solving, documentation, and communication skills.
• Local candidates only. Onsite interviews are required, and the selected candidate must report onsite on Day 1 for orientation and equipment pickup. Equipment will not be shipped.

Preferred Certifications:

• No specific certification is required.
• Oracle Database or SQL‑related certifications are a plus.