Al Rayan Bank is a growing, ethical and incredibly diverse bank based in new offices in the leafy suburb of Edgbaston, a stone's throw away from central Birmingham. As part of the Masraf Al Rayan Group which is the 2nd largest bank in Qatar, we've got exciting growth plans and aim to deliver a professional, first class service to our customers. As a business, we are going through a period of positive change with a focus on diversity and inclusion and cultural transformation including a real focus on flexibility and work life balance going forward. The business is having one of its most profitable years to date. We are on the lookout for a BI Manager who will be responsible for developing and enhancing new Operational Data and up to date integration solutions and analysing the data for the Bank with the use of data from multiple systems across the Bank. You will also be responsible for ensuring availability, reporting and governance of data critical to the Bank which includes evaluation and implementation of appropriate data governance ensuring consistency and improving the quality of data held by the Bank Key responsibilities and tasks: Educate/Partner with different Bank's departments, teams and cross functional projects to understand, advise and make recommendations based on insights using data centric solutions to resolve their challenges with dat Manages a team of analyst and developers who facilitate business intelligence processes and development and implementation. Have regular 1:1s and have training and development plans in place for each team member. Manage BI and analytics solutions that turn data into knowledge. Manage the design, develop and data solutions using BI tools. Manage the development of data visualisations with the use of Power BI/SSRS. Excellent time management skills with the ability to prioritise workload efficiently. Supervise and ensure efficient working of employees in organization. Perform assessment on all reporting requirements and develop long term strategy for various reporting solutions. Maintain and transform all strategies in operational plans according to business priorities and within budget Implementation of SQL deployment to production server Monitoring of SQL jobs and fixing issues when the automated job fails Refine and automate regular processes, track issues and improve performance Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements- To provide assurance on reporting produced by other Bank MI functions to improve their knowledge and sustain consistency in Bank reporting. Manage the creation of data library outlining what is held in the system account tables to simplify all future report writing. Liaise with and manage the relationship with vendors of BI solutions to maximise the value of solutions and make recommendations on best use of the solution in the Bank Report on development request inflight and completed to Stakeholders to agreed timescales. Attend and chair meeting within the IT and Change management team as required. Manage and report on BI Vendors. Forecast budget requirements and manage expenditure within the BI team. Ensure data governance processes and polices are followed by BI and development teams, reviewing database changes proposed in technical specifications. Build strategic relationships with stakeholders in a business team or area, and foster partnerships across the business landscape. Share information to educate internal customers about available BI capabilities and services and how they meet business needs. Manage risks identified in RSCA and audit actions, progress reported monthly. Essential Skils Extensive experience of Microsoft SQL Server, SSIS and SSRS Extensive experience on TSQL Significant experience on Microsoft office packages like word and excel. Meaningful experience on Power BI Meaningful experience on Salesforce Proactive, solution driven, and willing to take on the challenge of solving both technical and business problems. Strong capability in working with end users and translating their business requirements into very tangible data analysis and reporting solutions Innovative and enquiring approach and the ability to work autonomously where required. Ability to diagnose and resolve issues and manage work from inception to completion, prioritising work effectively. Good interpretation of Management Information and good report writing skills Strong organisational and personal effectiveness skills, including time and project management. Effective communicator and relationship builder with the ability to deliver technical messages to stakeholders. Passionate about delivering the highest level of customer service for internal and external customers Ability to cope with a heavy workload whilst maintaining accuracy and meeting deadlines in a calm, proficient manner and project a professional image always. Strong organisational and personal effectiveness skills, including time and project management. Experience working in a regulated environment This is a fantastic opportunity to join our growing bank where we can offer exceptional opportunities for you to make your mark and progress your career in a diverse, ethical bank that you can actually believe in. Empowering your career, together we'll deliver banking you can believe in.
Sep 24, 2021
Full time
Al Rayan Bank is a growing, ethical and incredibly diverse bank based in new offices in the leafy suburb of Edgbaston, a stone's throw away from central Birmingham. As part of the Masraf Al Rayan Group which is the 2nd largest bank in Qatar, we've got exciting growth plans and aim to deliver a professional, first class service to our customers. As a business, we are going through a period of positive change with a focus on diversity and inclusion and cultural transformation including a real focus on flexibility and work life balance going forward. The business is having one of its most profitable years to date. We are on the lookout for a BI Manager who will be responsible for developing and enhancing new Operational Data and up to date integration solutions and analysing the data for the Bank with the use of data from multiple systems across the Bank. You will also be responsible for ensuring availability, reporting and governance of data critical to the Bank which includes evaluation and implementation of appropriate data governance ensuring consistency and improving the quality of data held by the Bank Key responsibilities and tasks: Educate/Partner with different Bank's departments, teams and cross functional projects to understand, advise and make recommendations based on insights using data centric solutions to resolve their challenges with dat Manages a team of analyst and developers who facilitate business intelligence processes and development and implementation. Have regular 1:1s and have training and development plans in place for each team member. Manage BI and analytics solutions that turn data into knowledge. Manage the design, develop and data solutions using BI tools. Manage the development of data visualisations with the use of Power BI/SSRS. Excellent time management skills with the ability to prioritise workload efficiently. Supervise and ensure efficient working of employees in organization. Perform assessment on all reporting requirements and develop long term strategy for various reporting solutions. Maintain and transform all strategies in operational plans according to business priorities and within budget Implementation of SQL deployment to production server Monitoring of SQL jobs and fixing issues when the automated job fails Refine and automate regular processes, track issues and improve performance Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements- To provide assurance on reporting produced by other Bank MI functions to improve their knowledge and sustain consistency in Bank reporting. Manage the creation of data library outlining what is held in the system account tables to simplify all future report writing. Liaise with and manage the relationship with vendors of BI solutions to maximise the value of solutions and make recommendations on best use of the solution in the Bank Report on development request inflight and completed to Stakeholders to agreed timescales. Attend and chair meeting within the IT and Change management team as required. Manage and report on BI Vendors. Forecast budget requirements and manage expenditure within the BI team. Ensure data governance processes and polices are followed by BI and development teams, reviewing database changes proposed in technical specifications. Build strategic relationships with stakeholders in a business team or area, and foster partnerships across the business landscape. Share information to educate internal customers about available BI capabilities and services and how they meet business needs. Manage risks identified in RSCA and audit actions, progress reported monthly. Essential Skils Extensive experience of Microsoft SQL Server, SSIS and SSRS Extensive experience on TSQL Significant experience on Microsoft office packages like word and excel. Meaningful experience on Power BI Meaningful experience on Salesforce Proactive, solution driven, and willing to take on the challenge of solving both technical and business problems. Strong capability in working with end users and translating their business requirements into very tangible data analysis and reporting solutions Innovative and enquiring approach and the ability to work autonomously where required. Ability to diagnose and resolve issues and manage work from inception to completion, prioritising work effectively. Good interpretation of Management Information and good report writing skills Strong organisational and personal effectiveness skills, including time and project management. Effective communicator and relationship builder with the ability to deliver technical messages to stakeholders. Passionate about delivering the highest level of customer service for internal and external customers Ability to cope with a heavy workload whilst maintaining accuracy and meeting deadlines in a calm, proficient manner and project a professional image always. Strong organisational and personal effectiveness skills, including time and project management. Experience working in a regulated environment This is a fantastic opportunity to join our growing bank where we can offer exceptional opportunities for you to make your mark and progress your career in a diverse, ethical bank that you can actually believe in. Empowering your career, together we'll deliver banking you can believe in.
Senior BI Developer Lancashire c £40,000
High growth, entrepreneurial business. Great opportunity to work with like minded indivuduals and be part of a fantastic team.
The Senior BI Developer will be responsible for designing, developing and maintaining Business Intelligence solutions.
Mentor juniors, deputise for the Head of function, liaise with board, investors and colleagues across the business.
Responsibilities
· Translate business needs to technical specifications
· Design, build and deploy BI solutions
· Evaluate and improve existing BI systems
· Collaborate with teams to integrate systems
· Develop and execute database queries and conduct analyses
· Create visualizations and reports for requested projects
· Develop and update technical documentation
Skills sought
Proven experience as a BI Developer
Proven experience developing and maintaining ETL processes
Ability to write complex queries in T-SQL
A working knowledge across the MS BI Stack (SSRS, SSIS, SSAS)
Analytical mind with good problem solving skills
Ability to work under own initiative
Ability to work as part of a team
Other things to you can get involved in -
Transitioning services to Cloud (Azure)
Dimensional Modelling (e.g. Kimbell)
Source control technologies (e.g. TFS, VSTS)
Programming (e.g. .Net, Python)
Key pointers – BI Development, Business Intelligence, BI Developer, T-SQL, TSQL, SSRS, SSIS, SSAS, Modelling, Azure, SQL Server, MI, Management Information, BI Reporting, database development, DBA, Kimbell, ETL
Oct 29, 2018
Senior BI Developer Lancashire c £40,000
High growth, entrepreneurial business. Great opportunity to work with like minded indivuduals and be part of a fantastic team.
The Senior BI Developer will be responsible for designing, developing and maintaining Business Intelligence solutions.
Mentor juniors, deputise for the Head of function, liaise with board, investors and colleagues across the business.
Responsibilities
· Translate business needs to technical specifications
· Design, build and deploy BI solutions
· Evaluate and improve existing BI systems
· Collaborate with teams to integrate systems
· Develop and execute database queries and conduct analyses
· Create visualizations and reports for requested projects
· Develop and update technical documentation
Skills sought
Proven experience as a BI Developer
Proven experience developing and maintaining ETL processes
Ability to write complex queries in T-SQL
A working knowledge across the MS BI Stack (SSRS, SSIS, SSAS)
Analytical mind with good problem solving skills
Ability to work under own initiative
Ability to work as part of a team
Other things to you can get involved in -
Transitioning services to Cloud (Azure)
Dimensional Modelling (e.g. Kimbell)
Source control technologies (e.g. TFS, VSTS)
Programming (e.g. .Net, Python)
Key pointers – BI Development, Business Intelligence, BI Developer, T-SQL, TSQL, SSRS, SSIS, SSAS, Modelling, Azure, SQL Server, MI, Management Information, BI Reporting, database development, DBA, Kimbell, ETL
BI Developer
Salary: £30,000 to £40,000 per annum
Benefit Headlines: Up to 10% bonus, 25 Days Holiday, 3% Pension, Flexi-Working, Free parking
Business Intelligence Developer required for an exciting permanent opportunity working with a leading organisation based in Leeds. The successful BI Developer will be working with cutting edge technologies and an expert level team. The BI Developer will be responsible for developing and maintaining BI solutions to the support the business. As one of the BI Developers you will be responsible for the management and delivery of a new Data Warehouse build and new BI solution.
Key Skills:
- Strong SQL Server skills
- Strong data modelling, profiling and cleansing techniques
- Strong TSQL skills
- Excellent SSIS, ETL, SSRS
- Experience in designing and maintaining data interfaces
- Advanced level of tuning indexes and troubleshooting
This is a fantastic opportunity for an experienced Business Intelligence to join an exciting project, working with like-minded professionals.
*This is an urgent requirement and interviews will start ASAP*
Please send your CV to Jakob Russell.
ninesharp IT is a minimum fuss specialist IT recruitment consultancy. We provide high quality interim and permanent IT professionals.
Tags: Business Intelligence, BI Developer, SQL Server, Developer, T-SQL, SSIS, SSRS, SSAS, T-SQL, ETL
Oct 29, 2018
BI Developer
Salary: £30,000 to £40,000 per annum
Benefit Headlines: Up to 10% bonus, 25 Days Holiday, 3% Pension, Flexi-Working, Free parking
Business Intelligence Developer required for an exciting permanent opportunity working with a leading organisation based in Leeds. The successful BI Developer will be working with cutting edge technologies and an expert level team. The BI Developer will be responsible for developing and maintaining BI solutions to the support the business. As one of the BI Developers you will be responsible for the management and delivery of a new Data Warehouse build and new BI solution.
Key Skills:
- Strong SQL Server skills
- Strong data modelling, profiling and cleansing techniques
- Strong TSQL skills
- Excellent SSIS, ETL, SSRS
- Experience in designing and maintaining data interfaces
- Advanced level of tuning indexes and troubleshooting
This is a fantastic opportunity for an experienced Business Intelligence to join an exciting project, working with like-minded professionals.
*This is an urgent requirement and interviews will start ASAP*
Please send your CV to Jakob Russell.
ninesharp IT is a minimum fuss specialist IT recruitment consultancy. We provide high quality interim and permanent IT professionals.
Tags: Business Intelligence, BI Developer, SQL Server, Developer, T-SQL, SSIS, SSRS, SSAS, T-SQL, ETL
SSIS - T-SQL - Data Warehouse Developer - Developer - London
Opportunity for an experienced Data Warehouse Developer to join a leading telecommunications/marketing company looking to grow their on-site Business Intelligence team.
You will join to work on their current greenfield project working with their growing development team where the successful applicant will be utilising the latest versions of technologies to deliver first class Business Intelligence solutions.
The rate offered for this role will be £(Apply online only) per day.
Technical Experience required:
* Experience of Data Warehousing
* Development of complex SSIS packages from scratch
* Microsoft SQL Server platform & TSQL development experience
Technical skill set:
* Excellent knowledge in SSIS, SSRS and Data warehousing using the Kimball Methodology
* Excellent knowledge in developing SSAS cubes in SQL Server 2008 R2/2012/2014
* Proven knowledge of MDX
* Strong knowledge of SQL Server 2008 R2/2012/2014, excellent knowledge of SQL queries, stored procedures and triggers.
* Experience of SQL 2016 is highly desirable.
We understand the need for discretion and would welcome the opportunity to speak to any Microsoft candidates that are considering a new career or job either now or in the future. Confidentiality is of course guaranteed.
To discuss the role further and apply:
Contact Callum Runnegar-Mundy on (Apply online only), or alternatively email c.runnegar-
Nigel Frank International is the global leader in Microsoft recruitment. We advertise more Microsoft Business Intelligence jobs than any other agency. We deal with both Microsoft Partners and End Users throughout the UK and Europe and we have never had more live requirements and jobs for Microsoft professionals. By specialising solely in placing candidates in the Microsoft market we have built relationships with most of the key employers in the UK and have an unrivaled understanding of where the best opportunities and jobs are
May 02, 2017
SSIS - T-SQL - Data Warehouse Developer - Developer - London
Opportunity for an experienced Data Warehouse Developer to join a leading telecommunications/marketing company looking to grow their on-site Business Intelligence team.
You will join to work on their current greenfield project working with their growing development team where the successful applicant will be utilising the latest versions of technologies to deliver first class Business Intelligence solutions.
The rate offered for this role will be £(Apply online only) per day.
Technical Experience required:
* Experience of Data Warehousing
* Development of complex SSIS packages from scratch
* Microsoft SQL Server platform & TSQL development experience
Technical skill set:
* Excellent knowledge in SSIS, SSRS and Data warehousing using the Kimball Methodology
* Excellent knowledge in developing SSAS cubes in SQL Server 2008 R2/2012/2014
* Proven knowledge of MDX
* Strong knowledge of SQL Server 2008 R2/2012/2014, excellent knowledge of SQL queries, stored procedures and triggers.
* Experience of SQL 2016 is highly desirable.
We understand the need for discretion and would welcome the opportunity to speak to any Microsoft candidates that are considering a new career or job either now or in the future. Confidentiality is of course guaranteed.
To discuss the role further and apply:
Contact Callum Runnegar-Mundy on (Apply online only), or alternatively email c.runnegar-
Nigel Frank International is the global leader in Microsoft recruitment. We advertise more Microsoft Business Intelligence jobs than any other agency. We deal with both Microsoft Partners and End Users throughout the UK and Europe and we have never had more live requirements and jobs for Microsoft professionals. By specialising solely in placing candidates in the Microsoft market we have built relationships with most of the key employers in the UK and have an unrivaled understanding of where the best opportunities and jobs are
Role: Senior Software Developer
Location: Crewe
Salary: £competitive
Role Purpose:
To develop tailored solutions that support and deliver the Development roadmap for both Assurant and Assurant clients across multiple platforms. This role requires excellent knowledge of the data domain, ideally alongside some .Net Application development experience.
Work as part of a team to; deliver projects to meet the needs of the business, correcting issues, and carry out enhancements as logged through our service desk
Assist other developers in the department in their day to day work
Design solutions to meet the needs of the business
Mentor other developers on all areas of solution design, and implementation for Assurant digital solutions.
Role Requirements:
4+ years working as a Developer (2+ at Assurant)
Experience acting as product design authority
Experiencing in designing and developing integration solutions i.e. web services development, messaging
Full lifecycle experience
Experience of unit testing
Support the on boarding of 3rd Party development partners.
Define and manage source control and release processes
Excellent written and verbal communication
At least one of:
End to end experience of Waterfall Methodologies
Experience of Agile Methodologies & usage of appropriate Tools i.e. Jira
Advantageous
Experience of automated testing techniques i.e. Selenium
Exposure to continuous integration
Role Requirements (Data):
Highly Experienced in SQL Server Development preferably one or more of (Apply online only))
T-SQL Scripting / Database Object Creation
Complex Stored Procedures / Transaction Handling
Performance Tuning / Scalability
Functions / Triggers/ Views / Exception Handing
Experience in Performance Tuning complex stored procedures, relating to query and index performance
Experience trouble shooting logic problems
Ability to understand and develop data solutions to be in a multi tenanted environment (white label solutions).
Ability to understand and develop data solutions in a highly available, multi transactional environment.
Able to peer review across the range of data technologies.
Able to follow and review Coding standard documentation
Desirable
Experienced in using Business Intelligence (SSIS/SSAS/SSRS).
Ability to translate MI business requirements into SSRS reports.
Knowledge of other database systems (Oracle, Mysql, Mongodb, Postgres)
XML Data Storage (Xpath/Xquery)
Multidimensional Expressions (MDX)
.Net Application (Desirable)
Proficient in C#/VB.Net
Good knowledge of the .Net Framework
Experience in either WinForms/WPF solutions or Web development
Working knowledge of Design Patterns (inc MVC)
Design and Development of NTier and Service Oriented Architecture (including Message based systems).
Working knowledge of WCF, Windows Services, Web Services (SOAP and RESTful), ASP.Net Web API
Experience in Object Relational Mapper technology (i.e. EntityFramework)
Good knowledge of TSQL including creation and maintenance of complex stored procedures
Automated Testing and Continuous Integration advantage
Some Java an advantage
May 02, 2017
Role: Senior Software Developer
Location: Crewe
Salary: £competitive
Role Purpose:
To develop tailored solutions that support and deliver the Development roadmap for both Assurant and Assurant clients across multiple platforms. This role requires excellent knowledge of the data domain, ideally alongside some .Net Application development experience.
Work as part of a team to; deliver projects to meet the needs of the business, correcting issues, and carry out enhancements as logged through our service desk
Assist other developers in the department in their day to day work
Design solutions to meet the needs of the business
Mentor other developers on all areas of solution design, and implementation for Assurant digital solutions.
Role Requirements:
4+ years working as a Developer (2+ at Assurant)
Experience acting as product design authority
Experiencing in designing and developing integration solutions i.e. web services development, messaging
Full lifecycle experience
Experience of unit testing
Support the on boarding of 3rd Party development partners.
Define and manage source control and release processes
Excellent written and verbal communication
At least one of:
End to end experience of Waterfall Methodologies
Experience of Agile Methodologies & usage of appropriate Tools i.e. Jira
Advantageous
Experience of automated testing techniques i.e. Selenium
Exposure to continuous integration
Role Requirements (Data):
Highly Experienced in SQL Server Development preferably one or more of (Apply online only))
T-SQL Scripting / Database Object Creation
Complex Stored Procedures / Transaction Handling
Performance Tuning / Scalability
Functions / Triggers/ Views / Exception Handing
Experience in Performance Tuning complex stored procedures, relating to query and index performance
Experience trouble shooting logic problems
Ability to understand and develop data solutions to be in a multi tenanted environment (white label solutions).
Ability to understand and develop data solutions in a highly available, multi transactional environment.
Able to peer review across the range of data technologies.
Able to follow and review Coding standard documentation
Desirable
Experienced in using Business Intelligence (SSIS/SSAS/SSRS).
Ability to translate MI business requirements into SSRS reports.
Knowledge of other database systems (Oracle, Mysql, Mongodb, Postgres)
XML Data Storage (Xpath/Xquery)
Multidimensional Expressions (MDX)
.Net Application (Desirable)
Proficient in C#/VB.Net
Good knowledge of the .Net Framework
Experience in either WinForms/WPF solutions or Web development
Working knowledge of Design Patterns (inc MVC)
Design and Development of NTier and Service Oriented Architecture (including Message based systems).
Working knowledge of WCF, Windows Services, Web Services (SOAP and RESTful), ASP.Net Web API
Experience in Object Relational Mapper technology (i.e. EntityFramework)
Good knowledge of TSQL including creation and maintenance of complex stored procedures
Automated Testing and Continuous Integration advantage
Some Java an advantage
Job Title: IT SQL Developer
Department:: IT
Location: Manchester
Reports to: IT Manager - Change
Grade: Staff Member (SM)
Job Description:
The Team
This role will report to the IT Manager - Change within the IT Department. You will provide SQL development support to the IT Department in an efficient and professional manner and in accordance with the agreed procedures and service standards. Your role will contribute to the overall success of the IT Department in achieving its objectives as part of overall Company Strategy.
Key Responsibilities:
1 Working with the IT Application Development Manager, support the project related change and development of the Enterprise Data Warehouse and Business Intelligence suite, including but not limited to the activities described below.
2 Development
* Carry out development for major system enhancements and project work across the Business Intelligence suite; responsible for building, deploying, system testing and configuration changes.
* Ensure that best practice source code controls are implemented and adhered to.
* Develop small-scale bespoke technical solutions as part of project delivery (e.g. PowerShell scripts, SQL queries).
3 Database Administration
* Ensure that a reliable and efficient database estate is maintained throughout project delivery, performing operational database configuration and ensuring that data integrity and security standards are upheld.
* Troubleshoot database related issues raised in user acceptance testing.
* Ensure adequate database monitoring is in place (performance, capacity).
* Define database access permissions and privileges.
* Develop database documentation, including release procedures, data quality and security standards.
4 Follow best practice change management principles, ensuring development quality meets agreed release standards for production deployment.
5 Working closely with the IT Run Team to assist in the smooth transition from project/enhancement to 'business as usual' production support.
6 Maintain a rich and concise documentation library to facilitate knowledge sharing and retention within the team.
7 Actively contribute to/participate in the IT transformation programme to enable IT to support the agreed business goals.
Person Specification:
1 Enthusiastic, hardworking and driven individual with a focus on providing the best possible service.
2 Can demonstrate ability to work in a busy office environment, prioritise and organise workload in order to meet tight deadlines.
3 Able to learn and take on new tasks quickly and use own initiative to explore possibilities before raising queries.
4 Demonstrates pride in delivering excellent, quality service and endeavours to exceed expectations.
5 Attention to detail in producing high quality output and able to maintain this when under pressure.
6 Excellent communication skills with confidence to ask questions to ensure job requirements are understood.
7 Commitment to identify opportunities to increase efficiency and quality of operational support evidenced through previous achievements.
8 Proactive, showing initiative when completing tasks by pre-empting issues and proposing solutions for them.
9 Confidence in building rapport and trust with a range of internal and external stakeholders.
10 Academic qualifications, A Level's preferred. GSCE Mathematics C grade upwards required.
11 Confidence in working unsupervised and as part of a team to achieve personal and team objectives.
12 Flexible approach to work with a strong desire to learn and study towards relevant industry qualifications.
Required Skills:
Hands on experience of the following:
1 SQL Server (Apply online only) (TSQL, Stored Procedures, database/query Optimization ) / SSIS,SSAS
2 In-depth understanding of data warehousing - ETL ,MDS,ODS, DDS
3 Dimensional Modelling (Kimball)
4 BI Tools (Qlikview, OLAP, SSRS)
5 Schema design (UML)
6 Source Code Control software (e.g. TFS, Git)
Desired Skills:
1 Familiarity with full software development lifecycle
2 ITIL Service Management
3 Windows PowerShell
4 Microsoft Azure or AWS
5 Infrastructure skills (server administration, backup procedures, networking etc.)
6 IBM iSeries platform
7 Advanced MS Office / Excel / VBA
Values:
Vision for 2017 has defined that one of the enablers to success is having a clear set of company values, which are as follows. We try to incorporate these values into everything we do.
1 Recruiting and developing high quality people.
2 Getting results - by working together and outperforming the competition.
3 Keeping our promises - on time, every time.
4 Doing our best to serve our market and the community.
5 Treating the company money as if our own.
6 Working smarter and pursuing innovation
May 02, 2017
Job Title: IT SQL Developer
Department:: IT
Location: Manchester
Reports to: IT Manager - Change
Grade: Staff Member (SM)
Job Description:
The Team
This role will report to the IT Manager - Change within the IT Department. You will provide SQL development support to the IT Department in an efficient and professional manner and in accordance with the agreed procedures and service standards. Your role will contribute to the overall success of the IT Department in achieving its objectives as part of overall Company Strategy.
Key Responsibilities:
1 Working with the IT Application Development Manager, support the project related change and development of the Enterprise Data Warehouse and Business Intelligence suite, including but not limited to the activities described below.
2 Development
* Carry out development for major system enhancements and project work across the Business Intelligence suite; responsible for building, deploying, system testing and configuration changes.
* Ensure that best practice source code controls are implemented and adhered to.
* Develop small-scale bespoke technical solutions as part of project delivery (e.g. PowerShell scripts, SQL queries).
3 Database Administration
* Ensure that a reliable and efficient database estate is maintained throughout project delivery, performing operational database configuration and ensuring that data integrity and security standards are upheld.
* Troubleshoot database related issues raised in user acceptance testing.
* Ensure adequate database monitoring is in place (performance, capacity).
* Define database access permissions and privileges.
* Develop database documentation, including release procedures, data quality and security standards.
4 Follow best practice change management principles, ensuring development quality meets agreed release standards for production deployment.
5 Working closely with the IT Run Team to assist in the smooth transition from project/enhancement to 'business as usual' production support.
6 Maintain a rich and concise documentation library to facilitate knowledge sharing and retention within the team.
7 Actively contribute to/participate in the IT transformation programme to enable IT to support the agreed business goals.
Person Specification:
1 Enthusiastic, hardworking and driven individual with a focus on providing the best possible service.
2 Can demonstrate ability to work in a busy office environment, prioritise and organise workload in order to meet tight deadlines.
3 Able to learn and take on new tasks quickly and use own initiative to explore possibilities before raising queries.
4 Demonstrates pride in delivering excellent, quality service and endeavours to exceed expectations.
5 Attention to detail in producing high quality output and able to maintain this when under pressure.
6 Excellent communication skills with confidence to ask questions to ensure job requirements are understood.
7 Commitment to identify opportunities to increase efficiency and quality of operational support evidenced through previous achievements.
8 Proactive, showing initiative when completing tasks by pre-empting issues and proposing solutions for them.
9 Confidence in building rapport and trust with a range of internal and external stakeholders.
10 Academic qualifications, A Level's preferred. GSCE Mathematics C grade upwards required.
11 Confidence in working unsupervised and as part of a team to achieve personal and team objectives.
12 Flexible approach to work with a strong desire to learn and study towards relevant industry qualifications.
Required Skills:
Hands on experience of the following:
1 SQL Server (Apply online only) (TSQL, Stored Procedures, database/query Optimization ) / SSIS,SSAS
2 In-depth understanding of data warehousing - ETL ,MDS,ODS, DDS
3 Dimensional Modelling (Kimball)
4 BI Tools (Qlikview, OLAP, SSRS)
5 Schema design (UML)
6 Source Code Control software (e.g. TFS, Git)
Desired Skills:
1 Familiarity with full software development lifecycle
2 ITIL Service Management
3 Windows PowerShell
4 Microsoft Azure or AWS
5 Infrastructure skills (server administration, backup procedures, networking etc.)
6 IBM iSeries platform
7 Advanced MS Office / Excel / VBA
Values:
Vision for 2017 has defined that one of the enablers to success is having a clear set of company values, which are as follows. We try to incorporate these values into everything we do.
1 Recruiting and developing high quality people.
2 Getting results - by working together and outperforming the competition.
3 Keeping our promises - on time, every time.
4 Doing our best to serve our market and the community.
5 Treating the company money as if our own.
6 Working smarter and pursuing innovation
Role: Senior Software Developer
Location: Crewe
Salary: £competitive
Role Purpose:
To develop tailored solutions that support and deliver the Development roadmap for both Assurant and Assurant clients across multiple platforms. This role requires excellent knowledge of the data domain, ideally alongside some .Net Application development experience.
Work as part of a team to; deliver projects to meet the needs of the business, correcting issues, and carry out enhancements as logged through our service desk
Assist other developers in the department in their day to day work
Design solutions to meet the needs of the business
Mentor other developers on all areas of solution design, and implementation for Assurant digital solutions.
Role Requirements:
4+ years working as a Developer (2+ at Assurant)
Experience acting as product design authority
Experiencing in designing and developing integration solutions i.e. web services development, messaging
Full lifecycle experience
Experience of unit testing
Support the on boarding of 3rd Party development partners.
Define and manage source control and release processes
Excellent written and verbal communication
At least one of:
End to end experience of Waterfall Methodologies
Experience of Agile Methodologies & usage of appropriate Tools i.e. Jira
Advantageous
Experience of automated testing techniques i.e. Selenium
Exposure to continuous integration
Role Requirements (Data):
Highly Experienced in SQL Server Development preferably one or more of (Apply online only))
T-SQL Scripting / Database Object Creation
Complex Stored Procedures / Transaction Handling
Performance Tuning / Scalability
Functions / Triggers/ Views / Exception Handing
Experience in Performance Tuning complex stored procedures, relating to query and index performance
Experience trouble shooting logic problems
Ability to understand and develop data solutions to be in a multi tenanted environment (white label solutions).
Ability to understand and develop data solutions in a highly available, multi transactional environment.
Able to peer review across the range of data technologies.
Able to follow and review Coding standard documentation
Desirable
Experienced in using Business Intelligence (SSIS/SSAS/SSRS).
Ability to translate MI business requirements into SSRS reports.
Knowledge of other database systems (Oracle, Mysql, Mongodb, Postgres)
XML Data Storage (Xpath/Xquery)
Multidimensional Expressions (MDX)
.Net Application (Desirable)
Proficient in C#/VB.Net
Good knowledge of the .Net Framework
Experience in either WinForms/WPF solutions or Web development
Working knowledge of Design Patterns (inc MVC)
Design and Development of NTier and Service Oriented Architecture (including Message based systems).
Working knowledge of WCF, Windows Services, Web Services (SOAP and RESTful), ASP.Net Web API
Experience in Object Relational Mapper technology (i.e. EntityFramework)
Good knowledge of TSQL including creation and maintenance of complex stored procedures
Automated Testing and Continuous Integration advantage
Some Java an advantage
May 02, 2017
Role: Senior Software Developer
Location: Crewe
Salary: £competitive
Role Purpose:
To develop tailored solutions that support and deliver the Development roadmap for both Assurant and Assurant clients across multiple platforms. This role requires excellent knowledge of the data domain, ideally alongside some .Net Application development experience.
Work as part of a team to; deliver projects to meet the needs of the business, correcting issues, and carry out enhancements as logged through our service desk
Assist other developers in the department in their day to day work
Design solutions to meet the needs of the business
Mentor other developers on all areas of solution design, and implementation for Assurant digital solutions.
Role Requirements:
4+ years working as a Developer (2+ at Assurant)
Experience acting as product design authority
Experiencing in designing and developing integration solutions i.e. web services development, messaging
Full lifecycle experience
Experience of unit testing
Support the on boarding of 3rd Party development partners.
Define and manage source control and release processes
Excellent written and verbal communication
At least one of:
End to end experience of Waterfall Methodologies
Experience of Agile Methodologies & usage of appropriate Tools i.e. Jira
Advantageous
Experience of automated testing techniques i.e. Selenium
Exposure to continuous integration
Role Requirements (Data):
Highly Experienced in SQL Server Development preferably one or more of (Apply online only))
T-SQL Scripting / Database Object Creation
Complex Stored Procedures / Transaction Handling
Performance Tuning / Scalability
Functions / Triggers/ Views / Exception Handing
Experience in Performance Tuning complex stored procedures, relating to query and index performance
Experience trouble shooting logic problems
Ability to understand and develop data solutions to be in a multi tenanted environment (white label solutions).
Ability to understand and develop data solutions in a highly available, multi transactional environment.
Able to peer review across the range of data technologies.
Able to follow and review Coding standard documentation
Desirable
Experienced in using Business Intelligence (SSIS/SSAS/SSRS).
Ability to translate MI business requirements into SSRS reports.
Knowledge of other database systems (Oracle, Mysql, Mongodb, Postgres)
XML Data Storage (Xpath/Xquery)
Multidimensional Expressions (MDX)
.Net Application (Desirable)
Proficient in C#/VB.Net
Good knowledge of the .Net Framework
Experience in either WinForms/WPF solutions or Web development
Working knowledge of Design Patterns (inc MVC)
Design and Development of NTier and Service Oriented Architecture (including Message based systems).
Working knowledge of WCF, Windows Services, Web Services (SOAP and RESTful), ASP.Net Web API
Experience in Object Relational Mapper technology (i.e. EntityFramework)
Good knowledge of TSQL including creation and maintenance of complex stored procedures
Automated Testing and Continuous Integration advantage
Some Java an advantage