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 !