Data Analytics Specialist
Judd Street, London, United Kingdom
BT Group
From Ultra Fast Full Fibre broadband to TV & Mobile, BT helps UK families, communities & companies reach their potential. Find more BT products here.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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Architecture Data Analytics Engineering GCP Oracle Qlik RDBMS SQL
Perks/benefits: Competitive pay Equity Salary bonus
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Engineer II jobs
- Open Data Science Manager jobs
- Open Principal Data Engineer jobs
- Open Marketing Data Analyst jobs
- Open Lead Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open MLOps Engineer jobs
- Open Power BI Developer jobs
- Open Business Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Data Scientist II jobs
- Open Product Data Analyst jobs
- Open Junior Data Scientist jobs
- Open Business Intelligence Developer jobs
- Open Sr Data Engineer jobs
- Open Data Analyst Intern jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Sr. Data Scientist jobs
- Open Principal Data Scientist jobs
- Open Research Scientist jobs
- Open Data Quality Analyst jobs
- Open Manager, Data Engineering jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open NLP-related jobs
- Open PyTorch-related jobs
- Open Finance-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open LLMs-related jobs
- Open Consulting-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Snowflake-related jobs
- Open Hadoop-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Airflow-related jobs