Data Modeler — Enterprise DW, Data Lake & BI

Pyramid Global Technologies; Western Australia; Hybrid; AUD 120,000 - 160,000; Full time

Job summary

Pyramid Global Technologies is seeking a data modeler to design, implement, and document enterprise data architecture and modeling solutions, focusing on dimensional and relational paradigms to support Horizon Power’s assets and BI initiatives.

You will lead conceptual/logical/physical modeling across ODS, data marts, data lakes, and RDBMS, govern standards, and collaborate with Engineering and Industrial teams while engaging clients onsite and remotely.

Qualifications

• Bachelor’s or master’s degree in computer/data science.
• 5+ years of hands-on relational, dimensional, and/or analytic experience.
• Experience with data warehouse, data lake, and enterprise big data platforms.
• Knowledge of metadata management and data modeling tools (Erwin or ER Studio).
• Experience in cross-functional teams and client engagement.
• Asset data exposure is a plus.

Responsibilities

• Design, implement, and document data models across conceptual, logical, and physical levels.
• Develop data platforms (RDBMS, ODS, data marts, data lakes) for Horizon Power.
• Govern data architecture and optimize query performance.
• Engage with clients onsite and remotely.
• Collaborate with Engineering and Industrial teams to deliver outputs.

Skills

Relational data modeling

Dimensional modeling

ETL/data ingestion

Data warehousing

Metadata management

Cross-functional collaboration

Client engagement

Education

Bachelor’s or Master’s degree in computer/data science

Tools

Erwin/ER Studio

ETL tools

Job description

Pyramid Global Technologies is seeking a data modeler to design, implement, and document enterprise data architecture and modeling solutions, focusing on dimensional and relational paradigms to support Horizon Power’s assets and BI initiatives.

You will lead conceptual/logical/physical modeling across ODS, data marts, data lakes, and RDBMS, govern standards, and collaborate with Engineering and Industrial teams while engaging clients onsite and remotely.