Solution Designer – Enterprise Data Warehouse

5 days ago

Council of the City of Sydney, Australia Paxus - Technology + Digital Talent Full time

Role Summary

We are seeking a skilled Solution Designer – EDW to join our Data & Analytics team. The ideal candidate will play a key role in designing scalable, high-performance data solutions that enable business insights and strategic decision-making across the organization. You will collaborate closely with business stakeholders, data architects, and development teams to design robust and efficient data integration and reporting solutions within an Enterprise Data Warehouse (EDW) environment.

Location: Sydney
Employment Type: 6+ month contract

Key Responsibilities

- Design end-to-end data solutions aligned with business and technical requirements.

- Collaborate with business users and analysts to translate requirements into effective data models and integration workflows.

- Develop and optimize complex SQL queries and ETL workflows using Informatica PowerCenter or similar tools.

- Ensure solution designs adhere to EDW architecture principles and best practices.

- Work closely with developers, testers, and data architects throughout the solution lifecycle.

- Contribute to performance tuning, data quality improvement, and process automation initiatives.

Must Have Qualifications

- 5–6 years of experience in solution design within Enterprise Data Warehouse (EDW) environments.

- Strong expertise in Teradata and a solid understanding of EDW architecture.

- Hands‑on experience with Informatica PowerCenter (or similar ETL tools).

- Advanced SQL skills with the ability to design and optimize complex queries.

- Strong analytical and problem‑solving skills with the ability to translate business needs into technical solutions.

- Sound understanding of data integration, ETL processes, and data flow across large‑scale systems.

Good to Have

- Proficiency in UNIX shell scripting for data process automation.

- Experience within the banking or financial services domain, particularly in data integration and reporting.

- Exposure to cloud platforms (AWS, Azure, or Google Cloud) and their integration with EDW systems.

- Familiarity with data modelling, data governance, and data quality frameworks.

- Awareness of data security standards and best practices in enterprise data environments.

To be considered for the role click the 'apply' button or for more information about this and other opportunities please contact Yash Kumar Jain on 03 8680 4235 or email: ykumarjain@paxus.com.au and quote the above job reference number.

Paxus values diversity and welcomes applications from Indigenous Australians, people from diverse cultural and linguistic backgrounds and people living with a disability. If you require an adjustment to the recruitment process, including the application form in an alternate format, please contact me on the above contact details.

#J-18808-Ljbffr

  • Data Solution Designer

    1 week ago

    Council of the City of Sydney, Australia Paxus - Technology + Digital Talent Full time

    About the Role The Solution Designer role sits at the intersection of data engineering, analytics, platform architecture, and project delivery, providing thought leadership and innovation for enterprise-grade data solutions. This role is accountable for the end-to-end solution design — from data extraction from source systems to ingestion, transformation,...

  • EOI-Senior Enterprise Solutions Analyst

    16 hours ago

    Council of the City of Sydney, Australia Camden Council Full time

    (EOI) Senior Enterprise Solutions Analyst SALARY: $ 107,876- 123,593 p.a. +Super Work Type:Temporary Full Time -Until 30 June 2026 - Enjoy a 35-hour workingweek - Flexibility through Flexleave provisions and hybrid work arrangements - Healthprogramincluding free flu vaccinations, skin checks and health andwellbeing leave options - Ample free parking -...

  • Urgent! Data Solution Architect

    3 weeks ago

    Council of the City of Sydney, Australia FinXL Full time

    Data Solution Architect Leading Government client (consulting through FinXL) FinXL Professional Services is a leading IT consultancy that partners with clients to bridge the gap between business needs and technology capabilities. Since 2003, we've been delivering high-value ICT services across government, finance, telecommunications, and enterprise...

  • ▷ 3 Days Left: Enterprise Data Architect

    2 weeks ago

    Council of the City of Sydney, Australia Pathway Search Full time

    We’re seeking an Enterprise Data Architect to define and drive the organisation’s data strategy, shaping how data is designed, governed, and leveraged across the business. This is a senior, hands‑on role with a focus on building a new Customer Data Platform (CDP), while partnering with multiple data teams and business units to deliver scalable, secure...

  • Solution Designer UX/UI

    3 weeks ago

    Council of the City of Sydney, Australia Resolution Life Group Services Limited Full time

    Solution Designer UX/UI page is loaded## Solution Designer UX/UIlocations: Sydneytime type: Full timeposted on: Posted Yesterdaytime left to apply: End Date: October 31, 2025 (19 days left to apply)job requisition id: JR695100**About Resolution Life**Resolution Life Australasia is one of the leading life insurers in Australia and New Zealand, with...

  • (3 Days Left) Head of data domain architecture and AI

    2 weeks ago

    Council of the City of Sydney, Australia Pathway Search Full time

    Head of Domain Architecture - Data & AI The role defines, designs, and maintains strategies and solutions that enable modern, scalable, and secure use of data and AI, while ensuring alignment with overall business goals and objectives. It encompasses developing data and AI models and architectures, establishing governance policies, ensuring compliance and...

  • ▷ (31/10/2025) Senior Data Engineer (Contract)

    1 week ago

    Council of the City of Sydney, Australia Advance Thinking PTY LTD Full time

    In this role you will be a member of a platform team, building the data and analytics platform. Location: Sydney (Hybrid Flexibility) Engagement: Contract (Likely Extensions) Client: Major Insurance & Financial Services Organisation Advance Thinking is seeking an experienced SeniorData Engineer with strong data capabilities to support a key regulatory...

  • Design Manager

    1 week ago

    Council of the City of Sydney, Australia CDC Data Centres Full time

    - Make Your Mark in this newly created position - CDC Academy learning and development opportunities - Located in Sydney CBD (Office) and Eastern Creek (Data Centre) About us: Established in 2007, CDC Data Centresis Australia’s leading operator of sovereign, secure, world-class data centre facilities. Headquartered in Canberra with multiple facilities...

  • Data Modeler

    3 weeks ago

    Council of the City of Sydney, Australia Cognizant Full time

    Position Summary Join Cognizant as a Data Modeler; collaborate with our experienced Engineering teams on exciting client projects where you will be able to create data models optimized across different data domains and for various purposes, working with enterprise requirements from business analysts, data architects, data administrators, database developers,...

  • 15h Left! Enterprise Solution Engineer

    2 weeks ago

    Council of the City of Sydney, Australia TeamViewer GmbH Full time

    About the role We are seeking a dynamic and technically astute Presales Engineer to join our team, focusing on our suite of solutions encompassing remote connectivity, remote management, and digital employee experience (DEX). In this role, you will be the technical bridge between our sales team and prospective clients, demonstrating the value and...