Data Warehouse Specialist

2 days ago

Sydney, New South Wales, Australia insightsoftware Full time

We are seeking a highly skilled Data Warehouse Specialist to join our team at insightsoftware. As a Senior Consultant, you will play a crucial role in analyzing business requirements and designing data warehouse implementations for our customers.

About the Role

This position reports directly to the Professional Services Manager and involves working closely with a cross-functional team to communicate with business stakeholders, customers, and end-users. Your primary responsibilities will include translating business requirements into data models, assisting with implementation planning and delivery, modeling, designing, and deploying data warehouses, fact tables, and dimensions.

Key Responsibilities
  • Translate business requirements into data models that lay the foundation for reporting and analytics.
  • Assist with implementation planning and delivery.
  • Model, design, and deploy data warehouses, fact tables, and dimensions.
  • Design and deploy Extract Transform Load (ETL) processes using SQL Server Integration Services (SSIS).
  • Design and deploy multi-dimensional cubes for and tabular models.
  • Interface with customers to gather technical requirements.
  • Understand customer's data flows and reporting processes around budgeting and planning processes.
  • Conduct information-gathering sessions with customers.
  • Document customer requirements to create maintainable applications following best practice guidelines on application and information design.
  • Implement one or more of our products for new and existing customers.
  • Maintain existing customer's applications.
  • Set-up, configure, and test components of customer solutions.
  • Integrate products with customers' ERP systems and other data sources under direction.
  • Assist system testing and rollout activities.
  • Assist with execution and reconciliation of data conversion.
  • Provide acceptance testing and post-implementation support.
  • Other tasks as requested by leadership.
Achievements/Goals within first 3-6 months:
  • Comprehensive four-weeks onboarding program in report authoring.
  • Shadowing/Assuming a role of a Senior developer on the first project under guidance of lead architect.
  • Coming up to a target billable utilization ratio in 5 months.
  • Be able to conduct meetings with customers in role of finance operations to document business requirements.
  • Assuming ownership of reporting projects in 3 months.
  • Ability to execute project implementation plans with or without help from Project Manager.
  • Regular accurate recording of worked hours and monitoring of project budget.
Qualifications

To be successful in this role, you will require:

  • 5+ years of experience with SQL/TSQL.
  • 3+ years of expert understanding of MDX multi-dimensional cubes or DAX tabular models.
  • 3+ years of experience with Microsoft SQL Server Management Studio, including SSIS and SSAS.
  • 3+ years of experience designing and deploying Extract Transform Load (ETL) architectures and packages.
  • Expert understanding of data management including star schemas, snowflake schemas, and data modelling techniques.
  • Experience working with Azure cloud environments and reporting applications.
  • Clear and effective communication skills.
  • Strong debugging, troubleshooting, and problem-solving skills.
Preferred Qualifications

We are looking for candidates with:

  • Strong Financial Modelling skills.
  • Experience with CALUMO, TM1, or other similar tools.
  • Experience in a customer services role (consulting) within the Finance function of an organization.
  • Excellent presentation, written and oral communication skills.
  • Ability to multi-task and prioritize multiple competing tasks.
  • Proficient in Microsoft Office Excel and Corporate Performance Management (ex. Cognos, Hyperion, SSAS – understanding dimensions, hierarchies and roll-ups).
  • Understanding ERP financial software solutions.
  • Understanding software life cycle.
About You

The ideal candidate should possess excellent communication skills, with the ability to work effectively with customers and internal cross-functional partners. They should also exhibit a strong desire to continue learning and growing with the company, as well as a can-do attitude and perseverance when faced with complex challenges.

Salary Range

The salary range for this position is $110,000-$140,000 per year, depending on location and experience.

