Data Quality Profiling Developer (Oracle APEX)

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

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.

Other

Languages

English: C1 Advanced

Seniority

Regular