Senior Azure Data Engineer
United Kingdom | Remote
Responsibilities
Location Buckinghamshire, GB Job ID JR-034800Who are we?
Horizon Discovery, a PerkinElmer company, drives the application of gene editing and gene modulation to enable world-leading academic institutes, pharmaceutical and biotechnology companies, as well as clinical diagnostic laboratories, to identify the genetic drivers behind human disease, develop and validate diagnostic workflows, and deliver new therapies for precision medicine.
With more than a decade of experience in the engineering of cell lines, Horizon offers innovative services including the Dharmacon™ suite of gene discovery tools with the ability to modulate, or permanently alter, the function of almost any gene in human and other mammalian cell lines.
Horizon is headquartered in Cambridge, UK with offices in Boulder, Colorado, USA and Japan.
Purpose
We are seeking an experienced Data Analyst/Engineer with strong Azure, SQL, and Power BI skills. You will be responsible for building robust, scalable, and maintainable solutions across a range of projects including Business Intelligence, Process Automation, and Systems Integration.
Key to this role is the ability and desire to understand the data from multiple internal systems and external data sources and provide rich analytics and business intelligence across the company and maintain and enhance the cloud-based architecture to perform the ETL and data storage.
You will be working collaboratively with a range of stakeholders, business and technical. Demonstrable experience in understanding how a range of systems work together and how to transform data between systems is essential.
Our tech stack is diverse to solve a wide range of business and technical challenges. It is essential that you have experience in cloud-based solutions and a strong database background with proven querying and data visualisation experience. The desire and willingness to pick up new skills is imperative as we are constantly working with cutting-edge technologies from Microsoft and other providers.
Tech Stack / Tools
Azure data platform (Azure Data Factories, Function Apps, Logic Apps, Synapse, Data Lake, Azure SQL DB) (essential)
SQL Server (essential)
Power BI (highly desirable)
Python (highly desirable)
DAX (desirable)
Microsoft D365/ERP Systems (desirable)
Exposure to API for gathering data from external sources (desirable)
Microsoft Power Platform (PowerApps, Power Automate - Flow) (desirable)
Other databases (PostgreSQL, MySQL, Cosmos DB) (desirable)
Key Responsibilities
Using a cloud-first mentality utilise the Azure data tools
Building data transformation pipelines in Azure to pull data from multiple sources into a central Data warehouse
Querying, reporting and business intelligence through Power BI
Become a domain expert and point of contact on data across the business
Automating repetitive business processes
Design, development, maintenance, and transformation of databases
Requirements gathering for data-centric projects
Work in an Agile development process with user stories
About You
Excellent communication skills
Strong analytical skills and attention to detail
Ability to work autonomously, be self-motivated and results driven
Creative and able to solve business problems
A degree or equivalent experience in a related discipline
Happy to work remotely with daily scrum meetings to update on progress
#LI-Remote
PerkinElmer is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability status, age, or veteran status or any other characteristics protected by applicable law. PerkinElmer is committed to a culturally diverse workforce.
