Solution Designer

3 weeks ago

Sydney, New South Wales, Australia Expert360 Full time
Connecting Experts to Great Opportunities
  • Title: Solution Designer (Solutions Architect)
  • Location: Sydney, Australia
  • Work Model: Hybrid
About Expert360

Expert360 empowers more than 42,000 (and growing) elite professionals around the world to find great work and be successful. Expert360 was founded in 2013 with a simple but powerful mission - to connect amazing people with great companies to get important work done.

We believe in choice, flexibility and empowerment. We believe if you can change the world of work, you can change the world. Come and join us in defining and bringing to life the future of work

Key responsibilities
  • Extensive experience in data engineering and solution design at a senior level, with deep expertise in Informatica (IDMC/CDI, PowerCenter).
  • Strong background working with complex, legacy data platforms (e.g., Oracle, DB2, custom-built systems) and understanding how to integrate, migrate, and optimize them.
  • Solid knowledge of SQL, PL/SQL, Oracle, Postgres, and other RDBMS.
  • Demonstrated success in large-scale migration, re-platforming, or modernization projects, especially those involving legacy or batch-oriented data sources.
  • Experience with data modelling (relational, dimensional, operational) and governance (row-level security, column-level security).
  • Solid understanding of Agile methodologies and tools (JIRA, Confluence).
  • Familiarity with data visualization tools such as Tableau, Looker, or Power BI to surface insights from complex datasets.
  • Excellent problem-solving skills and ability to engage effectively with both technical and non-technical stakeholders.
  • Experience of working within a financial services env.
To be successful in this role you will have
  • Design and implement scalable data solutions using Informatica IDMC/CDI, PowerCenter, and related ETL tools across large, diverse data platforms.
  • Lead solution design efforts for large-scale migration and integration projects, including inventory data analysis, impact assessments, and detailed data flow diagrams.
  • Develop and optimize complex ETL pipelines ensuring high performance, data integrity, and operational efficiency within on-premises and hybrid environments.
  • Drive the modernization and reengineering of legacy data warehouses and ETL workflows (e.g., Oracle, custom platforms) into robust, maintainable architectures.
  • Collaborate with cross-functional teams to translate business requirements into practical, scalable technical solutions that account for the complexities of legacy data sources.
  • Create and maintain technical documentation including solution designs, mapping specifications, and workflow designs.
  • Implement robust data validation, governance, and quality frameworks using Informatica IDQ and related tools.
  • Apply CI/CD practices using tools like Bitbucket and GitHub Actions to streamline and automate deployments.
  • Conduct performance tuning of ETL jobs, SQL queries, and batch processes, optimizing resource use across a variety of systems.
  • Provide mentorship and technical leadership to team members, delivering knowledge-sharing sessions on best practices for integrating and modernizing complex, high-volume data systems.
Seniority level
  • Mid-Senior level
Employment type
  • Full-time
Job function
  • Design

We're unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr

  • Solution Designer

    2 weeks ago

    Sydney, New South Wales, Australia Mane Consulting Full time

    OverviewJoin to apply for the Solution Designer role at Mane Consulting .This financial services industry leader, where innovation, excellence, and integrity are the cornerstones of everything they do, requires a Solution Designer and is dedicated to driving financial empowerment and success for its stakeholders through innovative data solutions. The team...

  • Solution Designer

    2 weeks ago

    Sydney, New South Wales, Australia Westpac Full time

    Help deliver multiple initiatives across our Board Strategy Review (BSR)- Agile work environment- Sydney based hybrid work from office and homeSeeking an experienced Solution Designer to join the Mortgages Product and Servicing (P&S) Delivery Train. This role is to work on multiple initiatives, across multiple Delivery Squads to deliver the Board Strategy...

  • Solution Designer

    3 weeks ago

    Sydney, New South Wales, Australia Mane Consulting Full time

    OverviewJoin to apply for the Solution Designer role at Mane Consulting.This financial services industry leader, where innovation, excellence, and integrity are the cornerstones of everything they do, requires a Solution Designer and is dedicated to driving financial empowerment and success for its stakeholders through innovative data solutions. The team...

  • Solution Designer

    3 weeks ago

    Sydney, New South Wales, Australia Mane Consulting Full time

    Overview Join to apply for the Solution Designer role at Mane Consulting. This financial services industry leader, where innovation, excellence, and integrity are the cornerstones of everything they do, requires a Solution Designer and is dedicated to driving financial empowerment and success for its stakeholders through innovative data solutions. The...

  • IT Solutions Designer

    2 weeks ago

    Sydney, New South Wales, Australia beBeeSolution Full time $118,644 - $143,534

    Solution Architect RoleThe Opportunity:We seek a skilled IT professional to fill the role of Senior Solutions Architect.You will bridge business needs with technology solutions, driving sales success through strategic design and delivery.Our team values innovative thinking, collaboration, and results-driven professionals who can deliver exceptional value to...

  • It Solution Designer

    2 weeks ago

    Sydney, New South Wales, Australia Group Enablement Full time

    **About Woolworths Group**Woolworths Group is a food and everyday needs retailer united by the shared purpose of creating better experiences together for a better tomorrow. With more than 1,400 stores across its Woolworths Supermarkets, Countdown Supermarkets (New Zealand) and BIG W brands, and fast-growing eCommerce businesses, Woolworths Group is Australia...

  • Solutions Designer

    2 weeks ago

    Sydney, New South Wales, Australia Grow Talent Full time

    **About the Client**:Our client is a leading infrastructure solutions provider, pioneering the data storage revolution. As industry leaders, they've developed an innovative Universal Storage platform, transforming how organizations manage and optimize their data storage solutions.**Impact You'll Have**:As a Storage Solutions Designer, you will be a key...

  • Solution Designer

    2 weeks ago

    Sydney, New South Wales, Australia Westpac Full time

    Westpac Group has a rich heritage and offers employees a multitude of opportunities. We aim to attract the best people inside and outside of the business - building an organisation where the best talent thrives.The Westpac Group has a complex Information Technology environment that needs to deliver to the rapidly changing needs of our customers and...

  • Solution Designer

    2 weeks ago

    Sydney, New South Wales, Australia Insignia Financial Ltd Full time

    Solution Designer (Marketing Technology)**Location**:SYDNEY, NSW, AU, 2000HOBART, TAS, AU, 7000DOCKLANDS, VIC, AU, 3008**Employment Type**:Permanent Full Time**External Advert**:- Put your fingerprints on the future to progress your career- Make a difference, make it meaningful- Designing the future of marketing through innovative tech solutions**The...

  • Solution Designer

    2 weeks ago

    Sydney, New South Wales, Australia Ing Bank N.V. Full time

    At ING Australia, you will have the chance to build a career as unique as you are, with the global scale, support, inclusive culture, and technology to become the best version of you.ING Australia is on the search for Solution Designer to join our Tech Architecture team at ING.You will be playing a key role in the design of interesting and wide-ranging IT...