Data Engineer(SSIS,SSRS&SQL)

Data Engineer(SSIS,SSRS&SQL)

City of London Full-Time 75000 - 80000 £ / year (est.) Home office (partial)
S

At a Glance

  • Tasks: Lead the development and optimisation of data systems using SQL and Google BigQuery.
  • Company: Join a forward-thinking company focused on innovative data solutions in London.
  • Benefits: Enjoy a hybrid work model, competitive salary, and opportunities for professional growth.
  • Why this job: Be part of a dynamic team that values creativity and impactful data insights.
  • Qualifications: Experience with SQL, Python, and data visualisation tools like PowerBI is essential.
  • Other info: This role offers a chance to work on exciting projects that enhance customer experience.

The predicted salary is between 75000 - 80000 £ per year.

Our client is seeking a skilled Data Engineer to take the lead in developing and optimising their data systems. This role will focus on SQL database application development, utilising Google BigQuery as the new platform for data management, and supporting the development of data analytics and visualisation tools such as PowerBI. The Data Engineer will be responsible for ensuring seamless data ingestion, transformation, and reporting, as well as working with key stakeholders to provide timely and actionable insights.

  • Developing and maintaining business-critical data ingestion, analysis, and management systems.
  • Building tools to minimize errors and improve customer experience.
  • Automating data development and governance to improve data health.
  • Developing scripts and data outputs to automate reporting and visualizations.
  • Ensuring timely and easily translatable data delivery for business stakeholders.
  • Supporting customer segmentation and data clustering for insights into customer cohorts.

Key skills for the Data Engineer include:

  • Experience with scripting languages like SQL, Python, (SSIS/SSRS), and Powershell.
  • Expertise in visualization tools such as PowerBI, Tableau, or Looker.
  • Ability to manage multiple projects with excellent organizational skills.
S

Contact Detail:

SystemsAccountants Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Data Engineer(SSIS,SSRS&SQL)

✨Tip Number 1

Familiarise yourself with Google BigQuery and its functionalities. Since this role heavily focuses on BigQuery for data management, having a solid understanding of how to leverage its features will set you apart from other candidates.

✨Tip Number 2

Brush up on your SQL skills, as they are crucial for this position. Consider working on personal projects or contributing to open-source projects that involve SQL database application development to showcase your expertise.

✨Tip Number 3

Gain hands-on experience with data visualisation tools like PowerBI, Tableau, or Looker. Create sample dashboards or reports that demonstrate your ability to turn complex data into actionable insights, which is a key requirement for the role.

✨Tip Number 4

Network with professionals in the data engineering field, especially those who have experience with SSIS and SSRS. Engaging in discussions or attending meetups can provide valuable insights and potentially lead to referrals for the job.

We think you need these skills to ace Data Engineer(SSIS,SSRS&SQL)

SQL
Python
SSIS
SSRS
PowerShell
Google BigQuery
Data Ingestion
Data Transformation
Data Reporting
PowerBI
Tableau
Looker
Data Visualisation
Project Management
Organisational Skills
Automation
Data Governance
Customer Segmentation
Data Clustering
Stakeholder Engagement

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights your experience with SQL, Python, and any relevant tools like SSIS, SSRS, and PowerBI. Use specific examples of projects where you've developed or optimised data systems.

Craft a Compelling Cover Letter: In your cover letter, explain why you're passionate about data engineering and how your skills align with the role. Mention your experience with Google BigQuery and your ability to provide actionable insights to stakeholders.

Showcase Relevant Projects: If you have worked on projects involving data ingestion, transformation, or visualisation, be sure to include these in your application. Describe your role and the impact of your work on the overall project.

Highlight Soft Skills: Don't forget to mention your organisational skills and ability to manage multiple projects. These are crucial for the Data Engineer role, so provide examples of how you've successfully juggled tasks in the past.

How to prepare for a job interview at SystemsAccountants

✨Showcase Your Technical Skills

Make sure to highlight your experience with SQL, Python, and any relevant tools like SSIS or SSRS. Be prepared to discuss specific projects where you've used these skills to solve problems or improve processes.

✨Demonstrate Your Understanding of BigQuery

Since the role focuses on Google BigQuery, it’s essential to show your familiarity with this platform. Discuss how you've used BigQuery in past projects, including any challenges you faced and how you overcame them.

✨Prepare for Scenario-Based Questions

Expect questions that assess your problem-solving abilities. Prepare examples of how you've handled data ingestion, transformation, and reporting in previous roles, focusing on the impact of your work on business outcomes.

✨Emphasise Collaboration and Communication Skills

As the role involves working with key stakeholders, be ready to discuss how you’ve collaborated with others in the past. Highlight your ability to translate complex data insights into actionable recommendations for non-technical team members.

Land your dream job quicker with Premium

Your application goes to the top of the list
Personalised CV feedback that lands interviews
Support from real people with tickets
Apply for more jobs in less time with AI support
Go Premium

Money-back if you don't land a job in 6-months

S
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>