SQL BI Developer

Posted: 18th May 2018

SQL BI Developer

Closing Date: 3rd June 2018


Aperture are seeking to appoint enthusiastic SQL BI Developer to join our dedicated team of IT professionals.

Aperture Debt Solutions LLP is a long-standing, market leading personal insolvency specialist that has provided thousands of individuals with solutions to problem debt. We believe in making a real difference to people’s lives and our approach is reflected in our values which promote the provision of a ‘Caring’, ‘Respectful’, ‘Non-Judgemental’ service and a drive for ‘Excellence’ in everything that we do. Our current client-base is one of the largest in the industry and the business continues to experience significant growth. The practice, with headquarters in Belfast, is now seeking to recruit individuals who share our vision, believe in our values and can produce high quality work in a fast-paced and target-driven environment.


The Role

Aperture are seeking to appoint enthusiastic SQL BI Developer to join our dedicated team of IT professionals. Within this role you will be responsible for:

• Data transfer package build;
• Report development and delivery to senior stakeholders;
• Reports requirements gathering;
• Ownership of the business BI / MI tool;
• Statistics analysis and trending based on reports created.

The role will be a varied and exciting one which is all about helping and supporting clients in their journey to become debt-free. As such, the successful candidates will need to have a ‘can do’ attitude, believe in our values and purpose, be proactive and dedicated to providing excellent SQL development skills.

This is a superb opportunity to join a forward-thinking, values-driven company during a time of huge growth. To be considered you will have the following skills:



• A ‘can do’ attitude and desire to make a difference;
• Must be a self-starter and have the capacity to hit the ground running:
• Adaptability and a positive attitude to change;
• Strong oral and written communication;
• Excellent time management;
• Results driven;
• Attention to detail;
• An ability to work independently and as part of a team;
• Excellent organisation; and
• Strong analytical skills

Essential Criteria

• Minimum 2 years reporting development experience;
• Extensive knowledge of creating SQL queries, stored procedures;
• Experience working with and creating data warehouse environments;
• Creating SSRS reports and deployment, scheduling as per business requirement;
• Creation of table views;
• Database indexing and performance tuning;
• Creating SSRS reports subscriptions and scheduling and administering reports;
• Using SSIS – design ETL packages, deployment and support;
• SSIS package design / development support for various functions;
• Integrating new datasets into data warehouse;
• Designing OLAP cubes and development of data warehouse projects;
• Extensively working exposure in OLTP /OLAP environments;
• T-SQL, SSIS & SSAS in all versions (SQL 2008, 2012 & 2014);
• IT related degree;
• Data analysis and trending;
• Requirements gathering and designing database and its objects;
• Creating stored procedures, functions and triggers for various business requirements;
• Writing complex queries with optimal performance as per the business requirements

Desirable Criteria

• Experience in any other reporting development system;
• Experience with SSRS 2016.


• Initiative
• Adaptability
• Ownership
• Knowledge
• Results Driven
• Client Focused
• Communication
• Analytical Skills

Salary & Benefits

A very competitive package will be offered, a comprehensive benefits’ package to include Private Healthcare, Company Pension Scheme, a 37.5-hour work week, 26 days’ holiday per year days plus 8 statutory holidays, plus the option to purchase 1 additional week’s holiday, Health Cash Plan, Life Assurance, Income Protection after 1-year service, Employee Assistance Programme, Childcare Vouchers, Travel Season Ticket Loan, Staff events, dress down Fridays, and free tea/coffee every day.

To apply for this position Apply Now

Closing Date: 3 June 2018
We are an Equal Opportunities Employer

← Back to Blog