Senior Solutions Designer

Talent Insights Group; Melbourne; On-site; AUD 148,000 - 185,000; Part time

Job summary

Talent Insights Group is seeking a Senior Data Solution Designer to design and deliver robust data solutions across the region. You will translate business requirements into scalable data models using AWS cloud services and modern ELT tooling, collaborating with data engineers and BI specialists.

The role focuses on data quality, governance, and effective data delivery for Finance, Sales Ops, and HR. Based in Melbourne, the contractor will join a proactive team delivering enterprise reporting

Qualifications

• Strong technical capability with data tools and modeling approaches.
• Experience with 3NF, Kimball, and Data Vault data models.
• Proficient in Python and SQL for data processing and analysis.
• Knowledge of data warehousing concepts, data lakes, and governance.
• Experience with data quality, testing, and monitoring pipelines.

Responsibilities

• Partner with stakeholders to respond to data queries and provide datasets.
• Develop and implement data quality assurance processes.
• Translate business requirements into data models and mappings.
• Facilitate data design workshops and sessions.
• Support AWS-based data solutions using ELT tools and AWS services.

Skills

Python

SQL

AWS

Kimball modeling

Data Vault

Data warehousing

Data quality

Data analysis

Stakeholder engagement

ELT

Tools

Jupyter

DataGrip

Excel

Redshift

Athena

Glue

ETL

Job description

Senior Data Solution Designer ( AWS / Python / Kimball )

Sydney / Melbourne / Brisbane

Initial 6 month contract (scope to extend)

$800-1000 a day including super DOE

A technology company is seeking a Senior Data Solution Designer to design and deliver robust, user-friendly data solutions for internal business stakeholders across the region. Working with cloud technology and data integration tools, the successful candidate will translate business requirements into effective data models, improve data quality and investigate data issues.

The Role

The role works closely with stakeholders across functions such as Finance, Sales Operations, Commercial Excellence, Marketing and HR to understand their data needs and design practical, scalable data solutions. The successful candidate will join a collaborative, agile team of experienced data engineering and business intelligence specialists supporting enterprise reporting and data platforms.

Key Responsibilities

• Partner with stakeholders to respond to data queries, explain data measures and functionality, provide requested datasets, and investigate the root causes of data anomalies.
• Develop and implement data quality assurance processes.
• Translate business and data requirements into data models and mapping functions.
• Facilitate data design workshops and playback sessions.
• Support reliable, user-friendly corporate data solutions using AWS cloud technology and data integration/ELT tools.

Essential Skills and Experience

• Strong technical capability across data analysis tools such as Jupyter, DataGrip and Microsoft Excel.
• Experience with data modelling approaches, including 3NF, Kimball and Data Vault.
• Strong programming skills in Python and SQL.
• Solid understanding of data warehousing and data lake concepts.
• Experience with data analysis methodologies, statistical methods and data transformation functions.
• Strong analytical and problem-solving skills.
• Knowledge of data quality practices, including functional and regression testing, and pipeline alerting and monitoring.
• Experience investigating data anomalies and identifying root causes.
• Understanding of data management and data governance best practices.
• Ability to work independently, manage competing priorities and deliver across multiple projects.

Desirable Experience

• Strong communication and stakeholder engagement skills.
• Business data analysis experience, ideally involving CRM or ERP data models, longitudinal reporting or multivariate analysis.
• Experience working with AWS cloud services such as Amazon Redshift, Athena and Glue.

The Team

The successful candidate will join a growing team of senior data specialists across data engineering and business intelligence. The team works collaboratively and in an agile environment to deliver high-quality data solutions, support internal stakeholders and continually improve its data platform capabilities.