Data Modeler with SQL

2 weeks ago

Haymarket, 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

  • Principal Data Architect

    2 weeks ago

    Haymarket, New South Wales, Australia beBeeDataModeler Full time $120,000 - $180,000

    Join Our Team as a Data ModelerOverview: As a skilled data modeler, you will play a key role in modernizing our 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,...

  • Data Science Innovation Leader

    2 weeks ago

    Haymarket, New South Wales, Australia beBeeAnalytics Full time $113,574 - $125,720

    AI and Analytics SpecialistOverview of the RoleAs an AI and analytics specialist, you will be working on data science projects to deliver high-level project goals. This will involve collaborating with a delivery manager and other members of the team to deliver in an agile project methodology.The key responsibilities of this role include working on the DAC's...

  • Data Scientist

    2 weeks ago

    Haymarket, New South Wales, Australia NRN - National Renewable Network Full time

    Overview NRN is revolutionising how Aussies use energy. With a 2030 goal to outfit 250,000 homes with solar and battery setups, NRN is leading a sustainable, wallet-friendly energy movement. Our model enables customers to save without upfront costs or complex finance deals, supported by a network of Energy Retailers and Solar Retail Partners (SRPs). NRN is...

  • Senior Data Analyst

    2 weeks ago

    Haymarket, New South Wales, Australia Ampstek Full time

    Senior Data Analyst Direct message the job poster from Ampstek5–7 years of experience as a Data Analyst (or similar) in complex enterprise environments.Strong SQL skills (data extraction, joins, window functions, performance basics) and hands on experience with Power BI (data modeling, DAX/Power Query, visuals).Demonstrated experience analyzing...

  • Data Insights Specialist

    2 weeks ago

    Haymarket, New South Wales, Australia beBeeInsights Full time $90,000 - $120,000

    Job Description:We are seeking a highly skilled Data Insights Specialist to join our team. As a key member of the organization, you will be responsible for analyzing complex data structures, identifying trends and insights, and providing actionable recommendations to drive business growth.Required Skills and Qualifications:Strong SQL skills, including data...

  • AI Driven Data Specialist

    2 weeks ago

    Haymarket, New South Wales, Australia beBeeDataEngineer Full time $90,000 - $120,000

    Powering Data Solutions at a World-Class InstitutionThe Automation & Innovation Hub seeks a technically skilled and business-savvy data engineer to power the University's most advanced data solutions and AI projects. From designing robust reporting frameworks to fuelling machine learning workflows, this is your chance to make an impact.As a data engineer,...

  • Data Analyst

    2 weeks ago

    Haymarket, New South Wales, Australia Kaizen Global Technologies Full time

    Looking for a Data analysts with SQL, Python and R knowledge .Responsibilities Working collaboratively in cross-functional Scrum teams with Product, Analytics and Remediation colleagues, you will be responsible for leveraging the Group's data assets to review risk issues and support end-to-end remediation of business customersDevelop analytical solutions...

  • Unlocking Insights: A Mid-Level Data Analyst Role

    2 weeks ago

    Haymarket, New South Wales, Australia beBeeData Full time $80,000 - $120,000

    Mid-Level Data AnalystThe role is available for a skilled professional to work on transforming data into actionable insights that support business decisions. You will play a key role in the transformation of data.This role requires analytical skills and experience with working with SQL, Python, and Business Intelligence tools. The successful candidate should...

  • Data-driven Treasury Expert

    2 weeks ago

    Haymarket, New South Wales, Australia beBeeLiquidity Full time $80,000 - $120,000

    Job Title: Liquidity Platform ManagerAbout the Role:We are seeking an experienced Liquidity Platform Manager to join our team. In this role, you will be responsible for delivering high-quality liquidity information to meet regulatory and internal reporting obligations within a robust risk management framework.Key Responsibilities:Collaborate with business...

  • Data Analyst

    2 weeks ago

    Haymarket, New South Wales, Australia Delta Full time

    Are you ready to play a key role in the energy industry's transition and make data the driving force behind smarter decision-making? Delta is seeking a Data Analyst to join our Corporate Finance team in Sydney. This role is critical to ensuring the accurate capture, settlement, and reporting of electricity and financial market transactions while shaping the...