Data Engineer II

Company Information 

At Advarra, we are passionate about making a difference in the world of clinical research and advancing human health. With a rich history rooted in ethical review services combined with innovative technology solutions and deep industry expertise, we are at the forefront of industry change. A market leader and pioneer, Advarra breaks the silos that impede clinical research, aligning patients, sites, sponsors, and CROs in a connected ecosystem to accelerate trials.

Company Culture  

Our employees are the heart of Advarra. They are the key to our success and the driving force behind our mission and vision. Our values (Patient-Centric, Ethical, Quality Focused, Collaborative) guide our actions and decisions. Knowing the impact of our work on trial participants and patients, we act with urgency and purpose to advance clinical research so that people can live happier, healthier lives.  

At Advarra, we seek to foster an inclusive and collaborative environment where everyone is treated with respect and diverse perspectives are embraced. Treating one another, our clients, and clinical trial participants with empathy and care are key tenets of our culture at Advarra; we are committed to creating a workplace where each employee is not only valued but empowered to thrive and make a meaningful impact.  

Job Duties & Responsibilities    

• Design, develop, and maintain data pipelines and ETL processes to ingest, transform, and load data from various sources into data cloud platform 
• Implement and optimize batch and real-time data processing workflows 
• Design and develop scalable data models and schemas, ensuring they are optimized for performance and meet business requirements. 
• Implement data warehousing solutions using Snowflake Platform 
• Build and manage data pipeline using Fivetran to ingest large volumes of data from both internal applications and external data sources. 
• Implement and maintain data security measures, including access controls and data encryption, to ensure compliance with data privacy regulations and organizational policies. 
• Assess the costs associated with operating the data platform and offer recommendations for data platform licensing expenses. 
• Responsible for safeguarding confidential information. 

 Location   

This role is open to candidates working in Bengaluru, Ind (hybrid).  

Basic Qualifications   

• Bachelor's degree in computer science, Data Science, Information Technology, Engineering, or a related field. Snowflake certification plus. 
• 3-5 years of experience in data engineering, data warehousing, or a related field 
• Data Transformation: Hands-on experience using tools like dbt (Data Build Tool) for building and managing data transformation pipelines. 
• Demonstrated proficiency in writing and optimizing complex SQL queries, stored procedures, and data transformations on Snowflake platform. 
• Experience with data integration tools such as Fivetran, including configuring, managing, and troubleshooting data ingestion processes. 
• Experience with cloud-based data platforms such as Snowflake, Redshift, BigQuery, or Azure Synapse, including designing and optimizing data models and managing data structures. 

 Preferred Qualifications   

• Working experience with version control platforms, e.g. GitHub, and agile methodologies and supporting tools JIRA. 
• Experience with AWS and cloud technologies a plus. 

Physical and Mental Requirements  

• Sit or stand for extended periods of time at stationary workstation 
• Regularly carry, raise, and lower objects of up to 10 Lbs.  
• Learn and comprehend basic instructions 
• Focus and attention to tasks and responsibilities 
• Verbal communication; listening and understanding, responding, and speaking  

Advarra is an equal opportunity employer that is committed to diversity, equity and inclusion and providing a workplace that is free from discrimination and harassment of any kind based on race, color, religion, creed, sex (including pregnancy, childbirth, and related medical conditions, sexual orientation, and gender identity), national origin, age, disability or genetic information or any other status or characteristic protected by central, state, or local law.  Advarra provides equal employment opportunity to all individuals regardless of these protected characteristics. Further, Advarra takes affirmative action to ensure that applicants and employees are treated without regard to any of these protected characteristics in all terms and conditions of employment, including, but not limited to, hiring, training, promotion, discipline, compensation, benefits, and separation from employment.