Oracle Data Analyst

4 Minutes ago • 5 Years +

Data Analysis

Job Description

We are seeking a highly skilled and analytical Data Analyst with proven expertise in Oracle databases and Oracle APEX (Application Express) to join our growing team. In this role, you will be responsible for extracting, analyzing, and interpreting complex data sets to support decision-making across the business. You will also design and build data-driven applications using Oracle APEX to deliver insights and tools to stakeholders. Responsibilities include analyzing large, complex datasets, developing and maintaining custom dashboards and web applications, collaborating with business users, writing complex SQL queries, designing data models, identifying data trends, and performing data validation.

Good To Have:

Experience integrating APEX applications with other systems (e.g. REST APIs, third-party services).
Background in data visualization tools (e.g. Power BI, Tableau, Oracle Analytics Cloud).
Familiarity with Agile / Scrum methodologies.
Experience in industry-specific environments (e.g. finance, healthcare, government, etc.)

Must Have:

Analyze large, complex datasets from Oracle databases to generate actionable insights.
Develop and maintain custom dashboards, reports, and web applications using Oracle APEX.
Collaborate with business users to gather requirements and translate them into technical solutions.
Write complex SQL queries, procedures, and scripts to support data analysis and reporting needs.
Design data models and maintain data integrity across systems.
Identify data trends, anomalies, and patterns to support strategic initiatives.
Work with cross-functional teams (e.g. IT, Finance, Operations) to drive data-based decision-making.
Perform data validation, cleansing, and quality checks to ensure high data accuracy.
Strong knowledge of Oracle RDBMS (11g/12c/19c) and PL/SQL.
Hands-on experience with Oracle APEX for developing web-based data applications.
Proficiency in writing complex SQL queries and working with relational databases.
Experience working with ETL processes, data pipelines, or similar tools.
Ability to work with large datasets and transform raw data into clear business insights.
Solid understanding of data governance, data privacy, and security principles.

Add these skills to join the top 1% applicants for this job

team-management

cross-functional

data-analytics

oracle

game-texts

agile-development

data-visualization

power-bi

tableau

sql

Project description

Responsibilities

Analyze large, complex datasets from Oracle databases to generate actionable insights.
Develop and maintain custom dashboards, reports, and web applications using Oracle APEX.
Collaborate with business users to gather requirements and translate them into technical solutions.
Write complex SQL queries, procedures, and scripts to support data analysis and reporting needs.
Design data models and maintain data integrity across systems.
Identify data trends, anomalies, and patterns to support strategic initiatives.
Work with cross-functional teams (e.g. IT, Finance, Operations) to drive data-based decision-making.
Perform data validation, cleansing, and quality checks to ensure high data accuracy.

Skills

Must have

5+ years of experience as a Data Analyst or similar role.
Strong knowledge of Oracle RDBMS (11g/12c/19c) and PL/SQL.
Hands-on experience with Oracle APEX for developing web-based data applications.
Proficiency in writing complex SQL queries and working with relational databases.
Experience working with ETL processes, data pipelines, or similar tools.
Ability to work with large datasets and transform raw data into clear business insights.
Solid understanding of data governance, data privacy, and security principles.

Nice to have

Experience integrating APEX applications with other systems (e.g. REST APIs, third-party services).
Background in data visualization tools (e.g. Power BI, Tableau, Oracle Analytics Cloud).
Familiarity with Agile / Scrum methodologies.
Experience in [industry-specific] environments (e.g. finance, healthcare, government, etc.)