Data Quality Profiling Developer (Oracle APEX)

15 Minutes ago • All levels

Data Analysis

Job Description

We are looking to hire skilled professionals to help build out an enterprise-grade data quality profiling solution. A working Proof of Concept (PoC) has already been implemented over Avaloq using the existing Oracle APEX infrastructure. The next phase is focused on industrialising the solution and scaling it for broader use. Responsibilities include enhancing the existing PoC, collaborating with stakeholders for requirements, optimising performance, ensuring alignment with data quality frameworks, and supporting testing and deployment.

Good To Have:

Experience with Avaloq Reporting & Data Extracts (ARD, ADF, SmartView)
Familiarity with Avaloq-specific data export or reporting mechanisms would help accelerate development.
Knowledge of Oracle Database Tuning / Performance Diagnostics
In-depth understanding of execution plans, indexes, and session performance tools.
Experience with Data Quality Tools or Frameworks
Exposure to tools like Informatica DQ, Talend DQ, Collibra, or custom-built DQ engines.
Familiarity with Data Governance Practices
Understanding of data stewardship, lineage, and regulatory reporting requirements (e.g., BCBS 239, GDPR).
Experience in Financial Services / Core Banking Systems
Previous experience in banking, especially wealth or private banking, adds strong domain value.
Exposure to Agile / Scrum Delivery Methodologies
Ability to work in iterative delivery cycles, contribute to sprint planning, and maintain documentation in JIRA/Confluence.
Front-End/UI Experience within APEX
Skills in designing intuitive dashboards or user interfaces, particularly for DQ dashboards or exception reporting.
Data Visualisation & Reporting Tools
Experience with tools like Power BI, Oracle BI Publisher, or Tableau for representing data profiling results.
Scripting/Automation
Ability to automate DQ checks using Shell, Python, or other scripting tools is a plus.
Understanding of Metadata Management Concepts
Helps in building reusable and sustainable DQ frameworks across different domains.

Must Have:

Expertise in Oracle APEX: Proven experience developing complex, data-centric applications
Strong Business Analysis (BA) capabilities: Self-starter with the ability to independently engage SMEs and document requirements
Oracle PL/SQL: Solid coding and troubleshooting skills; performance tuning and DBA knowledge is a strong advantage
Experience with Avaloq: Familiarity with Avaloq's physical data layer is essential
Knowledge of data quality frameworks: Understanding of profiling dimensions and industry-standard approaches (e.g., DQ checks, data validation rules)

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

problem-solving

oracle

game-texts

business-analysis

agile-development

oracle-database

power-bi

tableau

front-end

confluence

python

sql

shell

jira

Project description

Responsibilities

Enhance and productionise the existing data quality profiling PoC using Oracle APEX
Collaborate with SMEs and technical stakeholders to capture and refine business and technical requirements
Translate high-level discussions into structured documentation and user stories
Work closely with DBAs and architects to optimise performance and scalability
Ensure alignment with industry-standard data quality profiling frameworks and dimensions (e.g., completeness, accuracy, consistency)
Support solution testing and deployment in both development and production environments

Skills

Must have

Expertise in Oracle APEX: Proven experience developing complex, data-centric applications
Strong Business Analysis (BA) capabilities: Self-starter with the ability to independently engage SMEs and document requirements
Oracle PL/SQL: Solid coding and troubleshooting skills; performance tuning and DBA knowledge is a strong advantage
Experience with Avaloq: Familiarity with Avaloq's physical data layer is essential
Knowledge of data quality frameworks: Understanding of profiling dimensions and industry-standard approaches (e.g., DQ checks, data validation rules)

Nice to have

Experience with Avaloq Reporting & Data Extracts (ARD, ADF, SmartView): Familiarity with Avaloq-specific data export or reporting mechanisms would help accelerate development.
Knowledge of Oracle Database Tuning / Performance Diagnostics: In-depth understanding of execution plans, indexes, and session performance tools.
Experience with Data Quality Tools or Frameworks: Exposure to tools like Informatica DQ, Talend DQ, Collibra, or custom-built DQ engines.
Familiarity with Data Governance Practices: Understanding of data stewardship, lineage, and regulatory reporting requirements (e.g., BCBS 239, GDPR).
Experience in Financial Services / Core Banking Systems: Previous experience in banking, especially wealth or private banking, adds strong domain value.
Exposure to Agile / Scrum Delivery Methodologies: Ability to work in iterative delivery cycles, contribute to sprint planning, and maintain documentation in JIRA/Confluence.
Front-End/UI Experience within APEX: Skills in designing intuitive dashboards or user interfaces, particularly for DQ dashboards or exception reporting.
Data Visualisation & Reporting Tools: Experience with tools like Power BI, Oracle BI Publisher, or Tableau for representing data profiling results.
Scripting/Automation: Ability to automate DQ checks using Shell, Python, or other scripting tools is a plus.
Understanding of Metadata Management Concepts: Helps in building reusable and sustainable DQ frameworks across different domains.