At a Glance
- Tasks: Investigate data issues, reconcile discrepancies, and build trusted data layers for Power BI reporting.
- Company: Join a dynamic team focused on data quality and impactful decision-making.
- Benefits: Competitive pay, flexible working arrangements, and opportunities for contract extension.
- Other info: Ideal for those who thrive in analytical roles and enjoy tackling data challenges.
- Why this job: Make a real difference by solving complex data problems and enhancing business insights.
- Qualifications: Strong SQL and Power BI skills; experience with CRM or ERP systems is a plus.
The predicted salary is between 40000 - 50000 £ per year.
This is a hands-on data investigation and foundation-building engagement, not just a reporting role. You'll work across multiple business systems to investigate data issues, reconcile discrepancies, identify root causes, and establish a clean, trusted data layer that supports Power BI reporting and business decision-making.
We're looking for a strong Data Analyst with excellent SQL and Power BI skills who enjoys solving complex data problems. Experience working with CRM, ERP, or other enterprise systems is beneficial, with Salesforce experience considered an advantage rather than a requirement.
What You'll Be Doing:
- Audit and reconcile data across multiple business systems to identify mismatches and inconsistencies.
- Perform root cause analysis on data discrepancies, tracing issues back to business processes, system configurations, or integration issues.
- Analyse and cleanse customer, product, and transactional data to resolve duplicates, incomplete records, and inconsistencies.
- Develop complex SQL queries to investigate, validate, and reconcile data across multiple data sources.
- Map data flows between systems and document where data quality issues occur.
- Identify process and governance gaps that contribute to poor data quality.
- Build and deliver Power BI dashboards using a clean and validated data layer.
- Recommend improvements to master data management across products, customers, and accounts.
- Work closely with business and technical stakeholders to agree on data definitions, business rules, and data ownership.
- Produce clear documentation including data mappings, business definitions, and data quality findings.
Essential Skills:
- Advanced SQL including complex joins, CTEs, window functions, reconciliation queries, and performance optimisation. (Must Have)
- Power BI development including data modelling, DAX, report development, dashboard creation, and publishing. (Must Have)
- Strong experience investigating data quality issues across multiple data sources.
- Root cause analysis and data lineage investigation.
- Experience working with large, complex datasets.
- Strong analytical and problem-solving skills.
- Ability to clearly communicate findings to both technical and non-technical stakeholders.
Highly Desirable:
- Experience working with CRM platforms such as Salesforce, Microsoft Dynamics 365, HubSpot, or similar.
- Experience working with ERP systems such as SAP, Oracle EBS, NetSuite, or Microsoft Dynamics.
- Understanding of quote-to-cash, customer, product, or master data processes.
- Knowledge of Master Data Management (MDM), data governance, and data dictionaries.
- Experience with ETL or integration tools such as MuleSoft, Boomi, Informatica, or Azure Data Factory.
- Python or R for data analysis and automation.
- Exposure to Snowflake, Azure SQL, Synapse, Databricks, or similar cloud data platforms.
The Ideal Candidate:
- Enjoys investigating data problems and identifying their root causes.
- Can distinguish between data quality issues, process gaps, and system issues.
- Is comfortable working with ambiguity and defining problems through analysis.
- Has experience improving data quality, not just producing reports.
- Takes ownership of issues and provides practical, actionable recommendations.
- Communicates effectively with both business and technical stakeholders.
Deliverables:
- Cross-system data reconciliation report with documented discrepancies and root causes.
- Prioritised list of data quality issues and recommendations.
- Process gap assessment with improvement recommendations.
- Cleaned and validated data layer ready for reporting.
- Power BI dashboards built on a trusted and validated data foundation.
- Data dictionary and field mapping documentation across business systems.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst- SQL & Power BI in England
✨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 GNG Business Ltd 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 GNG Business Ltd.
✨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 GNG Business Ltd.
We think you need these skills to ace Data Analyst- SQL & Power BI in England
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at GNG Business Ltd, 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 GNG Business Ltd, 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 GNG Business Ltd’s attention and show the tangible impact of your work.
How to prepare for a job interview at GNG Business Ltd
✨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 GNG Business Ltd.
✨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 GNG Business Ltd.
✨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 GNG Business Ltd.
