Oracle Pl/sql

Oracle Pl/sql Data Jobs

2 jobs found

Today

Senior Research and Data Analyst

Association of American Medical Colleges Washington, DC

Washington, DC

Today

$105k - $124k/yr Full time Senior Analytics Business Intelligence

Apply Now

Job Description

Hybrid role with the option to work remotely across the contiguous U.S. Join a mission-driven team at the Association of American Medical Colleges (AAMC) and help strengthen data collections, reporting, and analytics that support member and constituent needs. You will own key data assets, ensure quality and security across recurring collections, and partner with IT and a network of internal and external stakeholders to keep essential reporting running smoothly.

Compensation: USD 105,315 - 123,900 per year. Location: Washington, DC (hybrid). Remote eligibility: Eligible for remote work in the contiguous US. Experience: Minimum 3 years. Education: Bachelor’s degree.

What you’ll own and improve

Own data assets and systems supporting the National GME Census in GME Track, FACTS tables, ERAS National Statistics tables, the Primary Care Loan Report, the Report on Residents, and additional assigned data and reporting assets from other DOS teams and data teams.
Maintain and enhance data collections covering quality, utilization, work effort, and financial metrics as appropriate.
Monitor the soundness, timeliness, impact, efficiency, and security of data collection and data reporting services through ongoing data quality checks and discrepancy investigation.
Develop, implement, and update programming and documentation for assigned data and reports, including clarity on institution and individual eligibility for the corresponding data collections and reports.
Develop and maintain programming and databases for collecting, importing, managing, checking, linking, analyzing, reporting, and distributing data, using AAMC IT approved tools such as SQL, PL/SQL, PostgreSQL, VBA, Python, HTML, HighCharts, JavaScript, and Verint.

How you’ll support teams and stakeholders

Coach and mentor less senior colleagues on these data assets and systems, including expanding their knowledge through guided support.
Collaborate with IT colleagues to support IT-maintained applications, data collections, and integration with other data and analytical offerings.
Assist junior staff with IT-related activities such as developing requirements and supporting user acceptance testing.
Engage with data collection participants, report recipients, and other users to address content questions, reminders, extensions, and quality control needs.
Consult with colleagues and constituents to enhance data collections, standard reports, research reports, external/internal ad hoc reports, and other analytical offerings.

Data requests, documentation, and governance

Maintain accurate financial and timekeeping records to support prioritization, enterprise portfolio management, and impact analyses for assigned data assets.
Manage tracking of internal and external data requests across AAMC, including reviewing, fulfilling, and triaging requests to appropriate staff.
Write and maintain office manuals and runbooks describing procedures for running data collection and data reporting services, with collegial review of materials from less senior staff.
Serve as a Data Asset Owner for assigned data assets, completing required internal and external Data Asset Owner training.
Determine appropriate internal and external access levels, and enforce data access, publication, and security policies and procedures, including guidance referenced by Survey and Research Central, OCOMM, Legal, and IT.
Contribute to IT initiatives related to infrastructure changes, data access and security, and system modernizations, escalating risks and benefits to unit supervisors when needed.
Apply problem-solving to identify root causes of one-time or recurring issues and recommend solutions.
Represent the unit, the cluster, and the AAMC data community in internal and external discussions around data collection, analytics, and reporting.

Minimum requirements

Bachelor’s degree.
A master’s degree or doctoral degree is preferred, with course work in quantitative reasoning and qualitative reasoning.
Minimum experience substitution: If a Bachelor’s degree is required, related work experience may be substituted in some positions (one year of college course work at an accredited institution equals one year of related work experience).
Minimum experience: 5-7 years of related work experience.
Minimum supervisory or subject matter expertise: 3-5 years of experience managing a specialized program.
Experience with quantitative, qualitative, and logical reasoning, including self-directed knowledge acquisition and application.
Programming, database design, data security, data standards, data processing, relational databases, data instrument construction, data visualization, and report writing.
Collaborative working environments.
Time management, resource management, quality control, and continuous quality improvement.
Experience with data collection, analysis, and reporting in small to large organizations where data are critical to delivering on strategy, mission, and services to members and constituents.

Tools you’ll use

SQL, PL/SQL, PostgreSQL, VBA, Python, HTML, HighCharts, JavaScript, Verint
GME Track

