Data ModellerWithGCP

XPT Software Australia; Sydney; On-site; AUD 120,000 - 160,000; Full time

Job summary

XPT Software Australia is seeking a Data Modeller to design conceptual, logical and physical data models across platforms. You will collaborate with business stakeholders and data owners to model current and new data platforms, with a focus on BigQuery in GCP and data warehousing solutions.

The ideal candidate has substantial experience with SQL, NoSQL, ETL processes, and data formats like XML, JSON and CSV, plus strong analytical and communication skills to enforce data governance and security

Qualifications

• 6+ years of professional IT experience with data modelling techniques.
• Proficiency in conceptual, logical, and physical data models.
• Experience with BigQuery and cloud-based data solutions.
• Knowledge of XML, JSON, CSV data formats.
• Excellent communication and stakeholder engagement.
• Certifications in data architecture/databases are advantageous.

Skills

Data modelling

GCP BigQuery

SQL

NoSQL

Data warehousing

ETL

Data security

Data governance

Cloud-based data solutions

Communication

Problem solving

Data architecture certifications

XML/JSON/CSV formats

Tools

BigQuery (tool)

Job description

Data Modeller
Proficiency in data modelling techniques, including conceptual, logical, and physical data models.

• Knowledge of database management systems, data warehousing, and ETL processes.
• Experience with modern data technologies, such as NoSQL databases, data lakes, and cloud-based data solutions.
• Experience in reading and writing moderate to complex SQL commands/queries and accurately assessing results.
• Ability to work with the business representatives, data owners, end users, application designers and data architects to model current and new data platforms in GCP Big Query.
• Should be able to define and enforce best practices for BigQuery data modeling experience.
• Strong understanding of data security, privacy, and compliance considerations in GCP.
• Must have a good understanding of various data formats XML, JSON, CSV, Database.
• Excellent problem-solving and analytical skills, with the ability to identify and resolve complex data-related challenges.
• Excellent communication skills, both written and verbal, with the ability to explain complex technical concepts to non-technical stakeholders.
• Familiarity with data governance frameworks and practices is a plus.
• Relevant certifications in data architecture, database management, or related fields are advantageous.
• 6+ Years of professional experience in IT industry with Data Modelling Techniques and Methodologies is preferred.