Data ModellerWithGCP

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

Job summary

XPT Software is seeking a Data Modeller to design and align data platforms across on-prem and cloud environments. The role focuses on defining data structures, improving data quality, and enabling reliable reporting for business decisions.

The candidate will collaborate with data owners, architects, and engineers to implement best practices in BigQuery data modeling, data governance, and security within GCP, ensuring scalable and compliant data solutions.

Qualifications

• 6+ years of professional experience in IT with data modelling techniques and methodologies.
• Strong knowledge of data warehousing, ETL processes, and SQL.
• Experience with NoSQL databases, data lakes, and cloud-based data solutions.
• Expertise in modeling data platforms using GCP BigQuery.
• Ability to define and enforce best practices for data modeling in BigQuery.
• Understanding of data security, privacy, and compliance in cloud environments.
• Familiarity with XML, JSON, and CSV data formats.
• Excellent problem-solving and analytical skills.
• Strong communication skills to explain complex concepts to non-technical stakeholders.
• Knowledge of data governance frameworks; relevant certifications are advantageous.

Skills

Data modelling

Data warehousing

ETL

NoSQL

Data lakes

Cloud data solutions

SQL

GCP BigQuery

BigQuery modeling

Data security & privacy

Data formats (XML/JSON/CSV)

Problem solving

Communication skills

Data governance

Data architecture certifications

Stakeholder management

Tools

BigQuery

GCP

Job description

Job description

Data Modeller

• 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.