Oracle Data Analyst

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, working with cross-functional teams, and performing data validation and quality checks.

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.
• 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.

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.)

##### Project 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

• 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.)

##### Other

Languages

English: C1 Advanced

Seniority

Senior