MI Developer

Recruiter
AXA
Location
Redhill, Surrey
Salary
47000.0000
Posted
09 Jun 2017
Closes
08 Jul 2017
Contract Type
Permanent
Hours
Full Time
Summary

Join the number 1 global insurance brand as a MI Developer in our International operations teamand develop your career with a world leader.

Job Purpose
Create and maintain Fact and Dimension tables from diverse sources to enable fast reporting functions while looking for ways to improve the performance, speed and function of existing and new reporting requirements.

Dimensions and Operating Environment
The post-holder will work closely with the Underwriting Team, Commercial Account Managers, IT, Finance and reports developers to understand and define the report requirements and enable the timely production of reports in a high quality format that can lead to decision making and partner discussions.



What you will be doing


Responsibilities
Develop Star Schemas to produce Management Information to agreed standards of accuracy and timescales for use internally and externally for all AXA Travel Insurance schemes.
 Use SSIS to develop and populate an existing data warehouse. Importing from files and reports provided by both internal and external sources.
 Contributing ideas, collaborating and delivering the most effective software solution to provide internal and external management information.
 Troubleshoot and resolve issues including research, debug and support
 Document systems and procedures created and maintained
 To support the data management of the underwriting team on an ad hoc basis

In Addition:
You are required to adhere at all times to all and any regulatory requirements that apply
 You must adhere to all internal policies and procedures
 You must at all times act in the best interests and consider the broader impact of your decisions on the company as a whole

Essential Requirements
SQL Server 2008R2, TSQL, SSAS, SSIS, SSRS
 C# or VB.net
 Database structures, Data warehouse concepts, architecture and design, Data cleansing and Testing techniques
 Data modelling, Kimball methodology, Agile development environment
 Good experience of ETL using SSIS
 Good experience of star schema, fact and dimension table creation and population using SSIS
 Good experience in creating Cubes using SSAS
 Strong analytical skills

Desirable
Experience within Financial Services environment, Insurance specifically
 Quickly understands the business issues and data challenges of clients organisation and industry
 Reviews and edits requirements, specifications, business processes and recommendations related to proposed solution
 Exhibits confidence and an extensive knowledge of emerging industry practices when solving business problems
 Proven experience of interacting with end users
 Results orientated with good communication and interpersonal skills



What we can offer you

As you’d expect from a global leader, our reward package is a world-beater – here’s a small selection of our current benefits;

Competitive salary plus annual bonus
Fantastic opportunities for internal progression
Company Pension Scheme
Family Travel Insurance
Motor Breakdown Insurance
Home Emergency Insurance
24hr Access to the Company Concierge Service
Private Medical Insurance
Life Assurance
Company Shareplan





Who are we looking for?

BLANK Please insert skills/knowledge/behaviour