Connecting...

W1siziisimnvbxbpbgvkx3rozw1lx2fzc2v0cy9wzxjpz29ulwdyb3vwl2pwzy9iyw5uzxitzgvmyxvsdc5qcgcixv0

Job Search

Senior Data Warehouse Developer - Finance

Job Title: Senior Data Warehouse Developer - Finance
Contract Type: Permanent
Location: Sydney
Industry:
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.

MAJOR DUTIES AND RESPONSIBILITIES:
  • 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
JOB-RELATED SKILLS/COMPETENCIES
  • 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