Business Intelligence & Data Analytics Engineer

Scorus Solutions; Glasgow; On-site; GBP 45,000 - 65,000; Full time

Job summary

Scorus Solutions in Glasgow is seeking a Business Intelligence and Data Analytics Engineer to design, build, and maintain data pipelines and ETL processes on-site. You will create data models, dashboards, and reports using BI tools, analyze large datasets for trends, and collaborate with cross-functional teams to translate business needs into data requirements.

The role emphasizes data quality, governance, and end-user training to enable informed decision-making across the organization.

Qualifications

• Master’s degree or equivalent practical experience in data-related field.
• Proven experience in BI, data analytics, and data warehousing.
• Strong SQL and database management skills.
• Excellent analytical and problem-solving abilities.
• Able to communicate complex data insights to non-technical stakeholders.
• Experience in developing and maintaining ETL processes.
• Experience with streaming or micro-batch processing.
• Experience creating dashboards and data visualizations.
• Experience with data modeling.
• Hands-on with Python or R.
• Experience with Spark or Flink.

Responsibilities

• Design, develop, and maintain data pipelines and ETL processes.
• Create and manage data models, dashboards, and reports using BI tools.
• Analyse complex datasets to identify trends and opportunities.
• Collaborate with cross-functional teams to translate business needs into data requirements.
• Ensure data quality and integrity through testing and validation.
• Develop and implement data governance policies and procedures.
• Provide technical support and training to end-users on BI tools and data analysis.

Skills

Analytical thinking

Problem-solving

Communication

Data analysis

Data governance mindset

Education

Master’s degree in Data Science/CS/Statistics or equivalent

Tools

BigQuery Studio

Looker

Tableau

Power BI

Python

R

Apache Spark

Apache Flink

Job description

This is a full-time on-site role for a Business Intelligence and Data Analytics Engineer located in Glasgow. This role is crucial in transforming raw data into actionable insights that drive business decisions. You will design, develop, and maintain data pipelines and ETL processes, create and manage data models, dashboards, and reports using BI tools, and analyse complex datasets to identify trends and patterns. You will collaborate with cross-functional teams to understand business needs and translate them into data requirements.

Responsibilities:

• Design, develop, and maintain data pipelines and ETL processes.
• Create and manage data models, dashboards, and reports using BI tools.
• Analyse complex datasets to identify trends, patterns, and opportunities for improvement.
• Collaborate with cross-functional teams to understand business needs and translate them into data requirements.
• Ensure data quality and integrity through rigorous testing and validation.
• Develop and implement data governance policies and procedures;
• Provide technical support and training to end-users on BI tools and data analysis techniques

Requirements:

• Master’s degree in Data Science, Computer Science, Statistics, or a related field, or equivalent practical experience;
• Proven experience in business intelligence, data analytics, and data warehousing;*Strong proficiency in SQL and experience with database management systems;
• Excellent analytical and problem-solving skills;
• Ability to effectively communicate complex data insights to non-technical stakeholders;
• Experience in developing and maintaining ETL (Extract, Transform, Load) processes;
• Experience with data pipelines and stream or micro-batch processing to convert real-time events to business intelligence data-points;
• Experience in creating insightful data visualizations, dashboards, and reports;
• Experience in analysing large datasets to identify trends and patterns;
• Experience in designing and implementing data models.
• Hands-on experience with BI tools such as BigQuery Studio, Looker, Tableau, Power BI, or similar.
• Experience with scripting languages like Python or R
• Experience with Apache Spark, Apache Flink, or other frameworks for stream or micro-batch processing