Share this Job

BI Developer

BI Developer

Job ID:  1262
Department:  Databases
Category:  IT Development

London, GB Birmingham, GB

Employment Type:  Permanent

Company Overview

Clarksons is the world’s leading provider of integrated shipping and offshore services, bringing our connections and experience to an international client base. Our intelligence adds value by enabling clients to make more efficient and informed decisions. Our global reach, local knowledge and expertise is what makes us unique.


To understand more about day to day life at Clarksons, and what you can expect from us as an employer, visit us at www.clarksons.com

What you will be doing
• Use data from internal & external sources to provide the company with a competitive edge.
• Maintain existing / develop new solutions to maximize the utility of data within the business.
• Hands-on full lifecycle delivery of reports, dashboards and data feeds.
• Understand and document new and existing data requirements and translating these into high-level database designs and then implementing.
• Proactively identify opportunities for data quality improvements.
• Manage the relationship with stakeholders and users of the data.
• Work with the development team to contribute to project delivery, review T-SQL code and provide occasional best practice guidance.
• Process large data sets/forecasting.
• Additional / ad hoc duties as required to meet the needs of the business.


What we are looking for

Technical Environment:
• SQL 2012 / 2016 / 2017 / Azure SQL DB
• SSIS & Data Factory ETL
• Analysis Services Tabular
• Power Platform (Power BI On-premise and embedded service / Powerapps /Power Automate)
• Git/Azure Devops code and release


Essential Skills & Experience:
• Experience in the Technical Environment outlined above
• Able to effectively engage with the customer to define and refine requirements
• Self-starter, able to lead and provide the energy to get projects delivered
• Strong T-SQL skills, confident with advanced functions and complex datasets from transactional and batch sources
• Understanding of data flows and lineage and able to implement these using ETL tools
• Strong analytical skills, able to analyse financial data, models etc.
• Able to work on multiple new and mature projects simultaneously
• Able to perform ad hoc reporting (engaging with the business)
• Able to independently test and validate reporting solution outputs
• Communicating complex technical issues clearly
• Good understanding of DW modelling terminology & techniques


Desirable Skills & Experience:
• Client facing experience working with customers to understand, document and implement requirements
• Experience using GIT/Azure Devops CI/CD for code & development management
• Experience with data cleansing and/or master data management
• Powershell experience
• Work with JSON data payloads and calling APIs to consume data
• Previous experience as a full stack developer


Desirable Qualifications / Exams:
• MCSA: BI Reporting
• MCSA: SQL 2016 BI Development
• MS Exam 70-778 : Analyzing and Visualizing Data with Microsoft Power BI