Data Modeler with SQL

7 days ago

Sydney, New South Wales, Australia Luxoft Full time
Overview

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

#J-18808-Ljbffr

  • Data Modeler with SQL

    5 days ago

    Sydney, New South Wales, Australia Luxoft Full time

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

  • Data Modeler

    1 week ago

    Sydney, New South Wales, Australia CareCone Group Full time $90,000 - $120,000 per year

    Role: Data Modeler (Data Warehouse, SQL)Location: SydneyJob Description:Industry Knowledge Understanding the fundamentals of Data Modelling in Hadoop and Data Warehouse (preferably Teradata) required.Logical and physical data modelling in complex environments – spanning Hadoop and TeradataFamiliarity with Erwin Data Modeler tool, model mart the Web Portal...

  • Data Modeler

    1 week ago

    Sydney, New South Wales, Australia CareCone Group Full time $80,000 - $120,000 per year

    Role: Data ModelerLocation: SydneyJob Description:Industry Knowledge Understanding the fundamentals of Data Modelling in Hadoop and Data Warehouse (preferably Teradata) required.Logical and physical data modelling in complex environments – spanning Hadoop and TeradataFamiliarity with Erwin Data Modeler tool, model mart the Web Portal feature.Experience in...

  • Data Modeller

    7 days ago

    Sydney, New South Wales, Australia Carecone Australia Full time

    JD- **Exp- 5+yrs****Job Type-**Permanent**Skill Set-**Data Concepts & Data Modelling**JD-**- Industry Knowledge Understanding the fundamentals of Data Modelling in Hadoop and Data Warehouse (preferably Teradata) required.- Logical and physical data modelling in complex environments - spanning Hadoop and Teradata- Familiarity with Erwin Data Modeler tool,...

  • Data Modeler

    2 weeks ago

    Sydney, New South Wales, Australia Carecone Group Full time

    OverviewRole: Data Modeler (Data Warehouse, SQL)Location: SydneyEmployer: Carecone Group (CareCone Group)ResponsibilitiesIndustry Knowledge: Understanding the fundamentals of data modelling in Hadoop and Data Warehouse (preferably Teradata).Logical and physical data modelling in complex environments – spanning Hadoop and Teradata.Familiarity with Erwin...

  • Data Modeler

    2 weeks ago

    Sydney, New South Wales, Australia CareCone Group Full time

    OverviewRole: Data Modeler (Data Warehouse, SQL)Location: SydneyEmployer: Carecone Group (CareCone Group)ResponsibilitiesIndustry Knowledge: Understanding the fundamentals of data modelling in Hadoop and Data Warehouse (preferably Teradata).Logical and physical data modelling in complex environments – spanning Hadoop and Teradata.Familiarity with Erwin...

  • Data Modeler

    2 weeks ago

    Sydney, New South Wales, Australia CareCone Group Full time

    OverviewRole: Data Modeler (Data Warehouse, SQL)Location: SydneyEmployer: Carecone Group (CareCone Group)ResponsibilitiesIndustry Knowledge: Understanding the fundamentals of data modelling in Hadoop and Data Warehouse (preferably Teradata).Logical and physical data modelling in complex environments – spanning Hadoop and Teradata.Familiarity with Erwin...

  • Data Modeler

    2 weeks ago

    Sydney, New South Wales, Australia Zone It Solutions Full time

    OverviewJoin to apply for theData Modelerrole atZone IT Solutions.This role is based in Sydney, Australia.The successful candidate will have expertise in the Erwin Data Modeler tool, Model Mart, and the Web Portal feature.ResponsibilitiesPublish efficient physical data models for SQL, NoSQL, or message-based target layers.Model data in Hadoop and Data...

  • Data Modeler

    2 weeks ago

    Sydney, New South Wales, Australia Zone IT Solutions Full time

    OverviewJoin to apply for the Data Modeler role at Zone IT Solutions.This role is based in Sydney, Australia. The successful candidate will have expertise in the Erwin Data Modeler tool, Model Mart, and the Web Portal feature.ResponsibilitiesPublish efficient physical data models for SQL, NoSQL, or message-based target layers.Model data in Hadoop and Data...

  • Data Modeler

    2 weeks ago

    Sydney, New South Wales, Australia Zone IT Solutions Full time

    OverviewJoin to apply for the Data Modeler role at Zone IT Solutions.This role is based in Sydney, Australia. The successful candidate will have expertise in the Erwin Data Modeler tool, Model Mart, and the Web Portal feature.ResponsibilitiesPublish efficient physical data models for SQL, NoSQL, or message-based target layers.Model data in Hadoop and Data...