Data Warehouse Developer

Data Warehouse Developer

This position description provides an indicative outline of the purpose and key responsibilities and tasks of the role.

Title and Reporting Relationships

Position title: Data Warehouse Developer Reporting to: Business Intelligence Manager

Location: Greenlane / Penrose and other sites as required

Purpose of the Role

Responsible for data modelling, ETL development, creating and maintaining models within the data warehouse, ensuring high levels of data quality and high performance in the processes and in the availability of data/information. Includes involvement in the information delivery (aka reporting) side of the team.

Personnel Dimensions

Key Relationships

People and organisations both inside and outside of the company that this position would be required to manage relationships with.

Internal Stakeholders External Stakeholders

Finance WDHB

IT Managers and IT Support Staff Northland DHB

Procurement CMDHB

The executive team ADHB

Position in Organisation

Tasks Expected Outcomes

Stored procedure work as

required. Robust coding practices.

ETL /ELT development and

maintenance as required. Robust ETL / ELT processes.

Design and build multi- dimensional data models / star schemas.

Robust data modelling that adheres to Kimball’s data warehouse architecture approach.

Design and build the data

presentation layer. Robust development of the data presentation layer, marts, cubes etc.

Adhoc data analysis, data

provision work as required. Timely and accurate data provided.

Adhoc reporting work as

required. Reporting work completed when required.

Adhere to SDLC processes used by the team (eg change management etc).

Alignment with team structured processes.

Continuous improvement of the data warehousing

environment.

New improvement initiatives are regularly put in place.

Diagnose and resolve data warehouse access and performance issues.

Performance gains.

Perform data warehouse configuration and

performance tuning.

Performance gains.

Implement and adhere to

data management functions. Alignment with data management functions used by the team.

Adhoc work and projects as

requested by BI Manager. Adhoc work and projects as requested by BI Manager.

Qualification, Experience and Training Requirements

What is the typical background required to competently perform the responsibilities of the job?

Essential is the minimum acceptable level for entry. Preferred indicates the desirable level, but may also expand on the nature, eg: industry related, level of previous supervisory experience

Essential Preferred

Bachelor Computer Science or

Information System Master in Computer Science or post graduate degree in a related field.

PL/SQL programming and/or stored

procedure development (4 years) Postgress SQL and SQL Server (or Sybase) Understanding of Dimensional Models

(4 years) Kimball’s and/or Inmon’s

Unix (2 years) Linux Red Hat

Programming languages (4 years) C++, C#, Java ETL Development with an enterprise

ETL Tool (4 years) DataStage Parallel Jobs (aka Enterprise Edition), Informatica

Data Warehouse (4 years) OBIEE, Netezza, Kimball’s architecture Working with Star Schemas (4 years) Kimball’s architecture

Knowledge or good understanding of

BI tools (2 years) SSRS, OBIEE, Cognos BI Knowledge or good understanding of

Cube technology (2 years) SSAS

Modelling Tools (1 year) ERWin or ERStudio or WhereScape

Source Control Practice Any source control tool (examples: Visual Source Safe, CVS, Subversion, etc)

COMPETENCIES FOR THE ROLE

Skills Making decisions in a timely manner, sometimes with incomplete information and under tight deadlines and

Technical Learning Picks up on technical things quickly; can learn new skills and knowledge; Is good at learning new industry, company, product, or technical knowledge- like internet technology; does well in technical courses and seminars.

Learning on the Fly Learns quickly when facing new problems; a relentless and versatile learner; open to change; analyzes both successes and failures for clues to improvement;

experiments and will try anything to find solutions; enjoys the challenges of unfamiliar tasks; quickly grasps the essence and the underlying structure of anything.

Problem Solving Good at figuring out the processes necessary to get things done; knows how to organise people and activities;

understands how to separate and combine tasks into efficient work flow; knows what to measure and how to measure it; can see opportunities for synergy and integration where others can’t; can simplify complex processes; gets more out of fewer resources.

