Department of Foreign Affairs and Trade (DFAT)
RFQ No: 037-17
Role: EDW Specialist
Closing Date: 2:00 pm 8th April 18
Contract Start Date: Apr 18 to Mar 19
( 2x12 months extension)
NOTE:
- Please answer all questions in sections:
- YOUR RESPONSE, and
- SELECTION CRITERIA
- Attach Resume in Word format.
- Please submit all applications
- Direct email
- Respond quickly as the number of candidates allowed to be put forward maybe limited.
Item number / Description / Details
Proposed Work Order Start Date / April2018
Proposed Contract Period / April 2018 to 31 March 2019
Contract Option Period / 2 x 12 Months
Subject to funds availability and delegate approval
Number of Specified Personnel required / Up to 2
Reduced activity period / 25 December 2018 To 02 January 2019
Business Hours / From 7.00am to 7.00pm on a Business Day, unless specified otherwise.
Maximum of 40 hours per week unless given prior approval by the business area Branch Head
Replacing Specified Personnel / ☐ Clause11.6 Consequences of replacing Specified Personnel of the Terms and Conditions of Contract will apply
☒ Clause11.6Consequences of replacing Specified Personnel of the Terms and Conditions of Contract will not apply
Personnel Category of Specified Personnel / Period
See skill set identified above / for the term of the contract period (do not include contract option period)
Maximum no. of candidates / No more than two
Purpose of Services / DFAT Requires the services of an Enterprise Data Warehouse (EDW) specialists to work in the System Development and Enabling (SDE) section to provide specialist development, technical services and support for DFAT’s data warehouse and business intelligence capabilites.
Indigenous Opportunities Policy / ☐ Clause24 of the Terms and Conditions of Contract will apply
☒ Clause24 of the Terms and Conditions of Contract will not apply
Methodology / All work to be documented in accordance with DFAT’s standards and agreed Project Management Framework
Performance / Assigned tasks and applicable project milestones, as detailed in the relevant Project Plan, are met.
Specifications to be completed in accordance with DFAT’s standards and FMA certification requirements
Documentation / The Department may provide to the Vendor Department Material and the Vendor must ensure that the Departmental Material is used strictly in accordance with any conditions or restrictions specified in item 9 of the Deed Details and any direction by the Department.
Skills knowledge transfer / Clause 35 of the Deed applies (The contractor will be expected to transfer skills and knowledge to APS staff)
Selection criteria
Please note the importance of responding to this Selection Criteria.
Mandatory Criteria must be met to progress in the evaluation, where the Weighted Criteria is scored / Mandatory Criteria:
1. Demonstrated extensive knowledge, experience and ability in developing and delivering EDW and Business Intelligence (BI) solutions within agreed time, cost and quality expectations
2. Highly developed EDW design, development, and implementation skills. Must have a sound understanding of structured system lifecycle management methodologies and EDW concepts such as data analysis and dimensional modelling, data mart design, metadata management, ETL design and development, BI and reporting development, prototyping and agile approaches to solution delivery, data quality and governance.
3. Extensive knowledge and experience in supporting Microsoft SQL Server data warehouse and BI implementations, including Integration Service (SSIS), SQL Server, Analysis Services (SSAS), Reporting Services (SSRS) and PowerBI.
4. Ability to adhere to agreed standards and better practice frameworks for EDW architecture, project management and system development lifecycle management. Willingness and ability to effectively contribute to the development and maturity of quality control frameworks for ICT service delivery including EDW and reporting development, support and management.
5. Willingness and ability to contribute to continuous improvement of application development, quality assurance, support, and management frameworks for ICT Service Delivery. This includes contributing to maintenance and improvement of the development environment, tools, practices and procedures.
Highly Desirable:
6. Recent .Net and C# development experience would be highly regarded
7. Experience creating and maintaining applications that are secure and meet security assessment criteria. Including familiarity with the Australian Government Information Security Manual; experience with secure coding standards e.g. Open Web Application Security Project (OWASP).
Desirable:
8. Well-developed technical writing skills and experience maintaining technical documentation.
9. Excellent interpersonal skills with the ability to develop strong client relationships and translate business requirements to technology solutions.
10. Knowledge of the ITIL framework.
Security requirements, security clearances and police checks / NV1 OR NV2
Intellectual Property Rights – ownership of Contract Material / The Department owns the Intellectual Property Rights in Contract Material [unless Vendor ownership of Intellectual Property Rights in Contract Material (clause13.5) is selected below].
☐ Clause 13.5 of the Terms and Conditions of Contract (Vendor ownership of Intellectual Property Rights in Contract Material) is to apply
Limitation of liability – cap / $10 million in the aggregate
Insurance / As set out in Item 10 of the Deed Details
Fee structure / Hourly rates including both GST inclusive and exclusive rates, and quoted in either half or full dollars.
Other requirements
Eg Location /
- The Specified Personnel must:
(b)Facilitate transfer of skills and knowledge relevant to the Services to DFAT staff.
- The Specified Personnel may be requested to:
(b)undertake official DFAT travel
with prior approval of the business area Branch Head.
JOB DESCRIPTION
YOUR RESPONSE
Name / First Name / <candidate response>Surname / <candidate response>
Gender / <candidate response>
Your mobile number / <candidate response>
Your email / <candidate response>
Date of birth / <candidate response>
Home address / <candidate response>
Citizenship Status / Australian Permanent Resident Work Visa
Referee 1 / Name: / <candidate response>
Title:
Organisation:
Professionals relationship to you:
Phone:
Mobile:
Email:
Referee 2 / Name: / <candidate response>
Title:
Organisation:
Professionals relationship to you:
Phone:
Mobile:
Email:
Selection criteria
Mandatory Criteria:
1. Demonstrated extensive knowledge, experience and ability in developing and delivering EDW and Business Intelligence (BI) solutions within agreed time, cost and quality expectations
2. Highly developed EDW design, development, and implementation skills. Must have a sound understanding of structured system lifecycle management methodologies and EDW concepts such as data analysis and dimensional modelling, data mart design, metadata management, ETL design and development, BI and reporting development, prototyping and agile approaches to solution delivery, data quality and governance.
3. Extensive knowledge and experience in supporting Microsoft SQL Server data warehouse and BI implementations, including Integration Service (SSIS), SQL Server, Analysis Services (SSAS), Reporting Services (SSRS) and PowerBI.
4. Ability to adhere to agreed standards and better practice frameworks for EDW architecture, project management and system development lifecycle management. Willingness and ability to effectively contribute to the development and maturity of quality control frameworks for ICT service delivery including EDW and reporting development, support and management.
5. Willingness and ability to contribute to continuous improvement of application development, quality assurance, support, and management frameworks for ICT Service Delivery. This includes contributing to maintenance and improvement of the development environment, tools, practices and procedures.
Highly Desirable:
6. Recent .Net and C# development experience would be highly regarded
7. Experience creating and maintaining applications that are secure and meet security assessment criteria. Including familiarity with the Australian Government Information Security Manual; experience with secure coding standards e.g. Open Web Application Security Project (OWASP).
Desirable:
8. Well-developed technical writing skills and experience maintaining technical documentation.
9. Excellent interpersonal skills with the ability to develop strong client relationships and translate business requirements to technology solutions.
10. Knowledge of the ITIL framework.
Business Address: Suite 1802, 45 Clarence Street, Sydney, NSW-2000, Mailing address: Po.Box 153 Civic Square, ACT -2608,
Ph: 02 6108 3661, Fax: 02 6108 3662, E-mail: , ABN: 92 129 869 174