Fresh Jobs at Crayon

Role Description

This candidate will work “hands-on” within a start-up-company in a close-knit team to design, implement and maintain data and reporting structures. The ideal candidate is energetic, hard-working and has a passion for turning data into structured, usable information that adds business value. This candidate possesses strong relationship building skills, good time management skills and good planning and organisational skills.

Salary

• Market related.

Responsibilities

• Work with source system owners and analysts to understand source data, e.g. data profiling, definition, and mapping
• Design, implement and monitor efficient data loads, using traditional structured data ETL techniques
• Work with business owners, data analysts, and business analysts to design and implement effective and efficient data models using appropriate modelling techniques
• Design and implement appropriate aggregation data structures that enhance usability of data, e.g. multi-dimensional OLAP structures, summary tables etc.
• Design and implement data models that support automated decision making and/or further analytics
• Provide technical and data related support to source system teams and external parties with whom data is exchanged
• Work with business owners and analysts to translate business needs into technical specifications to design, build, and deploy business reports

Requirements

• 5+ years in a technical data role, preferably in a formal data, data warehouse or business
• intelligence environment
• Degree in Information Technology / Mathematics / Engineering / Actuarial Science or related discipline
• Advanced knowledge of SQL Server Management Studio, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
• Advanced Excel skills, Macro development advantageous
• Experience in the financial services industry will be advantageous
• Additional Requirements:
• Strong analytical skills (data analyses)
• Quality and detail oriented
• IT infrastructure knowledge
• Strong project management – planning, organisational and time management
• Excellent written and verbal communication and interpersonal skills
• Deadline driven (sense of urgency) at all times
• Problem solving skills
• Ability to work in a goal-oriented environment
• Resourceful and the ability to take initiative