Data Engineer, Avalere Health
Global healthcare communications agency
Be an early applicant
Global healthcare communications agency
1001+ employees
Be an early applicant
1001+ employees
Company mission
To imagine new possibilities for a healthier world and create the connections that make better health happen.
Role
Who you are
- 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
What the job involves
- As an Azure Data Engineer, your role involves designing, implementing, and managing data solutions on the Microsoft Azure cloud platform
- 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
- 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
- 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
- Keep honing your skills, as the demand for Microsoft Certified Data Engineers continues to grow!
- 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
- 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
Our take
Avalere Health, founded in 2001 and formerly known as Fishawack, has built a strong reputation as a leading provider of cross-border strategy consultation, communications, and marketing expertise for companies in the biopharmaceutical, medical technology, and wellness industries.
Though the company doesn’t make its exact customer list public knowledge, it does claim to serve all of the top 20 pharmaceutical companies in the world, as well as a number of breakout biotech and medtech enterprises. In the over two decades since its founding, it has acquired and merged 19 healthcare firms worldwide - including Avalere Health from which it takes its new name.
Given that it’s grown from one location in the UK to encompass teams across the US, Europe, and Asia, the company appears to operate from a position of serious strength in this trillion-dollar space. Recently, it seems Avalere has focussed on building out its leadership team as it embraces its new branding and manifesto.
Steph
Company Specialist at Welcome to the Jungle
Insights
Company
Company benefits
- The tools, skills, and support you need to think differently and to solve healthcare’s most complex challenges
- Career Experience team, whose mission is to provide every employee with a purpose-driven career
- Personalized learning and training
- Hubs across North America, Europe, and Asia, geared toward collaborating, training, socializing, and coming together as a global organization
- Flexible working practices
- Company pension/retirement plan
- Private medical insurance
- Employee wellbeing initiatives
- Compelling time-off policy
Company values
- We act with integrity - We are honest and straightforward in all our interactions and relationships
- We are authentic - We show up to work as our true selves and communicate openly with our colleagues
- We value difference - We treat everyone with empathy and humility, fostering a culture that is equitable, diverse, and inclusive
- We play for the team - Together we achieve so much more
- We enjoy the journey - We are inspired by our team, our work and the opportunity to be a part of creating a healthier world
Company HQ
Knutsford, UK
Articles
Leadership
Jon Koch
(CEO, not founder)Was hired as CEO in 2021 after spending three years as SVP and CEO of the Global Dental Group at Henry Schein. Prior to this they spent more than 11 years in General Management, VP, and Group President roles at pharmaceuticals company Covance (now Labcorp Drug Development).
Diversity, Equity & Inclusion at Avalere Health
- 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
Share this job
View 4 more jobs at Avalere Health