Data Engineer (Aberdeen)

We are looking for a hands-on, technically driven Data Engineer to join our expanding data team. This role is ideal for someone with a strong foundation in SQL and data management, who has recently graduated from a Data Science or Data Engineering programme and is eager to apply their skills in a modern, forward-thinking environment.

You will be responsible for developing and maintaining robust data solutions that support reporting, automation, and strategic decision-making across the business. The successful candidate will have up-to-date knowledge of data tooling and methodologies, particularly in SQL, Power BI, and data automation, with an interest in modern data architecture such as cloud-based warehousing and lakehouse solutions.

As the role sits within a relatively new department, where methodologies and processes are still evolving, there is a significant opportunity to help shape the future of OEG’s data management practices.

Key Responsibilities:

Database and Data Engineering

• Design, develop, and maintain SQL-based solutions and data pipelines.
• Manage relational databases, ensuring data can be extracted, transformed, updated, and exported efficiently.
• Write complex T-SQL queries, stored procedures, and functions to support data processes.

Data Visualisation and Reporting

• Develop insightful and interactive dashboards using Power BI and DAX .
• Translate business requirements into visual analytics for various departments.
• Monitor and enhance report performance and usability.

Automation and Workflow Management

• Use Power Automate to streamline data workflows and automate routine reporting tasks.
• Support cross-system data integration where applicable.

ETL Development and Modernisation

• Build and maintain ETL pipelines using best practice methods and modern tooling.
• Support data transformation and movement across systems and platforms.
• Participate in the adoption and maintenance of cloud-first data solutions.

Innovation and Future-Proofing

• Stay up to date with modern tools and methodologies, including but not limited to Microsoft Fabric , Databricks , and Lakehouse architectures.
• Ensure solutions are scalable, maintainable, and aligned with evolving best practices.
• Contribute to shaping the future state of the organisation’s data estate.

Qualifications & Experience:

• Bachelor’s degree in Data Science , Data Engineering , Computer Science , or a closely related field (ideally graduated within the past few years).
• 1–3 years' relevant work experience, either from a commercial role or significant academic/placement projects.
• Hands-on experience with SQL Server , Power BI, and Power Automate preferred.

Skills and Competencies:

This role requires a motivated and detail-oriented individual with a passion for working with data. You will be expected to work collaboratively and drive value through well-crafted, efficient solutions.

Technical Skills:

• Strong skills in SQL / T-SQL , including writing queries, procedures, and managing database structures.
• Proficient in Power BI dashboard development and DAX formulas.
• Experience with Power Automate for data-driven workflows.
• Understanding of ETL concepts and processes.
• Exposure to modern data platforms such as Azure Data Lake , Databricks , or Microsoft Fabric is a bonus.

Analytical Skills:

• Ability to understand complex data structures and derive actionable insights.
• Strong problem-solving ability with attention to detail.
• Curious and data-driven mindset with a continuous improvement approach.

Communication Skills:

• Capable of explaining technical concepts to non-technical stakeholders.
• Clear written and verbal communication style.
• Strong team player with a collaborative approach.

Strategic Thinking:

• Ability to contribute to discussions on the evolution of data architecture.
• Passionate about using modern tools to drive business value.
• Willingness to learn and grow with the organisation's data journey.