At a Glance
- Tasks: Migrate and reconcile reports while developing SQL objects and Power BI reports.
- Company: Join an NHS Trust committed to improving healthcare through data.
- Benefits: Competitive pay, flexible working, and a chance to make a difference.
- Other info: 5-month contract with opportunities for professional growth.
- Why this job: Be part of a vital transition that enhances healthcare reporting.
- Qualifications: Strong SQL Server experience and Power BI skills required.
I am working with an NHS Trust that is moving reporting to a new Data Warehouse. You will provide specialist capacity to keep agreed external reporting working through the transition, then support a review of the wider reporting estate. The role is for 5 months initially and paying £(Apply online only)pd (inside IR35).
Responsibilities
- Migrate and reconcile the agreed national, commissioning and other external reports, submissions and feeds that depend on the warehouse.
- Develop agreed reusable semantic model components and help simplify priority portal reports where this supports the migration plan.
- Assess and migrate the agreed priority reporting outputs.
- Develop required SQL objects and Power BI reports.
- Assess the existing semantic model and implement agreed shared measures and dimensions.
- Catalogue and review portal reports.
- Document, test, release and hand over the work.
- Create a catalogue with report owner, purpose, usage where available, duplication and technical dependencies.
- Recommend retain, retire, merge or redesign, with reasons.
Essential
- Strong SQL Server and Data Warehouse migration experience.
- Power BI report and semantic model design, including DAX and performance.
- Dimensional modelling and clear metric definitions.
- Reconciliation, testing and controlled deployment.
- Able to develop solutions directly and explain design decisions to teams.
BI and Data Warehouse Analyst in London employer: Morgan Law
As a local authority, we pride ourselves on being an excellent employer that values the contributions of our team members. Our work culture fosters collaboration and innovation, providing ample opportunities for professional growth and development in the field of Local Government Finance. With a focus on meaningful work and community impact, we offer competitive compensation and a supportive environment where your skills can truly shine.
StudySmarter Expert Advice🤫
We think this is how you could land BI and Data Warehouse Analyst in London
✨Tap into Online Data Science Communities
Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like Morgan Law before they're even advertised!
✨Show Off Your Skills With Projects
Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.
✨Check Out Specialist Job Boards
For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like Morgan Law.
✨Leverage University Resources
If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like Morgan Law.
We think you need these skills to ace BI and Data Warehouse Analyst in London
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at Morgan Law, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.
Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!
Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to Morgan Law, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.
Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab Morgan Law’s attention and show the tangible impact of your work.
How to prepare for a job interview at Morgan Law
✨Showcase Your Analytical Skills
For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at Morgan Law.
✨Brush Up on Technical Skills
You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.
✨Highlight Your Adaptability
Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at Morgan Law.
✨Prepare a Portfolio of Your Work
Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at Morgan Law.