Job Description

Fusion Professionals is a dynamic IT services company based in Sydney, Australia. We take pride in building a foundation of professionalism, responsiveness and trust with our clients and believe we have the best people that are driving sophisticated data solutions for our Clients.

Due to growth within our company we are in search for a talented Business Intelligence, Data Warehouse and Data Integration Specialist to join our team.

As a Data Specialist, you are responsible for the architecture, design, implementation and documentation of data models, data ingestion (ETL/ELT and Streaming), integration (API and batch) and the presentation of the data for consumption by end users and applications (BI and Reporting).

The successful candidate will be comfortable in taking a leadership role in client facing engagements, and in making presales and consulting presentations to prospects and customers. Depending on the seniority of the selected candidate, the position may also have direct reports who are data and integration engineers.

We like to empower and trust our people therefore you must be able to work independently without supervision, but also have the ability to be a great team member as we like to celebrate our successes and have fun!


KEY RESPONSIBILITIES:

- Design, develop and document data models

- Design implement and support streaming and batch data ingestion into application databases and data warehouses

- Determine feasible options to implement database objects, load processes, business rules and complex transformations
- Write reusable unit and functional test scripts
- Contribute to development and testing environment administration and operation
- Contribute and be part of a Community of Practices


You must be a Permanent Resident or Citizen in Sydney, Australia and available as soon as possible.

Requirements

Must Have

  • Permanent Resident or Citizen of Australia
  • Living in Sydney or happy to relocate
  • Knowledge & Experience:
    • Tertiary qualifications in engineering, IT or equivalent experience
    • 5+ years’ experience in Information Technology in Data Warehouse, Database and/or BI related roles
    • Understanding of relevant development life cycles and technologies
    • Experience with large scale application and infrastructure projects > 5 platforms
    • Strong experience in Database/Data Warehouse technologies - ideally Oracle, SQL Server and/or Snowflake
    • Strong experience in data modelling and associated tools
    • Strong experience with ETL/ELT development and related tools - ideally Talend, Matillion, DataStage and/or AWS Glue
    • Strong experience with BI tools - ideally Tableau, Qlik, PowerBI and/or Oracle Analytics Cloud
    • Experience with API integration - e.g. Boomi, Mulesoft, Azure Integration Services and/or Oracle Integration Cloud
    • Strong experience in translating high level requirements and designs into deliverables
    • Strong experience in a large scale, complex system integration projects in a cross domain, cross-partner, multi-application, multi-sourced technology environment
    • Experience working in Agile (SAFe) frameworks

Nice to Have

  • Strong interpersonal, written and verbal communication skills
  • Highly developed conceptual, analytical, problem solving skills and systems and process thinking
  • Ability to work under pressure
  • Ability to work on current initiatives and prioritise and balance work accordingly
  • At least 5 solid years of hands on experience designing data warehouse and/or data models
  • At least 3 solid years of hands on experience modern languages: Python, J2EE, C# ,JSON, XML,XSD, Scala
  • At least 3 solid years of hands on experience developing and enhancing ETL jobs
  • At least 3 solid years of hands on experience querying and profiling data
  • At least 3 years’ experience working in cloud data storage mechanisms (e.g. S3)
  • Experience with big data ecosystem technologies such as Kakfa, Cassandra, datalake (S3)
  • Excellent working knowledge of database data dictionary objects (any DB)
  • Familiarity with version control systems (Mercurial, Git, Perforce, Subversion)
  • Experience loading data from web services / cloud services / S3
  • Familiarity with BI/DW industry best practices
  • Familiarity with automated deployment methods & tools
  • Experience with dimensional data modelling principles (e.g. star and snowflake schemas, denormalised data stru
Save Job