Datawarehouse Developer

Summary about this job

Detail information about job Datawarehouse Developer. Terms and conditions vacancy

Our client, a highly reputable Australian-owned organisation based in Sydney's CBD, are on the lookout for a talented Data Warehouse Developer to join them on an initial 8 month Fixed-Term-Contract to cover someone on mat leave - this is a growing team so there is a good chance you will be given the chance to stay beyond the initial 8 months.

The Role:

As a Datawarehouse Developer, you will play a key, hands-on role in a team of 4 that develop and deliver solutions that enable the collection, transformation and management of data from one or more sources. This role will be integral in designing, developing and maintaining the Data Warehouse, Analytics and Operations related solutions & business processes. The role will be responsible for ensuring high levels of DW and BI availability through support functions and in-depth testing.

The ideal candidate will ensure smooth running of the Enterprise data warehouse operations including: reports, cubes, and packages and be responsible for implementing changes within SSIS and using Transact-SQL ETL. Furthermore, you will have a strong understanding of SSRS, SSAS, and dimensional modeling to leverage this data to create solutions that present data through reports, dashboards, scorecards, and KPI's.

Responsibilities:

• Troubleshoot ETL Packages & BI tools, systems, and software; performance-tune these applications as necessary.
• Drive the collection of new data and the refinement of existing data sources to continually improve data quality.
• Design and develop ETL processes to support population of the Enterprise Data Warehouse and general data movement needs.
• Design, develop, and implement cubes where appropriate and validate results with business representatives.
• Support implemented DW/BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.
• Design, code, test and document all new or modified BI systems, applications, and programs.
• Develop the semantic layer, metadata, reports, and report definitions.
• Assist in the design of databases and data warehouses to ensure interoperability with BI solutions.
• Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
• Accurately estimate and work within design/development/delivery estimates.
• Recommended limitations in current technical development process and advise on possible solutions to eliminate redundant processes.
• Close liaison with agile project teams, other IT developers and business users to understand requirements and receive feedback on solution designs.

To be considered for this role, you will have:

• 5+ years' commercial datawarehouse and business intelligence analysis and design experience, with full knowledge of datawarehouse methodologies and data modelling.
• 3+ years' comprehensive ETL design experience using SSIS and bespoke stored procedures to create jobs, functions and triggers to achieve optimal ETL results.
• Extensive SSIS and SSAS experience
• Demonstrated ability with SQL and T-SQL, development & support of relational databases database structures, theories, principles and best practices.
• Advanced knowledge of MS SQL databases using MS SQL Server 2005 and 2016.
• Demonstrated ability with conceptual and physical data model for relational databases, data warehouses and data marts for reporting requirements.
• Experience integrating systems both into and out of the data warehouse.
• Experience with version control (SVN, GIT) systems.
• Experience with Power BI (Desirable)
• Experience in creating technical design documents and data flow diagrams.
• Knowledge of MS Windows operating systems.

If you feel you have the required skills and experience required for this role, please 'Apply Now' or email Tom Watt at [email protected] for a confidential discussion to find out more.