Join the number 1 global insurance brand as a MI Developer in our International operations teamand develop your career with a world leader.
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
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
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
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
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
Who are we looking for?
BLANK Please insert skills/knowledge/behaviour