At a Glance
- Tasks: Ensure data accuracy and integrity for finance reports using Power BI and SQL.
- Company: Dynamic finance-focused organisation in Oxford with a collaborative environment.
- Benefits: Competitive daily rate, flexible work schedule, and hands-on experience.
- Other info: 3-month contract with opportunities for professional growth and learning.
- Why this job: Dive deep into data and make a real impact on financial reporting accuracy.
- Qualifications: Strong Power BI, SQL skills, and experience in data reconciliation.
The predicted salary is between 40500 - 49500 £ per year.
Power BI / Data Reconciliation Analyst (3-Month Contract)
Location
Oxford (2 days per week onsite)
Contract Length
3 Months
Rate
£300 per day (Inside IR35)
Start Date
ASAP
The Role
We are looking for an experienced Data Analyst to support a finance reporting function built on Microsoft Fabric.
The reporting environment and data model are already in place, and the focus of this role will be ensuring the accuracy, integrity and reconciliation of data feeding into business reports.
You will work across multiple source systems that load data at different frequencies, investigating discrepancies, validating data quality and making changes to data models, transformations and connections where required.
This role is ideal for someone who enjoys getting into the detail of data and ensuring figures stand up to scrutiny.
Responsibilities
- Reconcile financial data across multiple source systems.
- Investigate and resolve data quality and data integrity issues.
- Validate data loads arriving daily and monthly into Microsoft Fabric.
- Review data transformations and Power Query logic to identify issues.
- Analyse and troubleshoot Power BI semantic models and datasets.
- Use SQL to investigate anomalies and validate reporting outputs.
- Work with Finance stakeholders to understand and resolve discrepancies.
- Identify root causes of data mismatches and implement permanent fixes.
- Support ongoing maintenance and optimisation of reporting data structures.
- Ensure consistent, accurate and trusted reporting data across the organisation.
Essential Skills
- Strong Power BI experience, particularly around data models and datasets.
- Advanced DAX skills.
- Strong SQL querying and troubleshooting experience.
- Experience with Power Query (M).
- Proven background in data reconciliation and data validation.
- Experience investigating complex data issues across multiple systems.
- Strong understanding of data modelling principles.
- Experience working with finance or accounting data.
- Excellent analytical and problem-solving skills.
Desirable Skills
- Experience with Microsoft Fabric.
- Experience supporting finance reporting environments.
- Understanding of ETL and data integration processes.
- Experience working with multiple source systems feeding a central reporting platform.
- Candidate Profile
The ideal candidate will be a hands-on data professional who can quickly understand how data moves through an organisation, identify where figures do not reconcile and make the necessary changes to ensure reporting accuracy.
This role is not focused on building dashboards but instead on ensuring the underlying data feeding reports is correct, complete and trusted.
Analytics Engineer in Oxford employer: Tenth Revolution Group Careers
Join a forward-thinking organisation in South London that prioritises employee development and innovation. With a strong focus on hybrid working, you will benefit from a collaborative work culture that encourages continuous learning and professional growth. Enjoy competitive remuneration and the opportunity to make a significant impact on business transformation initiatives while working alongside dedicated professionals in a supportive environment.
Contact Details:
Tenth Revolution Group Careers Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Analytics Engineer in Oxford
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Tenth Revolution Group Careers!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Analytics Engineer at Tenth Revolution Group Careers.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Tenth Revolution Group Careers.
✨Apply Directly through Our Website
When you find a suitable opening like Analytics Engineer at Tenth Revolution Group Careers, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Analytics Engineer in Oxford
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Tenth Revolution Group Careers, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Tenth Revolution Group Careers. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Tenth Revolution Group Careers
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Tenth Revolution Group Careers!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.