BI Engineer
Role details
Job location
Tech stack
Job description
This is an exciting time for us as we develop and transform our data capabilities. We're growing our team of BI Engineers and would welcome applications from you if you have previous BI Reporting experience, knowledge of SQL and SQL Development experience as well as advanced Excel skills., This is an exciting time of growth for us, and we are hiring a BI Engineer to help us continue this success. This is a great opportunity to develop a varied and rewarding career with a company that invests in, recognises and rewards its people.
Reporting to the Data Warehouse Team Lead you will, design, develop and enhance Datawarehouse and Securitisation databases and reports to ensure that they can make maximum use of data and reporting. You design and develop the databases and ETL processes for optimum performance as well as developing BI Output.
You will also:
Design, develop, test, implement and maintain the databases using the Microsoft BI Stack
- Develop BI Report, Models and Cubes as required using appropriate tool (SSRS, SSAS, Power BI)
- Work with Team Lead and MI Manager to ensure BI Reporting requirements support self-service BI
- Provide development and support for ongoing projects and existing solutions
- Support regular reporting processes
- Write Business and Technical Specification documents
- Support testing of releases
- Investigate, document and resolve as assigned production problems
- Provide out of hours cover as required
Requirements
Do you have experience in Visual Basic?, If you're an individual who thrives in a fast-paced environment, able to work collaboratively with others and are looking to make a difference, this is a brilliant opportunity to advance your career to the next level with our sector-leading company. At Premium Credit, you will be supported to develop and expand your skills, knowledge and experience.
To be successful as our BI Engineer it would be ideal if you hold a degree (or equivalent) within a technical or numerate discipline. It is essential that you have the following skills and competencies
Highly numerate with advanced Excel skills
- Knowledge of SQL with SQL Development experience
- BI Reporting experience
- Data focussed with a keen eye for spotting data trends, anomalies and quality
- Have strong communication skills - you'll be required to interact across the business
In addition it would ideal if you have knowledge of VBA, VBScript or Python and Microsoft SQL Server - Advanced TSQL. Experience in Report development using SSRS and Power BI as well as designing and developing cubes using SSAS.
Previous experience within the financial service sector would be beneficial as would development experience in Azure.
Benefits & conditions
Competitive salary in the region of £65000
- A workplace pension scheme
- Hybrid working, with collaborative days in our Leatherhead office
- 25 days annual leave (plus bank holidays), with options to purchase and sell up to 5 days holiday per year (pro rata)
- Private health and dental cover
- Support and investment in your personal development
- 24/7 access to Employee Assistance Programme and Mental Health First Aiders