Data Engineer

About Avalere Health

Guided by a single mission to make EVERY PATIENT POSSIBLE, our Advisory, Medical, and Marketing capabilities move as one, ensuring every patient is identified, supported, treated, and cared for. Equally.

Avalere Health is a global strategic partner, perfectly formed to solve the biggest challenges in health—at pace and at scale. We are united across the product lifecycle, uniquely positioned to understand every angle of life, health, and the human condition. Partnering with our clients, we are building a world where healthcare is not a barrier. And no patient is left behind.

We are powered by our unique and proprietary model, SenseMaking. Combining strategic tools and human ingenuity, SenseMaking allows us to transform limitations into pathways, obstacles into possibilities, and intricacy into action. Our talented, diverse, and passionate team—known as SenseMakers—strive each day to make EVERY PATIENT POSSIBLE.

About the role 

As an Azure Data Engineer, your role involves designing, implementing, and managing data solutions on the Microsoft Azure cloud platform. Your responsibilities will include, but not limited to: 

Data Integration 

Data Integration and ETL (Extract, Transform, Load): You’ll develop and implement data integration processes to extract data from diverse sources and load it into data warehouses or data lakes. 

Azure Data Factory is a key tool for building efficient ETL pipelines. Your goal is to ensure that data is effectively cleaned, transformed, and loaded. 

Your sources will include Rest API from various systems. Being able to onboard data from API's is essential. Use of Postman for testing outside of ADF is a preferred skill. 

Data Engineering 

As an Azure Data Engineer, you’ll handle and analyse large volumes of data using big data technologies available on the Azure platform. 

Your responsibilities include creating data processing workflows and pipelines to support data analytics, machine learning, and other data-driven applications. 

1. In summary, your role revolves around building data processing pipelines, creating analytics solutions, and enabling data-driven decision-making within organizations using Azure cloud tools 

2. Keep honing your skills, as the demand for Microsoft Certified Data Engineers continues to grow! 

Data Management and Storage: 

You’ll work with various data storage options provided by Microsoft Azure, including Azure SQL Database, Azure Data Lake Storage, and Azure Blob Storage. 

Your task is to design data storage systems that scale, perform efficiently, and meet the organisation’s requirements. 

Essential Skills

• Proficiency in SQL, SQL Server 
• Understand parallel processing and data architecture patterns 
• Azure Data Factory (ADF) 
• Azure Synapse Analytics 
• Azure Data Lake Storage 
• Ability to design and implement pipelines in ADF. 
• Build complex efficient processes for transformation using SQL & ADF Pipelines 
• Ensure secure, organised, and reliable data pipelines 
• Troubleshoot all data quality issues 
• Your core foundation will be data analytics which lead you to becoming a data engineer 

Data Migration

• You will use Data Factory, Dedicated and serverless SQL DB's and Syanpse. 
• You will pull data from API's & other sources; you will stage and transform this data before converting to JSON and loading into the target using API endpoints.
• You will analyse all sources to understand the data (with business support).
• You will build processes to validate and highlight exceptions that sit outside any migration rules.
• You will successfully load data into target on multiple passes and process any feedback into changes necessary for a successful go live.

What we can offer

Avalere Health aims to empower every employee to develop and thrive. We empower our team with the tools, skills, and support needed to think differently and to solve healthcare’s most complex challenges.

At the center of our people-led culture is our Career Experience team, whose mission is to provide every employee with a purpose-driven career. We also pride ourselves on our personalized learning approach to ensure you receive the training you need to help you grow within the company and take advantage of our global scale and scope.

We are committed to embedding diversity and inclusion in every aspect of our organization. We encourage diversity of thought, inclusive behavior, and break down barriers to ensure every individual feels valued and encouraged to contribute their unique abilities and potential. As part of our commitment to building a healthier world, every employee is also encouraged to participate in our community engagement efforts, which support a wide range of healthcare programs and wellbeing causes worldwide.

We have city hubs across North America, Europe, and Asia, geared toward collaborating, training, socializing, and coming together as a global organization while maintaining and fully supporting flexible working practices. Our compensation and benefits package is benchmarked across the industry. We offer a generous company pension/retirement plan, private medical insurance, comprehensive employee wellbeing initiatives, compelling time-off policy, plus many other excellent employee benefits. 

We encourage all applicants to read our candidate privacy notice before applying to Avalere Health.