TO APPLY PLEASE CLICK HERE

TO APPLY PLEASE CLICK HERE

Location - Bristol
Contract - Fixed Term 12 Months

This job opportunity comes at an exciting time for Business Intelligence within Ascent. Recognising the immense benefits of BI, the business is looking for an innovative and forward thinking problem solver to support its Business Intelligence Developer.
This role is varied and challenging, and will involve working with internal stakeholders and external customers. Initiative and problem solving skills are a must, as are strong interpersonal and communication skills.
Although previous experience within BI is preferable, those with relevant skills are welcome to apply.
Key Responsibilities

• To design and implement automated tools using coding languages such as SQL, Python, R , MDX, DAX and Power Query for use in data processing, auditing, and for ad hoc reporting requirements.
• To utilise reporting tools such as Power BI, SSRS and Crystal reports to deliver meaningful reports and dashboards that add interpretative value to raw data.
• To assist with the data quality assurance processes that support analytics and reporting.
• To collate, input and visually present data for specific projects and assist in the interpretation and analysis.
• To undertake project work or special tasks in accordance with business requirements.
• To respond to requests channelled through the Senior Leadership Team to provide data that supports the delivery of Ascent's objectives and fulfill reporting requirements.
• To identify gaps in data provision and reporting mechanisms and work with team members to address gaps.
• To uphold partnering behaviours and a customers centred focus when dealing with all stakeholders.
• To undertake any other duties commensurate with the role
• To provide friendly Excel support to the wider business where possible
• Uphold adherence to the Health, Safety & Environmental Polices and Air Safety responsibilities

Knowledge, Skills, and Experience Essential:

• Extensive and proven advanced Excel skills (Desirable that this includes VBA but not essential);
• Extensive and in-depth expertise in data manipulation, management and reporting;
• An ability to critically and accurately test code;
• Extensive and in-depth expertise in Structured Query Language (SQL);
• Extensive and in-depth expertise designing reports in SSRS;
• Extensive analytical and problem solving skills; and
• Strong interpersonal skills;

Desirable:

• Experience with designing SQL Server tables, stored procedures, functions and ETL processes
• Experience designing reports and dashboards in Power BI and Crystal
• Experience working collaboratively with customers and users in a partnering environment.

Benefits In return, we will provide you with a generous benefits package including the equivalent to 25 days annual leave, a Defined Contribution Pension plan, access to a range of flexible benefits, an Employee Assistance Programme, and Private Medical Insurance.
Our Values One Ascent Team Ability and evidence of being a role model of Ascent values:
Responsive

• Hours not days; days not weeks
• Giving the best possible answer every time

Respectful

• Listening to everyone's views
• Professional & supportive to all our partners and colleagues

Safe

• Total Safety: Airsafety, HSSE & Airworthiness
• Immediate escalation of issues

Security Successful candidates will need to satisfy Ministry of Defence Security requirements and may be required to complete a medical assessment.
Conflicts of Interest In order to discharge Ascent's primary UKMFTS duty to the MOD to identify and avoid or mitigate conflicts of interest in conjunction with our activities as MOD's Training Service Partner, Ascent must ensure that no employee or secondee working for Ascent is materially restricted by any conflict of interest when carrying out duties and functions on its behalf. Therefore, candidates who are currently working for or have been employed during the previous 2 years by organisations such as MOD, Babcock, Lockheed Martin or any related group entity or any organisation bidding into the UKMFTS contract should note that Ascent reserves the right to request further information in relation to that candidate's current or previous employment history and/or take other appropriate steps to ensure Ascent's full compliance with its primary obligation. Any concerns you have should be discussed with the Ascent HR representative prior to submitting of a Curriculum Vitae.
In order to operate the Ascent Flight Training recruitment system, we will collect and store the personal information that you submit. Please read the following privacy statement to understand how Ascent Flight Training uses and protects the information you provide.
Privacy Statement for Job Applicants