Business Analysis Analyst

Equinix; United Kingdom; On-site; GBP 40,000 - 60,000; Full time

Job summary

Equinix, a leading digital infrastructure company, is seeking a Programme Sourcing Specialist for a temporary contract. The role involves data management, including integration of billing and asset data, and requires proficiency in SQL, Python, and advanced Excel. This is a mid-senior level position with opportunities for professional growth in a diverse environment.

Qualifications

• Basic to intermediate SQL skills require.
• Intermediate Python skills preferred.
• Advanced Excel skills with experience in complex formulas.

Responsibilities

• Manipulate and scrub customer master data for accuracy.
• Prepare invoice to contract validation tracker using Excel.
• Load and reconcile invoice information against contracts.

Skills

SQL

Python

Advanced Excel

Finance and Accounting

Job description

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from Equinix

Programme Sourcing Specialist, Equinix EMEA via Allegis Global Solutions

Business Analysis Analyst – Temporary contract

Equinix 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 Equinix 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:

• Work with other stakeholders to manipulate data to fit in Equinix systems
• To 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
• 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
• Advanced Excel
• Use of lookups, sumifs, wide range of formulas, nested formulas, and manipulating formulas to meet needs as needed
• VBA
• 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

Skills (Beneficial)

• SQL (Basic to intermediate)
• Python (Intermediate)

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Temporary

Job function

• Job function

  Finance

• Industries

  Data Infrastructure and Analytics

Referrals increase your chances of interviewing at Equinix by 2x

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.