Data Engineer with Azure & Power BI
Job Details
Full Job Description
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.