Data Engineer Lead

Job Description

This is a remote position.

About the Client:

They understand your pain. In fact, theyve been there. It's the very reason they built the industry's first automated data analytics and reporting platform for pharmacy benefit organizations.

After spending more than 30 years building manual reports for Payers, PBMs, TPAs, Consultants, and Brokers, we created a game changing platform that autonomously compiles complete analyses, builds reports, and identifies specific client opportunities you can act on in a matter of minutes - not months. No more missed deadlines and questionable results. No more suffering with lengthy, risky methods.

Job Summary:

We are looking for a talented and experienced Data Engineer Lead to join our team, specializing in the US Pharmacy Benefit Management sector. As a Data Engineer Lead, you will play a key role in designing, building, and optimizing data pipelines and infrastructure within the AWS ecosystem. You will help lead and mentor a team of engineers and analysts, ensuring the successful delivery of data solutions while leveraging your expertise in Python, SQL, Snowflake, and AWS technologies.

Responsibilities:

• Collaborate with stakeholders to understand data requirements and translate them into technical specifications and system architectures.
  
• Design and implement robust ETL processes to ingest, transform, and load data from various sources into the Snowflake data warehouse using Python and SQL.
  
• Optimize data pipelines for performance, reliability, and scalability, leveraging cloud-native services within the AWS ecosystem, such as AWS ECS and S3.
  
• Ensure data quality and integrity throughout the data lifecycle by implementing data validation and quality control mechanisms.
  
• Mentor and coach team members, providing technical guidance, best practices, and fostering a culture of collaboration and continuous learning.
  
• Collaborate with cross-functional teams, including data analysts, software engineers, and business stakeholders, to support data-driven decision-making and deliver actionable insights.
  

Requirements

• Proven experience as a Data Engineer, with at least 5 years of experience in building and maintaining data pipelines and infrastructure.
  
• Strong proficiency in Python for scripting and automation, as well as SQL for data manipulation and querying.
  
• Experience working with Snowflake or similar cloud-based data warehousing platforms.
  
• Previous experience leading a team of data engineers, with a track record of successful project delivery and team collaboration.
  
• Strong problem-solving skills and ability to troubleshoot complex data issues in a distributed environment.
  
• Excellent communication and interpersonal skills, with the ability to effectively communicate technical concepts to both technical and non-technical stakeholders, including those in the US.
  
• Must have Fiber Optic internet with at least 25 Mbps bandwidth
  
• Must have a backup desktop or laptop with the latest OS
  
• Must be able to work followingMountain time (during Probationary) / PH Hours (after Regularization)
  

Benefits

WHAT WE OFFER:

✔ Great Place to Work-Certified Company

✔ Premium HMO

✔ Holistic employee experience

✔ Work-from-home and hybrid work setup

✔ Rewards and incentives

✔ Monthly engagement activities

✔ Career advancement opportunities

✔ Paid referral program