At a Glance
- Tasks: Develop SQL and Power BI solutions to transform data into actionable insights.
- Company: Join a global law firm with a focus on innovation and collaboration.
- Benefits: Competitive salary, bonus, hybrid work model, and comprehensive benefits.
- Other info: Dynamic team environment with opportunities for professional growth.
- Why this job: Make a real impact by shaping the firm's Business Intelligence and data platform.
- Qualifications: Strong SQL, ETL, and Power BI skills; excellent stakeholder engagement required.
The predicted salary is between 80000 - 90000 £ per year.
Business Intelligence Developer - SQL, ETL, Power BI, DAX, Azure Data Factory, Data Warehousing, Reporting & Dashboard Development.
Permanent.
London Hybrid (3/2). c.£80k -£90k + Bonus + Benefits
Global Law Firm seeks an experienced Business Intelligence Developer to join its Business Systems team, supporting and developing a business-critical BI Reporting and data platform.
You'll work across an Enterprise Data Warehouse, Microsoft Power BI/Fabric and Azure Data Factory, helping the firm turn data into meaningful business insight while ensuring applications remain reliable, scalable and aligned with evolving business needs.
The role has three key pillars
- SQL Engineering / ETL
- Power BI Report & Dashboard Development
- , and
- Stakeholder Liaison
- gathering, defining and maturing requirements for Business Intelligence.
You'll combine strong technical capability with excellent stakeholder skills, translating business requirements into effective data solutions and communicating technical concepts clearly to non-technical users.
Key Responsibilities
- Develop and maintain SQL, data warehouse structures and ETL processes using Azure Data Factory.
- Design and develop Power BI reports, dashboards and semantic models using DAX.
- Work with stakeholders to gather, define and mature Business Intelligence requirements.
- Translate business needs into practical BI solutions, enhancements and reporting capabilities.
- Support integrations using Azure Data Factory, including REST API and OData connections.
- Troubleshoot complex technical issues and proactively identify opportunities for improvement.
- Manage application changes, documentation, security, governance and third-party relationships.
We're looking for candidates with strong Business Intelligence, Data Engineering and Power BI experience, combined with the ability to engage confidently with business stakeholders.
You will possess
- Expert SQL skills including stored procedures, functions, XML and JSON data types.
- Strong understanding of Data Warehouse methodologies such as Kimball and Inmon.
- Strong Power BI report and dashboard development and DAX skills, including semantic modelling and paginated reports.
- Experience building ETL and integrations using Azure Data Factory.
- Strong stakeholder engagement skills with the ability to gather and translate BI requirements.
- Excellent communication and documentation skills, with the ability to explain technical concepts to non-technical audiences.
- Experience with Tabular Editor, DAX Studio and ALM Toolkit would be desirable.
- Experience of Dev Ops, CI/CD and deployment pipelines would be advantageous.
- Experience within the legal sector or another highly regulated environment is desirable.
- Experience with aspects of MS Fabric will be useful as the platform is being rolled out across the environment.
This is an excellent opportunity to join a Business Systems team working across multiple systems and depts within the firm where you'll combine hands-on SQL and ETL engineering, Power BI development and business-facing requirements gathering to help shape and improve a highly important Business Intelligence and data platform.
Experience gained in Law Firm, Legal Services, Legal Application Vendors / Systems Integrators or Consultancies welcomed but non-essential.
We can consider experience from Financial Services, Banking / Investment Banking (London Stock Exchange, London Metal Exchange etc) as well as from within wider professional services environments.
#J-18808-Ljbffr
Business Intelligence Developer - SQL, ETL, Power BI, DAX in London employer: Comtecs Ltd
Join a well-established business consultancy that values innovation and collaboration, offering a fully remote DevOps Engineer / SysAdmin role with competitive contract rates. Enjoy a supportive work culture that fosters professional growth through hands-on experience with cutting-edge technologies like AWS and IBM Cloud, while also benefiting from local accommodation during onboarding and flexible check-ins. This is an excellent opportunity for those seeking meaningful work in a dynamic environment that prioritises employee development and teamwork.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence Developer - SQL, ETL, Power BI, DAX in London
✨Get to Grips with Data Visualisation Tools
If you're aiming for a full-time role in business intelligence, brush up on your skills with popular data visualisation tools like Tableau or Power BI. Showcasing projects where you've transformed raw data into clear visual insights can give you a real edge.
✨Join Local Business Intelligence Meetups
Look for local business intelligence meetups or analytics conferences in your area. These events are not just great for learning but also for networking with industry professionals who could lead you to opportunities at companies like Comtecs Ltd!
✨Engage with Online BI Communities
Join online forums or communities focused on business intelligence—think LinkedIn groups, Reddit threads, or even dedicated Slack channels. Engage actively by sharing your insights and asking questions; this can help you build visibility and connect with potential employers.
✨Leverage Your University’s Career Support
If you're a recent graduate, definitely tap into your university's career services. Many have connections with companies in need of full-time BI specialists, and they can guide you on how to pitch yourself effectively—don't miss out on that!
We think you need these skills to ace Business Intelligence Developer - SQL, ETL, Power BI, DAX in London
Some tips for your application 🫡
Highlight Your Analytical Skills:In the business intelligence field, showcasing your analytical skills is a must. Make sure your CV includes relevant experience with data analysis tools, programming languages like SQL or Python, and any projects where you've interpreted complex data sets to drive business decisions.
Showcase Your Business Acumen:Don't just focus on data; show us how you can apply your insights to real-world business problems. Highlight projects where you made a tangible impact on company performance, and be prepared to explain your thought process in your cover letter.
Tailor Your Documents for Us:When applying for a full-time role at Comtecs Ltd, tailor your CV and cover letter to reflect our organisational goals and strategies. Mention specific tools and methodologies that align with what we do—this shows you’ve done your homework and are genuinely interested in our mission!
Include Relevant Certifications:Certifications like Google Data Analytics or similar qualifications can really make you stand out in business intelligence. Include these in your application, as they demonstrate your commitment to the field and your willingness to stay current with industry standards.
How to prepare for a job interview at Comtecs Ltd
✨Show off your analytical skills
In a business intelligence role, you're going to need to demonstrate your analytical prowess. Be prepared to discuss specific tools you've used, like SQL, Tableau, or Power BI. Have real-world examples ready where you’ve turned data into actionable insights – this is what makes us shine in interviews!
✨Practice your technical know-how
Expect some technical questions during the interview that dive deep into your understanding of data modelling and analytics frameworks. Brush up on your knowledge of data warehousing concepts and be ready to tackle any real case scenarios they might present. They’ll want to see how you approach problems using your BI toolkit.
✨Portfolio of Projects
Since it's a full-time role, having a strong portfolio is key! Compile case studies demonstrating your previous projects, preferably showing how your insights led to business improvements. This can help us display how you think through complex datasets and your problem-solving process, which is what employers are keen on seeing.
✨Know their business model
Get familiar with Comtecs Ltd’s business model and recent data-driven decisions. Be prepared to discuss how your skills can specifically support their objectives or challenges. Understanding their landscape shows that you’re not just a data buff, but you’re also genuinely interested in how BI can impact their bottom line.
