Senior Data & BI Developer Salary: £55,000 - £65,000 per annum
Job Type: Full-time The Role
We are seeking a highly skilled Senior Data & BI Developer who can bridge the gap between backend data architecture and front-end analytics. This role combines deep SQL expertise with advanced Power BI capabilities to support mission-critical business logic, reporting systems, and strategic insights.
You will work with complex hierarchical data models, optimize database performance, and develop impactful dashboards that empower stakeholders across the organisation.
Key Responsibilities SQL Development & Database Administration- Design and implement efficient SQL queries and database structures to support complex business processes and hierarchical data relationships.
- Develop recursive queries and CTEs to traverse and manipulate hierarchical data.
- Optimise stored procedures and troubleshoot performance issues using execution plans and query tuning techniques.
- Collaborate with developers and analysts to translate business requirements into efficient database logic.
- Enforce data governance, integrity, and consistency across database systems.
- Design and maintain advanced interactive Power BI dashboards and reports.
- Build robust data models using DAX and manage ETL processes from various sources (SQL Server, Excel, cloud platforms).
- Gather and translate complex business requirements into technical specifications.
- Promote best practices in data governance and maintain documentation for report logic and dashboard functionality.
- Optimise Power BI solutions for performance and scalability.
- Support re-platforming initiatives with data-driven insights.
- Mentor junior analysts and contribute to a culture of continuous learning.
- Identify opportunities for new data solutions and contribute to the analytics roadmap.
- 5+ years of experience in SQL development with enterprise-grade relational databases (SQL Server).
- 4+ years of experience in Power BI development with a strong portfolio of dashboards.
- Expertise in hierarchical data patterns: adjacency lists, nested sets, recursive CTEs.
- Strong proficiency in DAX, M-Query, Power Query.
- Solid understanding of indexing, query optimisation, and performance tuning.
- Experience with stored procedures, complex joins, and relational database design.
- Strong analytical, problem-solving, and communication skills.
Remote PowerBI Developer in Dundee employer: TXP
At TXP, we pride ourselves on being an exceptional employer that fosters a dynamic and inclusive work culture, particularly in our Financial Services division. Our employees enjoy generous benefits such as 25 days of annual leave and private medical insurance, alongside ample opportunities for professional growth and development in the rapidly evolving FinTech landscape. Join us to be part of a forward-thinking team that values innovation and collaboration, making a meaningful impact in the world of technology sales.