Creativity Comes up with lots of new and unique ideas; easily makes connections among previously unrelated notions; tends to be seen as original and value-added in brainstorming setting.

Priority Setting Spends his/her time and the time of others on what’s important; quickly zeros in on the critical few and puts the trivial many aside; can quickly sense what will help or hinder accomplishing a goal; eliminates roadblocks;

creates focus.

Time Management Uses his/her time effectively and efficiently; values time;

concentrates his/her efforts on the most important priorities; gets more done in less time than others; can attend to a broader range of activities.

Informing Provides the information people need to know to do their jobs and to feel good about being a member of the team, unit, and/or the organization; provides individual information so that they can make accurate decisions; is timely with information.

Total Quality Management Is dedicated to providing organization or enterprise –wide common systems for designing and measuring work processes; seeks to reduce variances in organization processes; deliver the highest –quality products and services which meet the needs and requirements of internal and external customers; is committed to continuous improvement through empowerment and management of data; leverages technology to positively impact quality; is willing to re-engineer processes from scratch; is open to suggestions and experimentation;

creates a learning environment leading to the most efficient and effective work processes.

Standing Alone Will stand up and be counted; doesn’t shirk personal responsibility; can be counted on when times are tough;

willing to be the only champion for an or position; is comfortable working alone on a tough assignment.

Action Oriented Enjoys working hard; Is action oriented and full of energy for the things he/she sees as challenging; not fearful of acting with minimum of planning; seizes more opportunities than others.

Perseverance Pursues everything with energy, drive and a need to finish; seldom gives up before finishing, especially in resistance or setbacks.

Drive for Results Can be counted on to exceed goals successfully; is constantly and consistently one of the top performers;

very bottom-line oriented; steadfastly pushes self and others for results.

Approachability Is easy to approach and talk to; spends the extra effort to put others at ease; can be warm, pleasant, and gracious;

is sensitive to and patient with interpersonal anxieties of others; builds rapport well; is a good listener; is an early knower, getting informal and incomplete information in time to do something about it.

Interpersonal Savvy Relates well to all kinds of people-up, down, and sideways, inside and outside the organization; builds appropriate rapport; build constructive and effective relationships; uses diplomacy and tact; can diffuse even high-tension situations comfortably.

Customer Focus Is dedicated to meeting the expectations and requirements of internal and external customers; get first- hand customer information and uses it for improvements in products and services; acts with customers in mind;

establishes and maintains effective relationships with customers and gain their trust and respect.

Peer Relationships Is tolerant with people and process; listens and checks before acting; tries to understand the people and the data before making judgements and acting; waits for others to catch up before acting; sensitive to due process and proper pacing; follows established process.

Ethics and Values Adheres to an appropriate (for the setting) and effective set of core values and beliefs during both good and bad times; acts in line with those values; rewards the right values and disapproves of others; practices what he/she preaches.

Integrity and Trust Is widely trusted; is seen as a direct, truthful individual;

can present the unvarnished truth in an appropriate and helpful manner; keeps confidences; admits mistakes;

doesn’t misrepresent him/herself for personal gains.

Self Development Is personally committed to and actively work to continuously improve him/her. Understands the different situations and levels may call for different skills and approaches; work to deploy strengths; works on compensating for weakness and limits.

OPTIONAL: POSITION SPECIFIC POSITION RELATED COMPETENCIES Indicates the specialist skills and behaviour required for the role

Diplomacy and Customer Savvy Is able to manage business conflicts, whilst steering internal customers towards a regionalisation culture and approach

Is used to work in (and advocates) an environment with a tight source control and release process.

Alternatively, candidates with less experience will be considered if they show to have graduated with top grades and/or a post-graduate degree

Note: The position needs to reviewed by both parties annually.

Signed as current and agreed:

______________ ______________

Manager Employee