Power BI Developer - Caterham

In this role, you will design and implement efficient SQL queries and database structures to support complex business processes and hierarchical data relationships. You'll develop recursive queries and CTEs for data manipulation, optimize stored procedures, and troubleshoot performance issues utilizing execution plans and query tuning techniques. Collaboration with developers and analysts will be key as you translate business requirements into effective database logic while enforcing data governance, integrity, and consistency across systems. You will design and maintain advanced interactive Power BI dashboards and reports, build robust data models using DAX, and manage ETL processes from various data sources, including SQL Server, Excel, and cloud platforms. Gathering and translating complex business requirements into technical specifications will be a critical part of your job. Additionally, promoting best practices in data governance and maintaining documentation for report logic and dashboard functionality will be expected. You will also optimize Power BI solutions for performance and scalability. Furthermore, you will support re-platforming initiatives with data-driven insights, mentor junior analysts, and contribute to a culture of continuous learning while identifying opportunities for new data solutions and assisting in the development of our analytics roadmap.