Data Modeler with SQL

11 hours ago

Bengaluru, Karnataka, India Luxoft Full time ₹ 15,00,000 - ₹ 28,00,000 per year
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

  • Data Modeler

    1 week ago

    Bengaluru, Karnataka, India Growel Softech Pvt. Ltd. Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Experience7-15 yrs Job LocationPan India(Except Gurgaon) Notice PeriodOnly Immediate Joiners JD: - Dimensional Data Modeler who has worked on SAP Source systems and who is good with SQL. PL/SQL is a plus- Hands-on in Data model tools like Erwin- Data Modelers to work with database engineers to create optimal physical data models of datasets, then...

  • Data Modeler

    4 days ago

    Bengaluru, Karnataka, India Talentonlease Full time

    Description :Responsibilities : - Design and implement dimensional data models (star/snowflake schemas) optimized for reporting and analytics. - Collaborate with business stakeholders to translate reporting requirements into logical and physical data models. - Maintain and evolve enterprise data models across domains.Required Skills : - Deep...

  • Data Modeler

    6 days ago

    Bengaluru, Karnataka, India The Reliable Jobs Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    About the Role : We are looking for an experienced Data Modeler to join our Data Engineering team. The ideal candidate will bring strong expertise in Cloud Data Platforms, SQL, Dimensional Modeling, and Performance Tuning, along with domain experience in Consumer-Packaged Goods (CPG). You will work with cross-functional teams Sales, Trade, Supply Chain,...

  • Data Modeling

    2 weeks ago

    Bengaluru, Karnataka, India UST Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    5 - 7 Years1 OpeningBangaloreRole descriptionKey Responsibilities: • Design and develop conceptual, logical, and physical data models based on business requirements. • Use data modeling tools (e.g., Erwin, PowerDesigner, dbt, Lucidchart, SQL DB tools) to create and maintain models. • Collaborate with data engineers and DBAs to implement and optimize...

  • Data Modeler

    6 days ago

    Bengaluru, Karnataka, India The Reliable Jobs Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    About the Role : We are seeking a highly skilled and motivated Data Modeler with deep expertise in Cloud Data Platforms, SQL, Dimensional Modeling, and Performance Tuning to join our growing Data Engineering team. The ideal candidate will have experience in the Consumer-Packaged Goods (CPG) domain and a proven track record of designing scalable,...

  • Data Modeller

    4 days ago

    Bengaluru, Karnataka, India Teamware Solutions ( A Division Of Quantum Leap Co Nsulting . Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Good understanding of financial reference and/or market reference data.Data modelling skills and a working knowledge of the difference between conceptual, logical and physical models.In-depth knowledge of database structures for reference data as well as methods of working for sourcing and capturing this dataUnderstanding of UML and ERD for logical data...

  • Data Modeler

    2 days ago

    Bengaluru, Karnataka, India NTT DATA Global Delivery Services Ltd Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    ERWin Data Modeler Req ID: 340303 NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a ERWin Data Modeler to join our team in Bangalore, Karnātaka (IN-KA), India (IN). "Job...

  • Data Modeler

    2 days ago

    Bengaluru, Karnataka, India The Reliable Jobs Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    This role demands both strong technical expertise and the ability to engage with businessstakeholders to ensure data solutions are accurate, scalable, and aligned with strategicobjectives.Key ResponsibilitiesDesign, develop, and maintain dimensional, relational, and semantic data models that support analytical and operational use cases.Ensure models are...

  • Senior Data Modeller

    4 days ago

    Bengaluru, Karnataka, India PureSoftware Ltd Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Experience as a Data Modeler or Database Designer, with specific experience in the life insurance industry.Proficiency in Erwin Data Modeler for designing conceptual, logical, and physical data models.Strong SQL skills and experience working with relational databases (e.g., SQL Server, Oracle, DB2).Solid understanding of data modeling techniques, principles,...

  • Data Modeller

    2 weeks ago

    Bengaluru, Karnataka, India Whyflex Human Capital Solutions Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    This is for 6 Months Extendable Contract.Location: Remote.Role & responsibilitiesStrong expertise in data transformation and pipeline development (SQL, Python, DBT)Strong expertise and hands-on experience in Data Vault 2.0 modeling frameworkIDE-savvy, working with dbt CLI locally and github copilotBuild dbt model following the DV2.0 and StarschemasWorking...