BI Developer, Power BI
Sword Group
full-time
Posted on:
Location Type: Hybrid
Location: Glasgow • United Kingdom
Visit company websiteExplore more
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.
Requirements
- 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
Benefits
- 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.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLPythonETLELTdata modellingstar schemasdimensional modellingperformance tuningdata wranglingworkflow automation
Soft skills
collaborationdocumentationvalidationtestingcommunication