Data Modeler with SQL

0 years

0 Lacs

Posted:1 week ago| Platform: SimplyHired logo

Apply

Work Mode

On-site

Job Description

Project description

Support one of Australia's leading banks in modernizing their customer entitlements platform and Identity and Access Management. The current landscape includes multiple data sources, databases, and hundreds of Oracle Stored Procedures fronted by web services. The goal is to re-architect these into a single, unified platform. This is an engineering role (not a BA), requiring hands-on data modeling, manifest-driven mapping, and delivery of working solutions. Candidates are expected to be in the office 50% of the time (Sydney-based hybrid model).

Responsibilities

Map the current target state using a manifest-driven approach; propose and implement schema changes.

Design and evolve models across relational, graph, and NoSQL databases.

Refactor Oracle PL/SQL logic and deliver migrations, pipelines, and automated tests.

Build and optimise solutions on AWS (RDS, S3, Lambda, ECS, EKS, IAM, Neptune if applicable).

Automate validations and CI/CD steps using Python and Groovy.

Partner with IAM, API, and platform teams to ensure compliance, auditability, and secure entitlements.

Skills

Must have

Data modelling and SQL/PLSQL

AWS data services and automation

Python and Groovy scripting

Graph DB (Neptune or Neo4j) and NoSQL databases

Ping Manifest/schema and policies governance

IAM principles and audit compliance

Strong data modelling across conceptual, logical, and physical layers with clear artefacts (ER models, graph schemas, JSON/Avro/DDL)

Hands-on experience with SQL and PL/SQL for reading/refactoring stored procedures and writing performant queries

Practical experience with AWS services, including RDS, S3, Lambda, IAM/Secrets Manager, CloudWatch/CloudTrail, and Amazon Neptune.

Proficiency in Python for data engineering, validation, profiling, and reconciliation tasks; Groovy for scripting and pipeline integration (e.g., GitHub actions)

Experience with manifest-driven mapping or schema registry patterns; ability to govern schema changes and versioning

Understanding of IAM models (RBAC/ABAC), PII handling, and audit/lineage requirements in regulated environments

Nice to have

Proficient with Ping Products

IDM, Authorize, Directory, Federate

Experience with Cypher (Neo4j), Gremlin (TinkerPop), or SPARQL for graph traversal and entitlements modeling

Exposure to Terraform or AWS CDK for infrastructure as code in data platforms

Performance tuning experience with Redshift or Aurora

Familiarity with metadata/lineage tooling and data contract frameworks

Banking domain experience, especially in entitlements and authorization

Knowledge of API/service integration patterns and schema registries

Other

Languages

English: C1 Advanced

Seniority

Senior


Bengaluru, India

Req. VR-117328

Data Modeling

BCM Industry

11/09/2025

Req. VR-117328

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
Luxoft logo
Luxoft

IT Services and IT Consulting

Zug New York

RecommendedJobs for You