POSITION DESCRIPTION
ACSO Position Description – Senior Data Warehouse (BI) Analyst / Developer June 2015 Page 1 of 6 Position: Department: Award: Award Classification Reports To: Date of Review
Senior Data Warehouse (BI) Analyst / Developer
Business Services SCHCADS
Level 5, Pay point 3
Chief Financial Information Officer April 2016
Australian Community Support Organisation (ACSO)
Established in 1983 as a drop in centre for ex prisoners, ACSO is a courageous organisation with a vision to create a safe
and inclusive community freed of crime and prisons.
It’s our goal to reduce re-offending and our mission is to help people transition from prison, assist them in the
community, stop them from re-offending and divert others from committing crime. Our ethos is simply to create another
chance; to promote recovery and to support rehabilitation and re-integrating people back into the community.
Our commitment to our vision and mission has seen ACSO become a “provider of choice” in the delivery of forensic services and programs for people who are transitioning from prison back into the community, along with those with complex and multiple needs who are in or at risk of entering the criminal justice system”.
We offer innovative services responding to unemployment, mental illness, disability, homelessness, substance use and offending behaviour throughout the metropolitan area and regional Victoria. These services are delivered through our ‘wrap around’ service delivery model that integrates ACSO’s Housing, Complex Care, Clinical, Employment and Community Enterprise Divisions to achieve better outcomes for our clients and the communities we serve.
DEPARTMENT / SECTION
ACSO’s Business Services Group provides the following support to ACSO’s operations; Finance
Facilities Management ICT ; and
Client Management System Services
POSITION OBJECTIVE
The Senior Data Warehouse (BI) Analyst / Developer will act as a technical lead and supporting new areas of data and information analysis. The candidate will liaise between Report Development, Program - and Executive Management as well as ICT. Focus will be on business analysis, reporting design and review, improving the application framework and enforcing standards. Required is a dynamic, flexible disposition in order to react to current challenges of the day. The platforms supported in this role include the Microsoft Analytics Platform System, Jaspersoft and Penelope CMS / Progress. This role performs the complete (Data) Mart lifecycle, including data profiling, design and development, debugging/testing, and support and enhancements. Through the analysis of the new (Data) Marts you’ll be making important contributions to our programs. We’re looking for someone who is data-driven, a great communicator, naturally curious, a natural drive to jump in and help us grow this area.
This is a key role within the CMS/BI team and you will be given the opportunity to take the lead in all things data warehouse. This role will suit a self-motivated and passionate individual who really wants to get stuck in using a variety of leading technologies.
KEY WORKING RELATIONSHIPS Internal
Chief Financial Information Officer ACSO Executive Team
Senior Manager Finance (SMF) Group Operations Managers Senior Leadership Team
External
ACSO Position Description – Senior Data Warehouse (BI) Analyst / Developer June 2015 Page 2 of 6
POSITION SPECIFIC RESPONSIBILITIES & ACCOUNTABILITES
Characteristics, Responsibilities & Requirements Measures of success Characteristics
Level of Guidance
Works under the general guidance of senior employees, applying high levels of knowledge and skills
Definition of tasks
Involved in developing business case Staff supervision
Supervises contractors as required Time Management
Manage own workload and demonstrate high level interpersonal skills to resolve issues around organisational performance.
Responsibilities
Deliverable
Deliver data warehouse related outcomes that serves our management and stakeholders
Review, evaluate and prepare periodic activity and progress reports
Analysis/Design
Develop ETL code meeting technical specifications and business requirements according to the established designs and framework
Profile and understand the large amounts of source data available, including structured and semi-structured/web activity data
Work with data originators to fill in gaps in the data collected, and/or to adjust source-system data structures to facilitate analysis and integration with other company data.
Gather reporting and analysis requirements and translate into reporting structures data models, including aggregate tables, pivoted tables, and relational and dimensional (star-schema) marts. Design/Development
Research, evaluate, identify alternative design and test approaches, and lead code reviews
Input to the Data Architecture process
Proactive and diligent in identifying and communicating development issues and recommending potential solutions
Front-end development
Coding, installation and testing of SSDT (SSIS) ETL packages
Document technical designs to ensure clients’ needs are captured
Development/Testing
Troubleshoot development and operational problems and provide timely solutions
Participation in system and integration test Identify and remedy solution defects
Conduct ETL performance tuning, troubleshooting, support, and capacity estimation.
Conduct thorough testing of ETL code changes to ensure quality of data produced
Leadership
Take the lead in data warehouse ETL development activities
Leading successful design and delivery of complex data warehouse solutions
Assists in planning, organizing and controlling data
Project Planning
All projects are accurately planned and delivered according to planning. Planning is updated when required.
Documentation
All reports and other information deliverables are well documented in terms of requirements, specification, checklists, design and development information.
Data Warehouse Architecture
The data warehouse architecture is always kept up-to-date.
Source Code
All source code is well structured and includes clear comments.
Test Environment
Data warehouse is embedded in a structured test environment with clear and effective test procedures.
ACSO Position Description – Senior Data Warehouse (BI) Analyst / Developer June 2015 Page 3 of 6 warehouse related activities
Operate as a team player to drive solutions for the good of the organisation
Collaboration
Build strong partnerships, demonstrate integrity and build trust with all stakeholders
Primary point of contact for interaction with other business units and teams in the context of data warehouse requirements
Consults with program management in the analysis of short and long-range business requirements and recommends innovations which anticipate the future impact of changing business needs
Provides consulting and leadership in identifying and implementing new uses of information and data warehouse technologies that assist the functional business units in meeting their strategic objectives Provide data warehouse related insights and advice
to management in a non-technical way
Coordinate data warehouse related activities with the Program Management and ICT
Administration
Ensuring accurate and complete replication of applicable data during the available time windows Setup and administration of SQL Server Data tools
(SSIS) packages Maintenance
Repository management
Collision detection to avoid loss of data
Occasionally the data warehouse administrator may be required to create or restore consistency to the data by writing insert, update, or delete statements against the database.
Cube Creation and maintenance if required Setting up the tolerances on the database systems
to stop runaway queries Database maintenance
Trouble shooting and able to direct system and network performance issues to the responsible area Spotting trends in queries and creating and
maintaining summary tables for low-performing queries where possible
Installation, testing and deployment of the any additional server related software, if applicable Security
Reviews the disaster recovery plan to ensure that new systems promote uninterrupted systems operation
Creating security profiles and granting privileges User Support
Being first on call for performance issues from the users
Assist the users in writing well-performing SQL based queries
Assuring new users have taken training
Teach, mentor, and lead junior developers including best practices
Help in knowledge transfer to the business/client and other technical teams
Provide day-to-day support and mentoring to end users who are interacting with the data.
Making the end user Business Intelligence (BI) toolsPro-Active Approach
All program managers are always informed about the latest (im)possibilities of the data warehouse.
Performance
The performance of the data warehouse is such that (internal) customers are happy. Version Control
The versions of the various data warehouse components are always up-to-date.
Backup
Adequate backup solutions are in place that are well tested and effective.
Data Governance
Data governance framework is implemented and regularly tested.
Security
In case of any security breaches security related plans are auctioned quickly and are effective.
User Support
All users of the data warehouse are well educated and able to use the various services without any hick-ups.
ACSO Position Description – Senior Data Warehouse (BI) Analyst / Developer June 2015 Page 4 of 6 aware of any new tables
Requirements
Architecture
Solid experience in developing (complex) data warehouse solutions
Development/Tools
Advanced SQL coding/querying skills Physical Database Design/Maintenance
Assignment of data types, null ability, and defaults for new columns
Creating the databases and database objects such as the tables, schemas, synonyms, views, triggers, stored procedures, defaults, and indexes
Periodic table reorganisation
Structure update with change control
Hands-on experience with one or more ETL development tools e.g. Microsoft Analytics and Jaspersoft
MS SQL Server 2012 (SQL Server 2008 R2 + as a minimum)
MS SQL Server Data Tools - SSDT (SSIS from SQL Server 2008 R2 as a minimum)
Microsoft SharePoint Server 2013 (MS SharePoint 2010 + as a minimum)
Experience in Microsoft BI stack including Power BI Experience in Microsoft SharePoint implementation
and management, specifically with Excel Services, Power Pivot, Reporting Services, Power View and Performance Point )
Able to configure BI Services in SharePoint 2013 Configuration and deployment Power BI
related updates
Troubleshooting and rectification of SharePoint related queries
Creation of new reports
Creation and configuration of new dashboards or dashboard elements
Periodic review of security group and access privileges
Design/Tools
Understanding of modelling and/or diagramming techniques, with the ability to create business process diagrams and understand entity relationship models
Experience with Business Intelligence tools such as Crystal, iReports, Tableaux, etc.
Experience with relational database design / modelling.
Personal
Ability to self-motivate to achieve high standards and continuously improve
Must be comfortable working in a fast-paced, flexible environment, and take the initiative to learn new tools quickly.
Strong communications skills required; ability to lead meetings, communicate with business stakeholders, and report to management
Excellent communication skills, analytical ability, strong judgment and management skills, and the ability to work effectively with all stakeholders
ACSO Position Description – Senior Data Warehouse (BI) Analyst / Developer June 2015 Page 5 of 6
SELECTION CRITERIA
Essential Criteria:
Concepts
Solid understanding of data warehousing architecture
In depth understanding of relational and data warehouse concepts Understanding of big data
Experience
Advanced degree in Computer Science or a related discipline and at least six, typically eight or more years’ experience in IT systems analysis and application program development, or an equivalent combination of education and work experience.
Five or more years experience with Microsoft Analytics environment
Five or more years experience in developing applications in a high volume ETL Microsoft Analytics environment
Extensive knowledge of the system development life cycle Experience in Agile software development is a big plus SQL Server administration and management experience Domain Knowledge
Not For Profit / Community Care industry experience is a plus Management
Has supervisory knowledge and experience in instructing, assigning, directing and checking the work of report development
3+ years experience in a technical leadership role Personal
Desire to get your hands dirty with a range of new technologies Satisfactory Police Check and Working with Children’s Check; Ability to work effectively alone or as part of a team
Demonstrated alignment to the ACSO Values and Vision
Desirable Criteria:
Member of the Facility Management Association of Australia A flexible approach to agreed work hours, locations and tasks
ORGANISATIONAL INFORMATION
OUR VISION
A safe and inclusive community, freed of crime and prison.
OUR MISSION
We help people transition from prison, assist them in the community, stop them from re-offending and divert others from committing crime.
OUR ETHOS
“Create another chance”
Comprehensive knowledge of organisational procedures, high level discipline knowledge, extensive experience and an understanding of the Strategic direction of the organisation
Establish and monitor work outcomes across the organisation
Act autonomously within delegated authority and organisational values where precedent or guidance may be limited
Progression
ACSO Position Description – Senior Data Warehouse (BI) Analyst / Developer June 2015 Page 6 of 6
OUR CORE VALUES
PASSION – Our heart and passion is at the core of everything we do.
BELIEF IN HUMANITY – We believe that everyone deserves another chance and is entitled to opportunities which
can help them to change their lives and realise their potential.
INTEGRITY – We are genuine in our relationships with clients and each other, always true to ourselves and
courageous in our approach.
PIONEERING SPIRIT – We are willing to explore and develop new and innovative solutions and take on the
challenges that confront us.
OUR OPERATIONAL GOALS
Recover: We promote, support and believe in the values of hope and recovery in all of our work.
Rehabilitate: We develop rehabilitation programs that divert people from committing crime or re-offending by
helping them address and change problem behaviour.
Reintegrate: We reintegrate people from prison back into the community, housing them and assisting them to
successfully re-enter the workforce.
ACSO is an equal opportunity employer. Selection will be based on assessing demonstrated performance of the skills, knowledge, behaviours and other personal qualifications relevant to the role.
The Senior Data Warehouse (BI) Analyst / Developer will participate in performance reviews on an annual basis conducted by the Chief Financial Information Officer.
Other Relevant Information
ACSO is a totally smoke free workplace
The position is subject to the terms set out in the ACSO Human Resources Policy, Staff Code of Ethics, and any future addition or variations to them. Tenure of the position is conditional upon ongoing observance of the ACSO Staff Code of Ethics (attached).
ACSO requires a satisfactory police check to be carried out and some positions may require a satisfactory Working With Children Check
ACSO has a commitment to OH&S. Thus it is a condition of this engagement that volunteers comply with all health and safety related policy and procedures and take part in activities designed to improve the health and safety of the workplace.
AUTHORISATION
I have read, understood and accepted this position description as the basis of this role.
ACSO reserves the right to review and amend this document at its discretion.