Please note that insightsoftware offers competitive salaries and benefits packages, but we cannot provide sponsorship for candidates who are not eligible to work in the country where the position is located.

  • Data Warehouse Implementation Specialist

    2 weeks ago

    Sydney, New South Wales, Australia insightsoftware Full time

    Job OverviewThe Senior Consultant position at insightsoftware is an exciting opportunity to join our team as a Data Warehouse Implementation Specialist. In this role, you will be responsible for analyzing business requirements to design, deploy, and maintain data warehouse implementations for various customers across different industries.About the RoleThis...

  • Data Architect Lead

    4 weeks ago

    Sydney, New South Wales, Australia Data Privacy Full time

    Data Architect LeadThis role involves providing technical leadership to the project delivery teams through design reviews, advising on implementation best practices, and defining release processes. Key Responsibilities:Provide technical leadership to the project delivery teamsReview and refine the data delivery framework to enhance integration of new sources...

  • ETL Data Warehouse Lead

    4 weeks ago

    Sydney, New South Wales, Australia Cognizant Full time

    Key ResponsibilitiesAs a key member of our team, you will be responsible for performing E2E data warehouse testing for large programs, collaborating closely with the Business Support Team to understand requirements, and preparing test strategies. You will also identify testable scenarios, create and update requirement traceability matrices, and develop test...

  • Data Engineer

    1 week ago

    Sydney, New South Wales, Australia Data - AI & Data Science Full time

    Drive Business Value with Data Engineering at Domain GroupWe are seeking a skilled Data Engineer to join our Data Decision Science team in Sydney. As a key member of our data department, you will play a critical role in building scalable data pipelines that power Australia's property market.About the RoleThis is an exciting opportunity to work with...

  • Lead Cloud Data Architect in Sydney

    3 weeks ago

    Sydney, New South Wales, Australia Data Privacy Full time

    Job DescriptionTalented cloud data architects wanted to join our team at Data Privacy. This role is perfect for someone with expertise in AWS, S3, and cloud data platforms.About the RoleThis technical lead position involves leading the development of a new data warehouse platform, providing guidance to developers, reviewing data designs and models, and...

  • Data Warehouse Leader

    7 days ago

    Sydney, New South Wales, Australia MNF Group Full time

    Job DescriptionWe are seeking a highly skilled Data Warehouse Leader to join our team in Sydney. As a key member of our Data Warehouse team, you will provide technical leadership and guidance across engineering for our data warehouse platform.The role is a mix of hands-on (around 20%) and strategic work, focusing on developing our data capabilities across...

  • SAP Business Warehouse Specialist on HANA Platform

    4 weeks ago

    Sydney, New South Wales, Australia Attribute Group Full time

    SAP Business Warehouse Specialist on HANA PlatformAttribute Group is seeking a seasoned SAP Business Warehouse Specialist to join our team and contribute to our data management and reporting initiatives for the SAP transformation we are undertaking. The successful candidate will be responsible for the design, development, and optimization of our SAP Business...

  • Data Warehouse Expert

    2 days ago

    Sydney, New South Wales, Australia HiTech Group Full time

    HiTech Group is seeking a seasoned Data Warehouse Expert to join their highly multidisciplinary team. The successful candidate will be responsible for the development and maintenance of the Enterprise Data Warehouse, core reporting platforms, data policy, and the execution of transformational data projects.The ideal candidate will have experience in...

  • Data Warehouse Developer

    1 month ago

    Sydney, New South Wales, Australia Clicks IT Recruitment Full time

    Job Title: Data Warehouse DeveloperContract Length: 12 monthsLocation: Hybrid / remote - Office located in Sydney CBD - 3x days in office then work from homeThe Opportunity:The role involves joining our new markets team to support various internal teams and assist in budget production. This is an exciting opportunity to work on impactful projects in a...

  • Data Warehouse Leadership Position

    4 weeks ago

    Sydney, New South Wales, Australia MNF Group Full time

    Job Title: Lead Data Warehouse EngineerWe are seeking an experienced Lead Data Warehouse Engineer to join our Data Warehouse team in Sydney. As a key member of the team, you will provide technical leadership and guidance across engineering for our data warehouse platform.The role is a mix of hands-on (around 20%) and strategic work, focusing on developing...

  • Data Warehouse Solutions Architect

    4 days ago

    Sydney, New South Wales, Australia MNF Group Full time

    Lead Data Warehouse EngineerAbout the RoleWe are seeking a highly skilled and experienced Lead Data Warehouse Engineer to join our team in Sydney. As a key member of our Data Warehouse team, you will provide technical leadership and guidance across engineering for our data warehouse platform.This role is a mix of hands-on (around 20%) and strategic work,...

  • Warehouse Operations Specialist

    3 days ago

    Sydney, New South Wales, Australia Northline Full time

    Seeking a motivated and detail-oriented professional to fill the role of Warehouse Operations Specialist at Northline, an Australian-based global logistics business. About the RoleWe are looking for someone who is passionate about delivering exceptional customer service and ensuring the smooth operation of our warehouse.The successful candidate will be...

  • Senior Data Warehouse Architect

    4 weeks ago

    Sydney, New South Wales, Australia MNF Group Full time

    Job Title: Lead Data Warehouse EngineerWe are seeking a highly skilled and experienced Lead Data Warehouse Engineer to join our Data Warehouse team in Sydney. As a key member of our team, you will provide technical leadership and guidance across engineering for our data warehouse platform.The role is a mix of hands-on (around 20%) and strategic work,...

  • Data Insights Strategist

    1 month ago

    Sydney, New South Wales, Australia Data Privacy Full time

    Transformative Health Tech RoleMontu, a pioneering health tech company, is revolutionizing the alternative health landscape through technology-driven innovation. We're seeking a skilled PR Data Insights Specialist to leverage data insights and drive compelling public relations opportunities that resonate with various stakeholders.The ideal candidate will...

  • Data Warehouse Engineering Leader

    2 weeks ago

    Sydney, New South Wales, Australia MNF Group Full time

    We are seeking an experienced Data Warehouse Engineering Leader to join our MNF Group team in Sydney. As a key member of our Data Warehouse team, you will provide technical leadership and guidance across engineering for our data warehouse platform.This role is a mix of hands-on (around 20%) and strategic work, focusing on developing our data capabilities...

  • Warehouse Operations Specialist

    2 weeks ago

    Sydney, New South Wales, Australia Northline Full time

    About NorthlineNorthline is a reputable Australian-based global logistics business with an extensive national network and international reach into more than 100 countries.Job OverviewWe are seeking a highly skilled Warehouse Operations Specialist to join our St Marys Warehouse team. As a key member of our operations team, you will play a vital role in...

  • Data Centre Learning Specialist

    2 weeks ago

    Sydney, New South Wales, Australia Cdc Data Centres Full time

    About the RoleWe are seeking a highly skilled Data Centre Learning Specialist to join our L&D team at Cdc Data Centres. As a key member of our organisation, you will be responsible for designing, delivering, and managing technical-based training programs that support employee growth and career development.The ideal candidate will have exceptional written and...

  • IT Data Architect Specialist

    4 days ago

    Sydney, New South Wales, Australia Zone IT Solutions Full time

    We are seeking a highly skilled IT Data Architect Specialist to join our team at Zone IT Solutions in Melbourne, Sydney or India. This is a full-time position offering an attractive salary of AU$90,000 - AU$110,000 per annum.About the RoleThis key role involves designing, implementing and maintaining data models for clients' data warehouse solutions using...

  • Warehouse Operations Specialist Sydney

    2 weeks ago

    Sydney, New South Wales, Australia Qantas Airways Limited Full time

    Warehouse Operations SpecialistA competitive salary of $80,000 - $110,000 per annum is on offer for this exciting Warehouse Operations Specialist role in Sydney.About the RoleThis dynamic opportunity exists within Qantas Airways Limited to join our team as a Warehouse Operations Specialist based at our Sydney Distribution Centre.As a Warehouse Operations...

  • Data Warehouse Consultant

    3 weeks ago

    Sydney, New South Wales, Australia insightsoftware Full time

    Job Title: Senior Consultant, CALUMOJob SummaryThe Senior Consultant will be responsible for analyzing business requirements to model, design, deploy, and maintain data warehouse implementations for diverse customers across various verticals.This role reports to the Professional Services Manager and works closely with a team to communicate with business...