Data Warehouse Lead

Summary about this job

Detail information about job Data Warehouse Lead. Terms and conditions vacancy

• Work for a leading, innovative and well respected global brand
• Fantastic staff benefits and career development opportunities
• Involvement with high profile national projects

Toyota Financial Services is the country's largest automotive financier. With over 30 years’ experience in the Australian market, an extensive network of regional offices and as a leader within the worldwide business group, we pride ourselves in understanding and listening to our guests.
  
We're well known in households and trusted by Australians and businesses to look after their financial needs, supporting them with vehicle finance and insurance, warranty solutions, fleet management services, commercial hire purchase and wholesale purchase.
  
Our unique culture, work approach and business practices make Toyota a successful, global company. We are about more than vehicles and vehicle finance – we are about achieving success in business the ‘right way’ through The Toyota Way philosophy, while continuing to support people and their communities.  Our commitment to Continuous Improvement and Respect for People mean our people support each other’s development and success to deliver our global vision of mobility for all. 
  
  
Reporting to the Data and Analytics Manager, your responsibilities will include:

• Manage program of works to upgrade and consolidate the data warehouse
• Own, manage, design, develop and test complex ETL processes
• Own, manage, design, develop and test various reports and multi-dimensional cubes
• Oversee and lead complex transformation activities such as normalisation, cleansing, aggregation, summarisation and integration
• Design automation processes to control data access, transformation and movement
• Develop logical and physical dataflow models for ETL applications
• Document all technical and system specifications for all ETL and BI processes
• Ensure source system data availability and update accessibility, data integrity, restart ability, and error handling
• Lead technical staff to investigate, analyse, and resolve complex technical problems related to system functions, environment, and procedures
• Identify and manage interfaces, service levels, standards, and configurations
• Ensure data quality
• Plan and conduct ETL and BI unit and development tests; monitor results and take corrective action
• Perform data analysis, data mapping, data loading, data validation and create workflow designs
• Mentor, develop and train less experienced ETL/BI developers

To ensure your success in this role, ideally you will have:

• Minimum of five years’ experience of working as an ETL/BI Developer/Leader in a large enterprise wide environment with large and complex datasets
• 6 to 10 years’ experience with IT projects and information development
• Strong business acumen with the ability to work with a diverse range of stakeholders
• Significant experience with data quality, data profiling, metadata management and reporting
• Sound knowledge of data governance and quality practices and principles

At Toyota Financial Services we value the contribution you’ll deliver to our business; you’ll be offered a range of great benefits such as the MY-CAR suite of benefits to ensure you can drive a new Toyota for less, financial support for relevant study and support joining professional associations and networks, work-life balance initiatives including paid parental leave, health and wellness initiatives and a variety of offers and discounts from our partner networks.
  
If you’re successful, you’ll undergo background verification checks before you start employment with us.
  
If you’re keen to join an organisation that recognises the value you add to our business and this is the role you've been looking for, we'd love to hear from you.