Power BI Data Modeller

Ingrity Pty; Sydney; On-site; AUD 100,000 - 140,000; Part time

Job summary

INGRITY, a Sydney-based Data & Analytics company, seeks a Power BI Data Modeller for a long-term contract to deliver data models, mappings, and governance across banking and financial services clients.

You will design conceptual, logical, and physical models, maintain data dictionaries, and collaborate with IT and analytics teams to drive dashboards and analytics models.

Qualifications

• At least 5 years of working experience in data modelling and data solution design in a fast-paced environment.

Responsibilities

• Develop and enhance conceptual, logical, and physical data models to support data analysis and business intelligence needs.
• Create and maintain current- and target-state data mapping documents.
• Define and manage standards, guidelines, and processes to ensure data quality.
• Develop and maintain metadata information including data dictionaries and catalogues, data lineage maps, and ER diagrams.
• Champion the role of data governance across the enterprise.
• Work with IT teams, business analysts, and data analytics teams to understand data consumers’ needs and develop solutions.
• Evaluate and recommend emerging technologies for data management.
• Support Enterprise Information Architecture Team advising on projects & BAU.
• Strong inter-personal skills and ability to work as part of a team.

Skills

Data modelling

SQL

Python

Data governance

BI reporting

Analyst collaboration

Tools

Erwin Data Modeler

Power BI

Azure Databricks

Snowflake

Hadoop

Spark

APIs

Azure

AWS

GCP

Job description

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.

Contract Engagement

Sydney CBD

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. As part of our growth strategy, we are inviting expressions of interest from eligible candidates to join our team and help our clients achieve their goals.

About The Job

This is a Power BI Data modeller role responsible for delivering Data models, design standards, end to end data mapping documents for our Banking and Financial services clients. The role is offered as a long-term contract position.

Responsibilities

• Develop and enhance conceptual, logical, and physical data models to support data analysis and business intelligence needs.
• Create and maintain current- and target-state data mapping documents
• Define and manage standards, guidelines, and processes to ensure data quality
• Develop and maintain metadata information including data dictionaries and catalogues, data lineage maps, and entity-relationship diagrams to help analysts and business users find relevant information for analysis and development of data tools such as dashboards and analytics models
• Champion the role of data governance across the enterprise
• Work with IT (Information Technology) teams, business analysts, and data analytics teams to understand data consumers’ needs and develop solutions
• Evaluate and recommend emerging technologies for data management.
• Support Enterprise Information Architecture Manager & Broader Enterprise Architecture Team advising on projects & BAU functions in the application of enterprise data architecture principles and standard
• Strong inter-personal skills and ability to work as part of a team

Key Skills & Experience

• At least 5 years of working experience working in Data modelling and data solution design in a fast-paced environment and complex business setting. Experience in data modelling, preferably in financial services.
• Strong proficiency in SQL and database query optimization and tuning
• Experience with data modelling tools such as Erwin Data Modeler and similar software as well as dimensional data warehouse methods (e.g., Data Vault) to support enterprise data integration and warehousing needs
• Experience working in close collaboration with data analysts and data scientists to deliver data for analysis and reports, business dashboards, and machine learning models
• Experience working with varied forms of data infrastructure inclusive of ERP (Enterprise Resource Planning) applications, relational databases,APIs, Platforms such as Azure Databricks or Snowflake, Hadoop, Spark
• Experience working with cloud big data platforms such as Microsoft Azure, AWS (Amazon Web Services), and GCP.
• Ability to utilize Business Intelligence tools (Power BI) to represent insights
• Strong SQL and Python skills to analyse data and provide insights

Non-Technical capabilities

Soft Skills

Exceptional written, verbal, and interpersonal communication skills to be able to bridge the gap between business and technical teams

Ability to work within complex and challenging data environments o Proven experience in collaborating with internal, analytics, reporting and data teams o Ability to work independently and multi-task to meet critical deadlines in a rapidly changing environment