Data Modeler with SQL

4 weeks 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

    4 weeks 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 $120,000 - $150,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...

  • SQL Data Analyst

    1 week ago

    Sydney, New South Wales, Australia Robert Half Full time $104,000 - $130,878 per year

    We are seeking a highly analytical and detail-oriented Data Analyst to join our client's Data Team. In this role, you will be responsible for collecting, analysing, and interpreting large and complex data sets to strengthen our capabilities in data modelling, reliability, efficiency, and quality.You will work closely with data engineers, fellow analysts, the...

  • Data Modeler

    1 week ago

    Sydney, New South Wales, Australia Tata Consultancy Services Full time $90,000 - $120,000 per year

    About the jobAbout TCS:Join Tata Consultancy Services, Asia Pacific and be part of an organization committed to sustainable development for our future. TCS follows the Tata group philosophy of building sustainable businesses that are rooted in the community and demonstrate care for the environment. Our unique values position us to combine a purpose-driven...

  • Data Modeler

    2 weeks ago

    Sydney, New South Wales, Australia Zone IT Solutions Full time $90,000 - $120,000 per year

    We are seeking a skilled Data Modeler based in Sydney, with expertise in the Erwin Data Modeler tool, Model Mart, and the Web Portal feature.Strong knowledge o f Data Modelli ng in Hadoop and Data Warehousing (preferably Teradata)Expertise i n logical and physical data modelli ng across Hadoop and Teradata environmentsProficiency wit h Erwin Data Model ...

  • Data Modeler

    2 weeks ago

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

    Strong expertise in data modelling and/or database design, with a focus on data engineering use cases.Experience with NoSQL schemas, such as JSON schema.Proficiency in working with large-scale, complex datasets.Knowledge of bitemporal data warehousing concepts and data modelling techniques with an understanding of relational databases and SQL.Strong...

  • Data Modeller

    2 weeks ago

    Sydney, New South Wales, Australia TOM Full time $120,000 - $180,000 per year

    We are seeking a highly skilled and detail-oriented Enterprise Platform Data Modeler with deep expertise in normalized data modeling (particularly 3rd Normal Form) to support the design and delivery of enterprise-grade data assets within a modern data mesh architecture.Key Responsibilities:Develop conceptual, logical, and physical data models that are...

  • Data Engineer

    2 weeks ago

    Sydney, New South Wales, Australia NTT DATA Full time $80,000 - $140,000 per year

    Make an impact with NTT DATAJoin a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion – it's a place where you can grow, belong and thrive.Your day at NTT DATAThe Data Engineer...

  • Data Modeller

    6 days ago

    Sydney, New South Wales, Australia Cognizant Technology Solutions Australia Pty Ltd Full time $120,000 - $180,000 per year

    Cognizant is looking for a Data Modeller & Technical Business Analyst in developing customized product for our clients. The role is expected to drive technology discussions and analyze the current landscape for gaps in addressing business needs. Cognizant needs a motivated individual to challenge the status quo and provide thought leadership/best practices...