BI Developer( Power BI )

Sword is a leading provider of business technology solutions within the Energy, Public and Finance Sectors, driving real transformation change within our clients.  We use proven technology, specialist teams and domain expertise to build solid technical foundations across platforms, data and business applications.  We have a passion for using technology to solve business problems, working in partnership with our clients to help in achieving their goals.

We’re looking for a BI Engineer with deep expertise in Power BI and semantic model design. This is a hands-on modelling and analytics engineering role focused on building and owning robust Power BI datasets, defining measures (DAX), shaping data for reporting, and designing logical models that can be handed over to engineering teams for physical implementation where needed.

Location - Scotland

About the role :

• Build and maintain the analytics layer of our client's data environment, including data transformations, marts and demantic models.
• Partner with analysts and finance to define and implement core product and business metrics in BI layer.
• Provide clean, well-documented datasets and BI models that accelerate experimentation, products insights and reporting.
• Apply validation, testing and documentation standards to ensure high quality and trust in our data.
• Collaborate with the data platform team on ingestion, architecture and performance optimisation.
• Own data flows end to end, from event tracking definitions through ETL/ELT pipelines to ready-made datasets and dashboards.
• Help define and enforce standards for how data models are stored, queried and shared across the company.

• Excellent SQL skills, including complex queries, window functions and performance tuning.
• Solid Python skills for ETL/ELT, data wrangling and workflow automation.
• Experience with data modelling techniques such as star schemas and dimensional modelling
• Familiarity with modern data warehousing concepts including ELT, and optimisation.
• Experience building metrics layers or standardising business metrics is desirable.
• Knowledge of testing and version control practices (Git,CI/CD)
• Understanding of product subscription metrics is an advantage
• Experience with BI e.g. Looker, Tableau, PowerBI

At Sword, our core values and culture are based on caring about our people, investing in training and career development and building inclusive teams where we are all encouraged to contribute to achieve success.

We offer comprehensive benefits designed to support your professional development and enhance your overall quality of life.  In addition to a Competitive Salary, here's what you can expect as part of our benefits package:

Personalised Career Development: We create a development plan customised to your goals and aspirations, with a range of learning and development opportunities within a culture that encourages growth.

Flexible working: Flexible work arrangements to support your work-life balance.  We can’t promise to always be able to meet every request, however are keen to discuss your individual preferences to make it work where we can.

A Fantastic Benefits Package: This includes generous annual leave allowance, enhanced family friendly benefits, pension scheme, access to private health, well-being, and insurance schemes, an employee assistance programme, discounted cash plan and more…..

At Sword we are dedicated to fostering a diverse and inclusive workplace and are proud to be an equal opportunities employer, ensuring that all applicants receive fair and equal consideration for employment, regardless of whether they meet every requirement.  If you don’t tick all the boxes but feel you have some of the relevant skills and experience we’re looking for, please do consider applying and highlight your transferable skills and experience.  We embrace diversity in all its forms, valuing individuals regardless of age, disability, gender identity or reassignment, marital or civil partner status, pregnancy or maternity status, race, colour, nationality, ethnic or national origin, religion or belief, sex or sexual orientation. Your perspective and potential are important to us.

If we can do anything to help make the hiring process more accessible, please let our talent acquisition team know when you apply so we can support any adjustments.