Software Engineer

**Position Purpose**

To deliver software that meets our customers’ needs, at the promised time specializing on ETL & Data Warehouse solutions.

***

**Key Accountabilities & Result areas**

**Software Design**

**Objective**

**Means for Achieving the Objective**
- The completed software fulfils the users’ requirements.
- Development time is accurately estimated to facilitate reliable project schedules.
- Design, development, and maintenance of the data structures for the data warehouse product, and associated ETL processes.
- Participate in Requirements Analysis discussions.
- Prepare screen mock-ups and descriptions of user interaction/workflow.
- Consider an appropriate range of implementation options and make recommendations of best approaches.
- Prepare Technical Specifications.
- Identify units of work and determine estimated development time.
- Develop and maintain the data structures for the Datawarehouse.
- Design of ETLs for loading and transforming data into the product.

**Software Development**

**Objective**

**Means for Achieving the Objective**
- Solutions are developed with a minimum of defects.
- Code can be easily understood and is well structured to allow efficient future maintenance.
- Development is completed on time.
- Performance taken into account when designing and implementing solutions - solutions capable of processing expected data volumes in appropriate times.
- Complete the development of new functionality and modifications to existing functionality.
- Write clean, carefully documented code.
- Adhere to established Kiwiplan standards and processes.
- Write unit tests and conduct an appropriate level of manual testing prior to handing work over to the Testing Team.
- Obtain peer review of design specifications and completed code.
- Conduct peer reviews of other developers’ specifications and code.

**Knowledge Transfer**

**Objective**

**Means for Achieving the Objective**
- Learning outcomes are applied to future development tasks across the entire development team.
- Development tasks can be readily shared among team members.
- Other departments have sufficient knowledge to complete their responsibilities (such as testing, and release documentation).
- Involve team members in design and development discussions.
- Present tutorials and information sessions.
- Participate in discussions with staff in other departments.
- Lead Functional Reviews of completed software.
- Contribute to internal knowledge bases.

**Support**

**Objective**

**Means for Achieving the Objective**

Internal and external customers receive the assistance they need.
- Act as a point of contact for the Testing Team and Support Teams.

**Health & Safety / Compliance**

**Objective**

**Means for Achieving the Objective**

Compliance

Ensure a sound understanding of, demonstrate commitment and comply with all legislation and Kiwiplan policy relevant to the role and activities undertaken in the role.

Health & Safety
- Undertake all work in a safe manner and follow all company and workplace health and safety procedures.
- Identify new hazards and advise manager or workplace Health and Safety representative within 24 hours of identification.
- Accurately report incidents and accidents to manager or workplace Health and Safety representative as soon as possible.

RELATIONSHIPS**:
**Product SMEs, Product Managers & Product owners**
- Provide help in eliciting requirements and defining and refining scope.
- Discussion of proposed development solutions.

**Development Manager**
- Build relationships with other developers.
- Collaboration and knowledge transfer.
- Ensure consistency of approach, and quality of implementation.
- Develop integrated solutions.

**Testing Team**
- Build relationships with test analysts.
- Knowledge transfer.
- Provide help in identifying and resolving issues.

**Support Team**
- Provide help in identifying and resolving issues.

**Project Management**
- Assist with technical input to project management.
- Provide visibility of project progress.

**THE SKILLS & EXPERIENCE THAT YOU NEED**:
**Criteria**

**Degree of Criteria**

**Typical Experience**
5+ years of software development experience - preferably with experience using or working on Datawarehouse and ETL processing.

**Technical Skills**
- Expert knowledge of the relevant programming language, platform, and development environment (Java).
- Experience with Pentaho (or similar) tools and ETL engine would be a benefit but not essential.
- Strong database design and data processing skills (ETL experience).
- Solid unit testing skills.
- Strong data analysis and modelling skills.
- Relational database development experience.
- Exposure to distributed architecture development.
- Moderate Operating System and hardware knowledge.

**Communication & Personal Attributes**
- Excellent verbal and written communication.
- Excellent problem-solving ability.
- Demonstrated 3+ years working in a team environment with substantial collab