location: Sydney | job type: Architect / Consultant| salary range: $120,000- $140,000 | job type: Full -Time
The BI Technical Architect is an expert well-versed in Data Warehousing and Business Intelligence technologies, and has proven experience in building the framework necessary to deliver reports, analytics and dashboards in several functional areas.
Essential Duties/Responsibilities
- Provide strong and effective leadership in building robust, high-performance and low-maintenance BI solutions
- Partner with BI Information Architect to develop and populate database models that meet reporting and analytic requirements
- Lead technical team in the development of ETL solutions to ensure data is sourced from appropriate internal and external systems
- Ensure that infrastructure needs are anticipated and planned to provide strong development platforms and robust production solutions
- Provide strong project leadership expertise for individual projects by leading a team of developers, establishing schedules, tracking and document progress and results
- Own end-to-end technology architecture for BI platform
- Provide programming expertise in the development of applications – from systems design to tested product
Career Experience
- 7-10 years development and analytical experience in the BI space
- Experience with project software including Visio and MS Project
- Provide leadership in the delivery of business applications – through system requirements, design, development, testing, implementation, production support and documentation for all phases
- Provide ongoing production support for existing solutions; provide leadership in reducing support by developing long-term solutions for chronic issues
- Provide technical consulting and support in all areas within the BI platform, and all relevant system interfaces
- Work closely with Business Analyst at every phase of development cycle to ensure alignment of solutions with requirements
- Strive to provide automated, repeatable solutions for BI process flow and ensure data quality at every step
- Anticipate and identify issues as they arise; monitor and report to management on the status of efforts
- Lead technical team by example in documentation, communication and knowledge management practices
- Innovate for improving overall quality of solutions and team efficiencies
Qualifications
- Knowledge and experience in gathering requirements, functional design, and working with business processes
- Strong analytical, problem solving and conceptual skills
- Strong technical skills to translate business requirements into specifications
- Technical knowledge and extensive experience in the DW space
- SQL Server 2005/2008 development and technical architect experience; proven experience in developing and debugging complex queries; strong background in Data Warehousing principles and dimensional models; proven experience in sourcing from OLTP applications and data models; low-level DBA experience and ability to use system tables desirable
- SQL Server 2005 SSIS development skills – ability to develop, debug, deploy and maintain SSIS packages
- ETL development experience
- Technical knowledge and familiarity with user interface tools
- Technical knowledge and familiarity with .NET 2003 and/or 2005 development; experience desirable, not a must
- Technical knowledge in relevant middleware – in Windows platform
- Strong verbal and written communication skills
- Strong interpersonal skills to be an effective project leader
Data Talent is exclusively focused on Business Intelligence, Business Performance Management, Data Warehouse & Big Data Recruitment across Australia. We are committed to your personal and professional career development.