Data Modeller
Share
Job Location:
Monthly Salary:
Posted on:
Yesterday
Vacancies:
1 Vacancy
Job Summary
Position Description:
Recognised as one of the worlds largest IT and business consulting firms CGI has offices across Australia supporting local public and private sector clients to solve real business problems.
We are looking to hire a Data Modeller who will focus on translating complex business requirements into clear scalable conceptual logical and physical data models that support analytics reporting and operational needs. Working closely with data engineers analysts and business stakeholders the Data Modeller ensures that data is well-organized standardized and aligned with governance and quality frameworks to enable efficient data-driven decision-making across the organization.
Flexible work is available including hybrid work from clients site at Port Melbourne.
Your future duties and responsibilities:
Contribute to the design development and continuous refinement of conceptual logical and physical data models within the Data Transformation team.
Create and maintain SQL DDL scripts along with detailed mapping and ETL documentation to support Data Engineers in constructing and loading data models.
When required carry out reverse engineering of existing data models from databases or SQL code to ensure alignment with current architecture and standards.
Develop and update business documentation including process maps taxonomies and ontology diagrams to provide clarity and traceability of data flows.
Maintain a strong emphasis on conceptual and business data modelling ensuring that structures align with organisational objectives.
Interpret and translate business requirements into scalable data models that support long-term analytical and operational needs.
Assist in managing and maintaining controlled vocabularies and the corporate data catalogue to promote consistency and reuse of data assets.
Participate in modelling workshops and collaborative sessions with other Data Modellers to align on best practices and design approaches.
Adhere to existing Data Quality and Data Governance frameworks contributing to their ongoing enhancement and ensuring compliance with modelling standards.
Build and maintain effective working relationships with subject matter experts and business stakeholders across the organisation.
Keep stakeholders and senior management informed of prioritisation decisions project progress and delivery timelines managing expectations clearly and proactively.
Required qualifications to be successful in this role:
Sound understanding of data modelling methodologies including Kimball Inmon Top-down/Bottom-up Relational and Dimensional Modelling Data Warehousing and 3NF approaches.
Ability to think conceptually and apply modelling techniques such as generalisation subtyping and super-typing to create efficient and flexible models.
Skilled in producing Entity Relationship Diagrams (ERDs) using a range of notations such as Crows Foot and UML.
Strong technical understanding of databases ETL/ELT pipelines and programming languages (typically SQL) with the ability to connect these technologies to data modelling practices. (This is a hands-on role involving active work with data.)
Solid comprehension of business processes with the ability to capture requirements accurately and translate them into effective technical designs.
Confident communicator capable of engaging in technical discussions with both technical and non-technical audiences across all organisational levels.
Experience with cloud-based data technologies would be advantageous particularly within the Microsoft Azure ecosystem including:
o Azure Data Lake
o Azure Data Factory
o Azure Databricks (SQL and Python)
o Azure SQL Server
o Azure DevOps / Git
Skills:
- Azure Data Factory
- Azure Data Lake
- Azure DevOps
- Python
What you can expect from us:
Together as owners lets turn meaningful insights into action.
Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because
You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.
Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.
Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.
Come join our teamone of the largest IT and business consulting services firms in the world.
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
About Company
The COMPANY is one of the few end-to-end consulting firms with the scale, reach, capabilities and commitment to meet clients’ enterprise digital transformation needs. Our 77,500 consultants and professionals work side-by-side with clients in 10 industries across more than 400 location ... View more
