BI Developer

https://www.eurobasepeople.com/job-search/10-bi-developer/public-services/city-of-london/job2023-08-23 13:58:512027-07-06 Eurobase People
Job Type Perm
Area City of London, England City of London England
Sector Public Sector / Public Services
Salary GBP 55,000 - 60,000 Annual Salary
Start Date ASAP
Advertiser Subeg Lehl
Job Ref 25142
Job Views 366
Description

LONDON - £55,000 - PERMANENT


BI DEVELOPER


KEY RESPONSIBILITIES:

- Develop elegant and performant ETL processes using Azure technologies, in line with industry best practice (e.g. Azure SQL Database, Data Factory and others)
- Work closely with the wider Data Engineering Team (including Business Analysts) to ensure changes are implemented in line with business requirements
- Ensure changes are managed effectively, with appropriate task and project planning, communication, testing, training and logging via DevOps
- Create, maintain and release SQL solutions using DevOps / Git
- Understand, adapt and utilise the dimensional model and technologies which underpin our business intelligence deliveries.
Platform/Database Administration:
- Support & maintain the BI Platform / Infrastructure, including managing security, Database Administration, undertaking troubleshooting/detailed investigations and fulfilling BAU requests
- Identify and resolve performance issues (e.g. query tuning, optimise code)
- Raise Incidents/Requests & collaborate closely with Microsoft & Clarion IT
- Lead on BI testing for IT Releases/Upgrades
- Undertake software installations & upgrades (E.g. Powershell modules, on-prem SQL)


EXPERIENCE:

Essential:
- Demonstrable experience of developing Data Warehouse and/or Database solutions using SQL Server (ideally, Azure SQL Database)
- Development using Azure Data Factory and/or SSIS
- Understanding of Dimensional/Data Modelling (e.g. Kimball)
- Development with Visual Studio 2019 and DevOps/Git
- Experience of query optimisation/performance tuning (e.g. able to analyse Query Store/Plans, indexes)
- Knowledge of database security (e.g. on SQL Server)
- Comprehensive knowledge of business intelligence, including best practices, processes, principles and technologies
- Understanding of data security (e.g. data masking) and GDPR
- Experience of undertaking Testing/QA (and peer reviews)

Desirable:
- Experience of working with Cloud resources (PaaS, IaaS)
- Experience of developing enterprise-wide, large scale ETL solutions
- Experience in a DBA or support role & working with third parties
- Development with PowerShell / Azure Runbooks
- Development with SSAS/Azure Tabular Models
- Development with SSRS
- Development with Power BI
- Experience of extracting data from REST APIs
- Recognised Azure qualifications
- DAX
- Synapse Analytics, including Spark


PERSON SPECIFICATION:

- Excellent communication skills
- Ability to work in a pressurised, environment & deliver to deadlines
- Adaptable and flexible attitude
- Strong analytical & problem solving skills with the ability to analyse and interpret complex scenarios
- Willingness and enthusiasm to learn and utilise new technologies
- Exceptional attention to detail and accuracy
- Ability to learn quickly
- Ability to work independently and also in close collaboration with peers
- Willingness to share knowledge and assist others within a highly collaborative team
- Occasional out of hours work (to support Deployments, IT Releases)
- Willingness to start work at 8am in order to monitor the nightly Data Warehouse refresh
- Occasional travel as required

Apply Later
Sign in
Register
Apply
Later
Subeg Lehl
Browse Subeg's jobs
Get in touch with Subeg
Similar Jobs
  • Head Of Information Security
    England, City of London
    Public Sector / Public Services
    GBP 97,000 - 120,000 Annual Salary

    This role is with a housing association within the UK and offers flexible hybrid working 

     

     

    Role profile for the position of

    Head of Information Security

    OD Level: 2

    Reports to: Director of IT (Infrastructure & Infosec) Main purpose of the ...

  • Engineering Manager
    England, City of London
    Public Sector / Public Services
    GBP 85,000 - 90,000 Annual Salary

    Our client is within the housing assiocation industry and they have offices countrywide, they are looking for a Engineering Manager on a permanent basis

    The role is Hybrid

    The role works in a function that is responsible for the design, delivery, maintenance, and support of the softwa...

  • Microsoft Dynamics Field Services Architect
    England, City of London
    Public Sector / Public Services
    GBP 70,000 - 90,000 Annual Salary

    My client are a established name in the housing and real estate industry and are looking for a Dynamics Field Services Technical Architect on a permanent basis You will be responsible for taking business problems and designing appropriate technical solutions to meet their needs. Responsible for ...

Email Me Jobs Like This
Subscribed to similar jobs notifications

Head Office

We use cookies to provide you with the best possible browsing experience on our website. You can find out more below.
Cookies are small text files that can be used by websites to make a user's experience more efficient. The law states that we can store cookies on your device if they are strictly necessary for the operation of this site. For all other types of cookies we need your permission. This site uses different types of cookies. Some cookies are placed by third party services that appear on our pages.
+Necessary
Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. The website cannot function properly without these cookies.
ResolutionUsed to ensure the correct version of the site is displayed to your device.
essential
SessionUsed to track your user session on our website.
essential
+Statistics
Statistic cookies help website owners to understand how visitors interact with websites by collecting and reporting information anonymously.
Google AnalyticsGoogle Analytics is an analytics tool to measure website, app, digital and offline data to gain user insights.
essential

More Details