Junior Analyst, IS Data & Analytics

Support the development and maintenance of business intelligence reports, data processes and dashboards, helping colleagues access accurate and reliable information.

Work under the guidance of the senior BI lead and IS Manager, taking on more independent work as skills and experience develop. Be responsible for checking, documenting and completing assigned work, and raising issues when support is needed.

• Support the development, testing and maintenance of data connections, e.g. SQL queries, ETL processes, data models, reports and dashboards.
• Carry out data validation and reconciliation, investigate discrepancies and ...
• Work with colleagues and stakeholders to clarify assigned reporting requirements and explain findings clearly.
• Monitor assigned processes, assist with incident investigation and resolve routine issues using documented procedures and appropriate review.
• Maintain documentation for assigned reports, data definitions, transformations and support procedures.
• Follow agreed technical, security and data handling standards; submit changes for review, testing and approval before release.
• Contribute to projects, process improvements and related IS support activities appropriate to the role and level of experience; develop skills through coaching and knowledge.

The scope of technology within remit includes all functions related to data science and business intelligence, but NOT in any way limited to:

• Data connectivity and integration
  • Connect to and extract data from a multitude of sources e.g. SQL Server, Oracle, MySQL and other approved sources, including spreadsheets.
  • Investigate source tables, relationships and data definitions to understand how the data should be used.
• Data transformation and loading (ETL)
  • Develop, test and maintain assigned ETL processes to extract, clean, transform and load data for reporting and analysis, using tools such as SSIS.
  • Validate loaded data, investigate failures and discrepancies, and elevate issues where support is needed.
• Assist with the design and maintenance of data models for reporting and analysis, including fact tables, dimensions and relationships.
• Document transformation rules and model structures, with changes reviewed by the senior BI lead.
• Reporting and insights
  • Build and maintain reports and dashboards; analyse data to identify trends and anomalies.
  • Check calculations and explain findings clearly, including any relevant data limitations.
• Data quality and governance
  • Carry out data profiling, cleansing and quality checks.
  • Maintain data definitions and documentation, follow access controls and elevate suspected data or security issues.
• Technical support and improvement
  • Support troubleshooting and approved automation involving BI tools and data processes.
  • Contribute to testing, documentation and implementation of improvements.
• Development
  • Build knowledge of data integration, modelling, warehousing and analytical techniques through assigned work, training and coaching.

• Relevant qualification in computing, data, mathematics or a related discipline, or equivalent demonstrable learning and practical experience.
• Foundational SQL, relational database and spreadsheet skills, with evidence from study, projects or employment.
• Ability to check data carefully, solve problems logically, communicate clearly and seek guidance when needed.
• Exposure to BI visualisation tools, ETL, SSIS, data modelling or a scripting language such as Python.
• Understanding of data quality, documentation or telecoms business data. Previous professional BI experience is not essential.