Data Modeler

**Location**: Sydney

**Job Type**: Contract

Are you a talented Data Modeler with expertise in Snowflake and Power BI? Do you have a passion for transforming data into actionable insights? Join our esteemed team at **INGRITY**, where your skills as a Data Modeler will be critical in delivering value to our clients.

**About INGRITY**

**INGRITY** is a Microsoft Data and AI Solution Partner dedicated to delivering transformative data and AI-driven solutions. We collaborate with some of the best ASX-listed companies and medium-sized businesses, working closely with Microsoft to create measurable value for our customers. Our success is built on innovation, customer advocacy, and a strategic partnership with Microsoft.

**About the Role**:
We are looking for a talented Data Modeler to join our team immediately and contribute to an ongoing project. This role demands expertise in data modeling and analytics, creative problem-solving, excellent communication skills, and a dedication to continuous learning. You will work closely with team members and clients across various levels to deliver data assets that align with strategic goals.

**Key Responsibilities**:

- Design, develop, and optimise data models for analytical and reporting purposes using Snowflake.
- Build interactive dashboards and reports using Power BI to visualise complex datasets.
- Create logical and physical data models to support business reporting and dashboards, using both structured and unstructured data sources.
- Structure data optimally for reporting purposes, employing techniques like normalisation for relational models or denormalisation for data warehouses (e.g., star schema, snowflake schema).
- Define and implement data transformation logic, preparing raw data into usable forms for reporting, including aggregations, calculations, and time-series formatting.
- Collaborate with stakeholders to understand business requirements and translate them into scalable data solutions.
- Ensure data integrity and compliance with data governance policies.
- Optimise data model performance and resolve pipeline issues.

**Your Technical Skills and Experience**:

- Experience: 5+ years of proven expertise in data modeling with strong proficiency in Snowflake and Power BI.
- Data Models: Skilled in designing logical and physical data models for reporting purposes.
- Database Design: Proficient in database design principles such as normalisation, denormalisation, star and snowflake schemas, entity-relationship modelling, and reference data management.
- Technical Expertise: Hands-on experience with SQL and efficient database structure design. Familiarity with cloud platforms like Azure or AWS is a plus.
- Data Warehousing: Strong understanding of data warehousing concepts, dimensional modelling, and ETL pipelines.
- Data Solutions: Proven ability to design and implement large-scale data solutions for loading, manipulation, processing, analysis, and exploration.
- Problem-Solving: Demonstrated initiative and problem-solving skills, with innovative approaches to data management that ensure accurate and timely outputs.
- Master Data Management: Solid understanding of master data management principles and processes.
- Interpersonal Skills: Strong interpersonal skills with the ability to build relationships, consult, negotiate, liaise, and influence stakeholders. Able to provide strategic advice and recommendations to internal and external teams.

**How to Apply**:
If you are a talented Data Modeler with expertise in Snowflake and Power BI, and you're excited about the opportunity to contribute to our data-driven success, please submit your resume, highlighting your relevant experience and achievements.

**Additional Information**:

- Location: Sydney, Australia

Join **INGRITY** and help us shape the future of data and AI solutions

**About INGRITY**:
We are a fast-growing, progressive Sydney-based data & analytics company. We service many large corporates and SMBs in the financial services sector, to derive value from data. At Ingrity, we are committed to building a diverse and inclusive workforce to deliver value to customers. As a value-driven organisation, we nurture and support our people by having a laser-sharp focus on skill and talent development, collaboration, and flexibility.