Data Analytics Specialist

Location – London (Gradechurch Street)

Why this job matters

As a Commercial Data Analytics Specialist, you will be supporting the Openreach Commercial team with rich data and insights. You will be responsible for engineering rich datasets to answer business questions coming from either internal or external stakeholders. You will also be responsible for executing tactical billing or tactical reconciliation of strategic billing. This will enable the Openreach Commercial team to drive higher revenue opportunities as well as potential cost saving initiatives. All of this is a key driver of the business case behind our investment in full fibre.

You’ll have the following responsibilities

• Engineer data tables in Datalabs and/or GCP to generate rich datasets that can be utilised for further analysis
• Summarise engineered data in Qlik dashboards for consumption by internal and external stakeholders
• Calculate discounts / penalties in accordance with commercial offers terms using data inputs from various systems: Atlantis, Orbit, Datalabs / GCP etc
• Manage and automate CP reporting for commercial offers and other insights sharing activities
• Automate all billing and reporting activities
• Maintain 30+ existing Qlik dashboards ensuring data integrity and consistency of logic, definitions
• Manage team of data engineering analysts to create, automate and maintain datasets and Qlik dashboards
• Manage Roadmap of data requests through an agile Sprint method

You’ll need to have the following skills and experience

• Oracle PL/SQL Developer Certified Associate
• Experience in having built amalgamated data tables in Oracle Datalabs
• Experience in having built, maintained, automated and productised Qlik dashboards created on the back of large amalgamated data tables
• Experience in having worked with Billing and L2C systems in use in BT such as Siebel (CRM), FLOW (Orchestration & Fulfilment), BAL (Billing Gateway), Atlantis (Billing System) and Orbit
• Experience in working with Rating and Billing Configuration views within RBM architecture e.g. RBM 5 System Processes such as MI Write/Complete, PR Write/Complete, Task Master, Bill Formatting etc.
• Experience in working with Rating Process Flows starting with Call Detail Record (CDR) generation from Mediation systems.
• Experience working on Entity-Relationship (ER) models for normalised data storage in Oracle RDBMS.
• Version Control using Apache Subversion (SVN).
• Source Code Documentation.

Benefits

As well as offering a competitive base salary, you’ll also have a rewarding bonus scheme, access to equity schemes and an attractive pension offer.

We value different perspectives, skills and experiences. Diversity makes sense for us, our customers and our ambitions. We’re creating an inclusive working culture where people from all backgrounds can succeed.

About Openreach

We’re the nation’s number one broadband network and we build the connections that matter.
Our customers are the 640+ communications providers who sell phone, broadband and Ethernet services to homes and businesses and our mission is build the best digital future for the UK.

There’s over 33,000 of us across the country, and we have a vision that our workforce should represent the communities that we serve. Diversity and accessibility are important to both where we are now and where we’re going. We value every colleague and the contribution they make, because a diverse business is a stronger business.

We also want the best work-life balance for all our people, which is why we offer smart working. It’s not a one-size-fits-all solution, so you’ll be able to discuss how smart working fits with your role during the recruitment process.

How to apply

It’s easy to apply online; you just need a copy of your up-to-date CV and to follow the step-by step process. Don’t worry if you need to make changes – you’ll have the opportunity to review and edit your work on the final page.

We’re creating an inclusive working culture where people from all backgrounds can succeed. We welcome applications from every community and we’re looking forward to receiving yours.