Senior Azure Data Analyst
United Kingdom | Remote
Responsibilities
Location London, GB Job ID JR-029758Who 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.
We are seeking an experienced Data Analyst/Engineer with strong SQL, Power BI and Azure 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. You will be working collaboratively with a range of stakeholders, business and technical. Demonstrable experience of fully 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 a strong database background with proven querying and data visualisation experience. The desire and willingness to pick up new skills is imperative.
Tech Stack / Tools
- SQL Server (essential)
- Power BI (essential)
- DAX (highly desirable)
- Microsoft Dynamics AX / D365 (highly desirable) / ERP Systems
- Azure data platform (Azure Data Factories, Function Apps, Logic Apps, Synapse, Data Lake, Azure SQL DB) (highly desirable)
- Python (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
- 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
- Using a cloud-first mentality utilise the Azure data tools
- 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
#LI-EMEA
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.