Data Engineer with Azure & Power BI
Permanent £65-70k + Great Bens
Hybrid Flexible Working – London area
Talented and experienced Data Engineer / Power BI Developer, strong in both interpersonal communication skills, as well as key technical experience including; strong SQL, Azure Synapse Analytics and Power BI (DAX & PowerQuery). This is a key technical role to join a small dynamic and friendly team, responsible for the data that enables our client to deliver premium entertainment to a Global network of over a billion airline passengers. You will play a crucial part in the continued development and maintenance of the existing data warehouse solution, including data analysis, integration pipeline creation, SQL JSON querying and reporting using Power BI. The cloud based systems leverage data to support operational activities and inform business decisions. The combination of creativity and technology is at the heart of what we do and helps us provide next generation experiences for the international travelling audience.
Reporting to the Senior Architect and working closely with the team’s Business Analyst and various internal stakeholders. This position requires strong business facing, customer facing communication and collaboration skills.
The team have a flexible, relaxed but professional approach. Flexible hybrid working with approx. 1-2 days a week in London (West End). Work life balance is important to everyone in the team and flexibility will be shown wherever possible.
About the role – Main Duties & Responsibilities
* Collaborate with stakeholders to understand business requirements and translate them into actionable insights and data solutions.
* Utilize strong SQL skills, including with JSON querying, to extract and manipulate data from various sources.
* Create and maintain datasets in Azure Synapse Analytics and other relevant platforms to enable self-service ad-hoc analysis.
* Develop and manage data pipelines using Azure Synapse Analytics or Azure Data Factory.
* Work with columnar storage formats such as Parquet and Delta to optimize data storage and retrieval processes.
* Design, develop, and maintain Power BI reports and dashboards to meet business needs.
* Implement DevOps best practices for source control using Git, ensuring proper versioning and change management.
* Provide technical support and guidance to other team members on SQL, Power BI, and related technologies.
* Stay current with industry trends and advancements in data engineering and business intelligence.
* Help Maintain and Develop the existing Data Tech Stack Sources: CosmosDb, BlobStorage, AWS Dynamo, REST API’s, Data Warehouse: Azure Synapse Analytics
About you
Core skills
* Proven experience as a Data Engineer, Business Intelligence Developer (MS Stack) , ideally a hybrid role where you are happy doing both.
* Strong recent expertise in Power BI, including DAX and Power Query.
* Strong proficiency in SQL including stored procedures and ideally experience with JSON querying.
* Proficiency in Azure Synapse Analytics or Azure Data Factory for building and managing data pipelines.
* Excellent communication and interpersonal skills (very important!), with the ability to effectively collaborate with cross-functional teams and customers
Other skills
* Experience or knowledge of columnar storage formats, especially Parquet and Delta
* Familiarity with DevOps practices, particularly source control using Git.
* Strong analytical and problem-solving abilities.
* Ability to prioritize and manage multiple tasks in a fast-paced environment.
* Strong Excel
Nice-to-Have Skills:
* Experience with SQL serverless technologies.
* Knowledge of Cosmos Azure Synapse Link for seamless data integration.
* Understanding of DevOps best practices for SQL and Power BI projects, including DACPAC, CI/CD, and versioning.
* Familiarity with Apache Spark for big data processing.
* Additional development experience in Python or related technologies.
* Experience gained within a Media, Travel or Broadcast Media sectors would be a plus.
Qualifications:
* Bachelor’s degree in Computer Science, Engineering, or related field (or equivalent work experience).
In return our client offers
This is a great role in a small team with real opportunities to help develop the solutions going forward and make an impact on how and what technologies are used. You will be able to utilise your data skills across BI and Data engineering and not have to lose them in an overly specialised role.
Competitive basic salary, Enhanced Pension, Private Medical & Dental Insurance, Life Insurance and Group Income Protection, 25 days holiday allowance increasing to 30 days after one year of service (plus bank holidays)
Birthday Day Off, Enhanced family-friendly policies (maternity, paternity, carers leave)
Hybrid working – flexible, approx.1-2 days per week, A great team of fantastic colleagues who love what they do
The benefits of being part of a larger media group (without the bureaucracy!) – the wider agency network and access to central resource
This position is hybrid but part located in London, so you need to be well located and have the right to work in the UK (as sponsorship is not available).
Everybody is welcome
Diversity and Inclusion Statement. | PCR Digital
“At PCR Digital, we are committed to ensuring that diversity, equity and inclusion play a role at all stages of our recruitment – it is important to us that our own company culture and the culture of our network is as varied and supportive as possible. We love people (it’s why we do what we do), so, regardless of background, we welcome you to work with us or apply to any of our jobs if you feel that they are right for you.”
We also aim to ensure that our entire process is accessible. Please make us aware of any adjustments you may need throughout the selection, interview and general process and we will do all we can to ensure that any barriers are removed for you.
