Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join our team to analyse data, manage contracts, and ensure billing accuracy.
- Company: Be part of a leading digital infrastructure company with 240+ data centres worldwide.
- Benefits: Enjoy opportunities for remote work, skill development, and a diverse workplace culture.
- Why this job: Make a global impact while learning in a fast-growing, innovative environment.
- Qualifications: Advanced Excel skills required; knowledge of SQL and Python is a plus.
- Other info: Training provided on product structure and company operations.
The predicted salary is between 36000 - 60000 £ per year.
Our partner is the world’s digital infrastructure company, operating 240+ data centers across the globe and providing interconnections to all the key clouds and networks. Businesses need one place to simplify and bring together fragmented, complex infrastructure that spans private and public cloud environments. Our global platform allows customers to place infrastructure wherever they need it and connect it to everything they need to succeed. We are a fast-growing global company with 20 years of continuous growth. Through our innovative portfolio of high-performance products and services, we have created the largest, most active global ecosystem of 10,000+ companies, including 2,100 networks and 3,000+ cloud and IT service providers in 32 countries spanning six continents. A career at this firm means you will collaborate on work that impacts the world and be surrounded by endless opportunities to learn new skills and grow in varied directions. We embrace diversity in thought and contribution and are committed to providing an equitable work environment that is foundational to our core values as a company and is vital to our success.
Roles and Responsibilities:
- Dart / Staging Environment (Main Priority)
- Work with other stakeholders to manipulate data to fit in our partner's systems
- Understand contracts (as per contract info)
- Understand product structure (training provided)
- Link billing data to asset data with data team (DQM team)
- All customer (circa 200) data is to be loaded and linked to assets
- Use of custom tool (Dart) to upload
- Use SQL to download data files from Dart to identify gaps
- Use of any software to analyse data and feedback as required
- While using Dart flag any potential enhancement requirements or bugs and defects
- Attend calls (3x per week)
- Scrub Customer Master Data
- Review report from acquired company and work cross functionally to ensure all data is accurate and up to date
- Relay information to track lead
- Validate information is accurate
- Attend weekly calls (2x per week)
- Provide dashboard with commentaries on accuracy or gaps
- Understand contracts and update as necessary (Initial Essential Work)
- Prepare a tracker for invoice to contract validation using excel or appropriate tool such as smart sheets
- Review and understand Contracts and detail information in an appropriate area such as smart sheets, or excel
- Review invoices and summarise learnings by using the appropriate software which can be Excel, SQL, or as needed
- Populate tracker with information from contracts and invoices and prepare a summary file highlighting fallouts
- Invoices
- Extract information from invoices by script e.g. Python
- Load invoice information to Dart and compare vs Billing Lines and Contract data
- Reconcile information in invoices vs expected billing
- PGLS
- Will require working in Excel and smartsheets to identify fallouts from data migration
- Perform fixes to billing data based using agreed documented processes
- Obtain approvals from relevant stakeholders
- Ad-hoc
- Help with data issues as required
Knowledge Requirements:
- Basic finance and accounting e.g. what AP/AR/GL/Procurement areas, and what the functions do
- How invoices and credit notes work alongside receipts/collections
Learning:
- How the company works (training provided)
- Understand product structure (training provided)
- Dig into and learn about our client with a focus on billing, billing systems, and billing processes, and billing software used (this should be driven by the individual)
Skills (Necessary):
- Advanced Excel
- Use of lookups, sumifs, wide range of formulas, nested formulas, and manipulating formulas to meet needs as needed
- VBA
Skills (Beneficial):
- SQL (Basic to intermediate)
- Python (Intermediate)
Business Analysis Analyst employer: Allegis Global Solutions
Contact Detail:
Allegis Global Solutions Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Analysis Analyst
✨Tip Number 1
Familiarise yourself with the Dart tool and its functionalities. Since this role heavily relies on using Dart for data manipulation, understanding how to navigate and utilise this software will give you a significant advantage during the interview process.
✨Tip Number 2
Brush up on your SQL skills, particularly in downloading data files and identifying gaps. Being able to demonstrate your ability to work with SQL during discussions will show that you're prepared and capable of handling the technical aspects of the job.
✨Tip Number 3
Gain a solid understanding of basic finance and accounting principles, especially accounts payable and receivable. This knowledge will help you relate better to the tasks involving invoices and contracts, making you a more attractive candidate.
✨Tip Number 4
Prepare to discuss your experience with Excel, particularly advanced functions and VBA. Be ready to provide examples of how you've used these skills in previous roles, as they are crucial for the data analysis tasks you'll be handling.
We think you need these skills to ace Business Analysis Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience and skills that align with the job description. Focus on your proficiency in Excel, SQL, and any experience with data manipulation or analysis.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention specific projects or experiences that demonstrate your ability to work with data and collaborate with stakeholders.
Showcase Relevant Skills: Emphasise your advanced Excel skills and any experience with VBA, SQL, or Python. Provide examples of how you've used these tools in previous roles to solve problems or improve processes.
Highlight Learning Agility: Since the company values continuous learning, mention your willingness to learn new systems and processes. Share any past experiences where you quickly adapted to new tools or environments.
How to prepare for a job interview at Allegis Global Solutions
✨Showcase Your Data Skills
Make sure to highlight your proficiency in Excel, SQL, and any experience with Python during the interview. Be prepared to discuss specific examples of how you've used these tools to manipulate and analyse data in previous roles.
✨Understand the Company’s Ecosystem
Familiarise yourself with the company's global platform and its role in digital infrastructure. Understanding how their services connect various clouds and networks will demonstrate your interest and help you answer questions more effectively.
✨Prepare for Scenario-Based Questions
Expect questions that assess your problem-solving skills, especially related to data accuracy and reconciliation. Think of scenarios where you've had to troubleshoot data issues or improve processes, and be ready to share those experiences.
✨Emphasise Collaboration and Communication
Since the role involves working with various stakeholders, be sure to convey your ability to communicate effectively and collaborate across teams. Share examples of how you've successfully worked with others to achieve common goals.
