BI Developer - Central Belt Scotland / Hybrid working

MS BI Developer

Ref: 1016Monday 6 December 2021

Sorry, this advert is now closed. Click here to view our live vacancies.

BI Developer - Central Belt Scotland / Hybrid working 

Exciting New Opportunity for a BI Developer; to work with a leading facilities company.  

Work in collaboration with the squad to create high quality software to achieve business objectives.​ Create automated tests, working closely with the Engineer (QA Bias).​ Contribute to and follow architectural and policy decisions.

 

PRINCIPAL TASKS AND RESPONSIBILITIES

 

Technical Skills

  • Translate business needs into technical specifications, ability to communicate with both technical & non-technical stakeholders.
  • Proven experience of building analytical data models and business intelligence solutions.
  • Solid understanding of data integration, data analysis, data modelling, data visualisation best practises.
  • Focus on development of ETL/data pipelines and data warehouse following industrial best practices.
  • In-depth understanding of database management systems, online analytical processing and ETL (Extract, transform, load) framework.
  • Utilising advanced Microsoft T-SQL knowledge to build and execute ad-hoc data queries upon request.
  • Experience using PowerBI or similar visualisation tool.
  • Participation in Datawarehouse design with a strong understanding of the Kimbal methodology
  • Work closely with the DBA team to ensure any SQL meets stringent performance and governance standards.
  • Good working knowledge of data modelling and schema patterns.
  • Create and maintain a library of technical documentation and help expand the business data dictionary.
  • Experience in delivering and supporting Dynamics 365 functionality
  • Software Development

  • Develop high quality technical solutions which meet specified business objectives, whilst adhering to overarching business and technical requirements and constraints.
  • Ensure all software that is created is in line with the technical roadmap, working in close collaboration with the other Engineers in the squad.
  • Work with other members of the squad to establish business requirements and refine/estimate user stories.
  • Contribute to squad ceremonies including Story Refinement, Sprint Planning and Retrospectives.
  • Collaborate with peers to write, review, or provide feedback on code reviews.
  • Contribute to your chapter, showcasing personal development progress and supporting/encouraging others.

Essential to have Experience in a MI-BI development role

  • 3 years’ experience in Data factory
  • Experience of Azure ETL
  • Azure SQL Database
  • Advanced T-SQL
  • Azure Synapse
  • Datawarehousing in Azure
  • Proactive approach.
  • Focused on outcomes rather than outputs
  • Excellent verbal and written communication skills
  • Pragmatic and flexible attitude
  • Excellent interpersonal skills
  • Attention to detail

Interviewing now please get in touch for more information !