Data Modeller
WhizdomSydney, AUWhizdom Sydney, New South Wales, Australia.State Manager - taking the Whizdom success story further into NSW, QLD and VIC.Our client is a prestigious consulting firm renowned for its expertise in d... Show more
Data Modeler and Analyst - SydneyAyan Infotech • Sydney, NSW, AU
Data Modeler and Analyst - Sydney
Ayan Infotech • Sydney, NSW, AU
13 days ago
Job description
AYAN InfoTech is looking for Data Modeler and Analyst to join an exciting project based in Sydney. The role offers you the opportunity to contribute towards an extremely well structured and mature environment, working on sophisticated enhancement projects.
Role: Data Modeler and Analyst
Location: Sydney
Contract Duration: 6 Months with high possible extensions
Experience: 7+ Years
Required Capabilities
- Data Modelling, Conceptual, logical (Entity Relationship) and physical data modelling.
- Data models review with both IT and business audiences, communicating how the model meets requirements of both existing projects and the overall information architecture and strategy and any relevant deficiencies and gaps.
- UML modelling using all of the following:
- Class diagrams
- Activity diagrams
- Sequence diagrams
- Component and package diagrams
- Analyse and translate current application and data landscapes and future business requirements into detailed logical data models.
- Strong metadata management (technical and business), incorporating metadata practices into all modelling activities.
- Analysis of source system including database structures, semi-structured and unstructured data stores.
- Understanding and assessment of source system schemas; table structures and relationships, primary / foreign keys, indexing, etc.
- Determining reference data domains and ranges and relationship to transactional data.
- Data mapping and transformation
- Mapping of source data elements to target models and data schemas using detailed logical data models.
- Ability to work with source system SMEs to determine correct mappings, transformations and gaps.
- Analysis and documentation of source to target data lineage.
- Data Discovery and Data Quality Assessment
- Detailed analysis of source system data structures and content to assess "fitness for purpose".
Required Skills and Experience:
- Experience in data analysis and modelling against transactional and analytical systems.
- Experience in the use of data modelling tools and the management of data modelling repositories and solutions.
- Experience in using data profiling, using both automated tools and hand coded SQL to determine data quality metrics, constraints, etc.
- Experience in the delivery of large scale, information management, information governance and analytics solutions
- At least 5 years of data modelling and analysis experience.
- Working knowledge of large enterprise relational database management systems comprising of traditional databases (MS SQL Server, Oracle) and cloud based platforms and solutions within AWS.
- Working knowledge of data governance frameworks, processes and technologies such as data catalogues and business glossaries.
Contact: 61-(02) 7207 6926 for more details.
Please note we will be able to contact only shortlisted candidates for this role. We thank you in advance for your interest.
Create a job alert for this search
Data Modeler and Analyst - Sydney • Sydney, NSW, AU
Similar jobs
Sydney Data Analyst – Sales Strategy & Ops (12-Month)
Chandler MacleodSydney, AUA recruitment agency based in Sydney is seeking a Data Analyst for a 12-month contract to support sales strategy and operations.This onsite role involves preparing insights, tracking KPIs, and requ... Show more
Accounts Data Analyst
VentiaNorth Sydney, AUJoin or sign in to find your next job.We’re seeking two analytical professionals to join our team as an.These newly created roles will support.Field Module contract with NBN Co.Flexible working arr... Show more
Director - Data and AI - Sydney
Slalom BuildSydney, AUSlalom is a fiercely human business and technology consulting company that leads with outcomes to bring more value, in all ways, always.From strategy through delivery, our agile teams across 52 off... Show more
Senior Databricks Specialist Lead | AI & Data | Sydney
DeloitteSydney, NSW, AUBe part of market-leading projects with global scale and complexity.Have your voice heard through people panels and leader forums.Prioritise in-person connection with your team and clients, with fl... Show more
Technical Business Analyst - Data Migration
Experis AustraliaSydney, AUTechnical Business Analyst - Data Migration.Technical Business Analyst - Data Migration.Get AI-powered advice on this job and more exclusive features.We are looking for an experienced Technical BA ... Show more
Senior Application Support Analyst | Sydney
DatacomSydney, AUAt Datacom, we combine technology, expertise, and talented people to help organisations thrive in a rapidly changing world.As one of Australasia's leading technology providers, we work with custome... Show more
Senior Investment Data Business Analyst - 9m
Anton Murray ConsultingSydney, NSW, AUOur client, a prominent asset management firm based in Melbourne, is seeking an experienced .Senior Investment Data Business Analyst.The ideal candidate must have extensive experience in fund manag... Show more
Senior SQL Developer ETL & Data Solutions
EVO Outsourcing SolutionsSydney, AUA dynamic recruitment firm in Sydney is seeking a Senior Consultant specializing in Talent Acquisition.The role includes designing and implementing database solutions, writing complex SQL queries, ... Show more
Senior Insights Analyst - Sydney/ Melbourne
RFI GlobalSydney, AUSenior Insights Analyst - Sydney/ Melbourne.Senior Insights Analyst - Sydney/ Melbourne.Be among the first 25 applicants.Get AI-powered advice on this job and more exclusive features.RFI Global is ... Show more
Senior Data Modeller
PaxusSydney, AUWe are looking for an experienced Senior Data Modeler to join our dynamic data team.The ideal candidate will bring a strong background in data solutions, with a proven track record in designing and... Show more
Analyst
ColliersSydney, AUColliers Sydney, New South Wales, Australia.Join or sign in to find your next job.Colliers Sydney, New South Wales, Australia.Get AI-powered advice on this job and more exclusive features.Direct me... Show more
AI/ML Solutions Architect — Data Cloud Pipelines
SnowflakeSydney, AUSnowflake is seeking a Technical Architect, AI/ML in Sydney to design solutions for AI/ML workloads using Snowflake and ecosystem tools.This role is highly technical and hands-on, building POCs wit... Show more
Senior Data Analyst — Remote & Flexible Analytics
Ernst & Young Advisory Services Sdn BhdSydney, AUSelect how often (in days) to receive an alert:.Select how often (in days) to receive an alert:.At EY, we’re all in to shape your future with confidence.We’ll help you succeed in a globally connect... Show more
Data Modeller
BLACKROC RecruitmentSydney, AUGet AI-powered advice on this job and more exclusive features.This range is provided by BLACKROC Recruitment.Your actual pay will be based on your skills and experience — talk with your recruiter t... Show more
Data Analyst
BeckonsNorthern Beaches, AUBeckons is seeking a Data Analyst to support the development and enhancement of our global data and reporting environment.In this role, you’ll work across Snowflake and Tableau to deliver accurate,... Show more
Sydney Commercial Property Research Analyst
Jamnet TeamSydney, AUCushman & Wakefield in Sydney is seeking a Paid Research Analyst to join the Australian Research Team.You will transform raw property data into actionable market insights and contribute to major ma... Show more
Digital Data Analyst - Insights & Dashboards, Hybrid (Sydney)
NOVA EntertainmentSydney, AUA leading audio entertainment company in Sydney seeks a Digital Data Analyst to enhance data quality and insights across the business.The role requires a degree in a quantitative field, strong data... Show more
Delivery Lead: Coding & Data Quality Solutions
BeamtreeSydney, AUA leading tech company in healthcare solutions in North Sydney is seeking a Delivery Manager.This role will lead the implementation of coding products and ensure timely delivery.Ideal candidates wi... Show more
Sales / Delivery Lead Data & Analytics
Find My New JobSydney, AUBe among the first 25 applicants.Get AI-powered advice on this job and more exclusive features.THIS IS A BRAND NEW PERMANENT ROLE WITH A LEADING ANZ PROFESSIONAL SERVICES CONSULTANCY.As the Data & ... Show more