At a Glance
- Tasks: Design and enhance data solutions, reporting, and dashboards for a global law firm.
- Company: Join a leading global law firm known for innovation and excellence in legal services.
- Benefits: Enjoy flexible working options, professional development opportunities, and a collaborative culture.
- Why this job: Be part of impactful projects that improve systems and drive business success in the legal sector.
- Qualifications: Proven technical expertise in SQL, ETL processes, and experience with SSRS/Power BI required.
- Other info: Experience with legal applications like Elite 3E and Intapp is a plus.
The predicted salary is between 43200 - 72000 £ per year.
The Senior Technical Business Systems Analyst will design, develop, and test enhancements to the data warehouse, reporting (SSRS), and dashboards (Power BI). The role involves building strong relationships across the business to support existing systems and contribute to future upgrades and system improvements.
Key Responsibilities:
- Design, develop, and test data warehouse (Star schema dimensional model), reporting, and dashboard solutions (SSRS/Power BI).
- Create, maintain, and enhance data integrations (IntApp Integrate/SSIS).
- Analyse database data to identify and fix integrity issues.
Technical Skills and Experience:
- Proven expertise in a technical role within a global law firm.
- Understanding of business implications of legal environment applications.
- Excellent SQL skills and experience with ETL processes.
- Strong experience designing and building business-facing reports and dashboards using SSRS and Power BI.
- Knowledge of Elite 3E, Workspace, SelectHR, Interaction, Intapp Open, Integration Builder, and Walls is advantageous.
Senior Technical Business Systems Analyst employer: DGH Recruitment
Contact Detail:
DGH Recruitment Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Technical Business Systems Analyst
✨Tip Number 1
Familiarise yourself with the specific tools mentioned in the job description, such as SSRS and Power BI. Having hands-on experience or even creating sample projects using these tools can demonstrate your capability and enthusiasm for the role.
✨Tip Number 2
Network with professionals in the legal tech industry, especially those who work in global law firms. Engaging in conversations about their experiences can provide valuable insights and potentially lead to referrals.
✨Tip Number 3
Showcase your understanding of the legal environment by discussing relevant case studies or examples during interviews. This will highlight your ability to connect technical solutions with business implications in a legal context.
✨Tip Number 4
Prepare to discuss your experience with data integrity issues and how you've resolved them in past roles. Being able to articulate your problem-solving skills in this area will be crucial for the position.
We think you need these skills to ace Senior Technical Business Systems Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with data warehousing, reporting, and dashboard solutions. Emphasise your SQL skills and any relevant projects you've worked on that align with the job description.
Craft a Compelling Cover Letter: In your cover letter, explain how your background in a global law firm has prepared you for this role. Mention specific technologies like SSRS, Power BI, and any experience with data integrations that would make you a strong candidate.
Showcase Technical Skills: Be explicit about your technical skills in your application. Include examples of how you've designed and developed reporting solutions or fixed integrity issues in databases, as these are key responsibilities of the role.
Highlight Relationship Building: Since the role involves building strong relationships across the business, include examples in your application of how you've successfully collaborated with different teams or stakeholders to achieve project goals.
How to prepare for a job interview at DGH Recruitment
✨Showcase Your Technical Skills
Be prepared to discuss your experience with SQL, ETL processes, and data warehouse design. Bring examples of reports or dashboards you've created using SSRS and Power BI to demonstrate your expertise.
✨Understand the Legal Environment
Familiarise yourself with the specific applications used in a legal context, such as Elite 3E and Intapp. Showing that you understand the business implications of these systems will set you apart from other candidates.
✨Emphasise Relationship Building
Highlight your ability to build strong relationships across departments. Prepare examples of how you've collaborated with different teams to enhance systems or resolve issues in previous roles.
✨Prepare for Problem-Solving Questions
Expect questions that assess your analytical skills, particularly regarding data integrity issues. Be ready to discuss specific challenges you've faced and how you approached solving them.