Job Search

Senior Data Warehouse Developer - Finance

Job Title: Senior Data Warehouse Developer - Finance
Contract Type: Permanent
Location: Sydney
Salary: $140,000 to $160,000
Reference: 305808378
Job Published: November 25, 2019 16:45

Job Description

Senior Data Warehouse Developer - Finance

Global business seeks consultative Data Warehouse Developer to help finance construct Kimball warehouse for Australia, then copy the processes to align with global data warehouse strategy.

  • Responsible for creating software code that will extract data from source systems, transform it as necessary and load it into data warehouses and/or into data marts required during the development, quality assurance and transition to production phases
  • Help data analysts run data profiling scripts and documenting the results
  • Create detail design specifications based on architecture and design specifications for the finance division
  • Document satisfaction of requirements in design specifications to help with requirements traceability
  • Participate in design specification quality assurance reviews involving a data integration architect and data integration designer
  • Create unit test data to ensure that the code performs under all expected conditions
  • Develop data integration software using SSIS (SQL Server Integration Services)
  • Conduct unit tests in a personal schema to ensure that the code meets the specification
  • Document test results and store test data and results in a project documentation repository
  • Participate in code reviews with data architects, lead developers, and other developers
  • Be accountable to the data integration architect for the quality of data warehouse developer deliverables
  • 5-10 years of experience working in a data warehouse environment using TSQL, Stored Procedures, 
  • 7+ years of experience in advanced SQL and be able to write complex logic using SQL as part of ETL, and use SQL effectively to perform complex data analysis and discovery
  • Ability to elicit requirements as a consultant from Finance and educate them on how data, reports etc should be done.
  • Must have experience constructing Kimball Warehouse
  • Essential T-SQL coding abilities
  • Demonstrated ability to troubleshoot, optimize and performance-tune existing SQL code
  • Demonstrated ability to perform data analysis/discovery and communicate results in business-friendly terms

Get similar jobs like these by email

By submitting your details you agree to our T&C's