Benefits at AAMC

Hybrid Work: Primarily remote roles with the ability to work across the U.S.
Comprehensive Health & Wellness: Medical, dental, and vision coverage; wellness programs; and fitness reimbursement.
Generous Time Away: Paid time off, holidays, personal days, sick leave, paid parental leave, and short- and long-term disability benefits.
Retirement: 403(b) retirement plan with generous employer contributions and financial planning resources.
Backup Care Support: For children, elders, and pets, plus resources for families with specialized needs.
Learning & Growth: Tuition reimbursement, professional learning and development opportunities, and the chance to advance a meaningful mission.

View full job page →

5d ago

Data Analyst - III

Nexiya San Diego, CA

San Diego, CA

5d ago

$60 - $75/hr Full time Analyst Business Analytics Business Intelligence

Apply Now

Job Description

Nexiya is hiring a Data Analyst III to deliver advanced analytical support for a major utility organization. In this onsite role with the Advanced Distribution Management Team (ADMT), you will work with complex operational, outage, customer, and system datasets, using strong SQL to produce validated insights and recommendations that improve operational performance and the customer outage experience.

The work is centered on leading data requests, auditing outage-related datasets, and building reporting that leadership can act on. The position is based in the Kearny Mesa office in San Diego, CA.

Key Responsibilities

Lead complex electric distribution, Network Management System (NMS), Oracle Utilities Analytics (OUA), and Customer Success data requests by mapping source data relationships, building and refining SQL queries, validating outputs, and converting findings into actionable recommendations.
Own recurring outage data audits to surface gaps, trends, and improvement opportunities across customer outage notifications, internal processes, data quality, and supporting technology.
Design and build reports, dashboards, and data views using outage, customer, operational, and other relevant data sources to support leadership decisions and operational performance monitoring.
Support development of internal and external outage trackers, including integration with cloud-hosted components or AWS-based environments where applicable.
Analyze Customer Success data, customer outage notification data, and external outage map data to identify opportunities to improve customer experience, including recommendations tied to crew status information and enhancements to customer-facing outage maps.
Perform other job duties as assigned.

Requirements

5 or more years of progressive experience in data analytics, business systems analysis, database development, BI and reporting, software development, or application/data support roles, preferably supporting complex operational systems.
Senior-level experience developing reports, dashboards, data extracts, or analytics using SQL, Oracle tools, Power BI, or similar platforms, with strong working knowledge of SQL, relational data models, and Oracle Database concepts.
Ability to independently analyze complex operational datasets, reconcile data across systems, identify anomalies, validate results, evaluate options, and translate findings into actionable business insights.
Experience leading requirements discussions, documenting functional or technical specifications, supporting user acceptance testing, creating user-friendly documentation, and advising stakeholders on data-driven decisions.
Familiarity with outage management, Customer Success, customer outage notifications, external outage map analytics, reliability data, Oracle Utilities Analytics (OUA), Network Management System (NMS), SQL Developer, or related utility operations data preferred.
Experience with PL/SQL, XML, Power Query, Power BI data modeling, DAX, Microsoft Fabric, cloud data warehousing, or AWS-based data environments preferred.
Strong executive-ready communication skills, including the ability to explain complex technical information, summarize findings, and influence decisions with both technical and non-technical audiences.
Must be able to successfully pass background screening.
Candidate must be eligible to work in the United States.

Preferred/Relevant Technologies

SQL, Oracle tools, Oracle Database
Oracle Utilities Analytics (OUA), Network Management System (NMS), SQL Developer
PL/SQL, XML, Power Query, Power BI data modeling, DAX, Microsoft Fabric, AWS

Benefits

Health Insurance, Dental Insurance, Vision Insurance
401K and Match
Vacation, Sick Leave
Phone & Internet Reimbursement

Location: San Diego, CA 92123 (onsite, required). Work location: in person. Pay range: $60.00 - $75.00 per hour (min $60/hour, max $75/hour). Client deadline: Thursday 8/13 at 5 PM.

Application question: Do you have work experience in the Utilities or Construction industries?

View full job page →

Oracle Pl/sql Data Jobs

Senior Research and Data Analyst

Data Analyst - III

Get Oracle Pl/sql Data Jobs alerts