Lead Data Engineer

Job Description Are you an experienced AWS Technical Lead looking to make a remarkable impact in the field of pharmaceutical research? Join us our quest to revolutionize the healthcare industry through data-driven insights and cutting-edge technology! We are a looking for a full-time lead data engineer based out of Mettawa, IL. In this role, you will be at the forefront of engineering and operationalizing the AWS cloud infrastructure environment to support our high-performing R&D Convergence Hub platform. Leverage your expertise in AWS development, data engineering pipelines, CI/CD, containerization, Python, SQL, NoSQL, and more to drive the success of the ARCH platform.

We are a leading global pharmaceutical company dedicated to discovering and delivering innovative treatments for serious diseases. As an industry leader, we strive to empower our R&D scientists with the data and knowledge they need to maximize the impact of their life-changing work.

With flexible work arrangements and an agile, fast-paced environment, you'll have the freedom to excel both personally and professionally. Our commitment to work-life balance ensures that you can be at your best, bringing your brightest ideas to the table while still having time for the things that matter most to you. Required Skills & Experience

• Bachelor's Degree with 7+ years of experience; master’s degree with 6+ years of experience; PhD with 2+ years of experience in application program development.
• Extensive AWS development experience, including core services such as EC2, Glue, S3, Redshift, and Athena.
• Proficiency in building data engineering pipelines using tools like Apache Airflow, Glue ETL, etc.
• Strong technical proficiency in Python, SQL, and NoSQL for effective data manipulation and analysis.
• Experience with both relational and non-relational databases from a data domain perspective.
• Ability to gather technical requirements, validate architecture, and lead cross-functional teams.

Desired Skills & Experience

• Knowledge of API architecture development to enhance data accessibility and integration capabilities.
• Familiarity with Cloudera Data Platform (CDP) in an AWS cloud environment.
• Exposure to logging tools like Splunk, Elasticsearch, and AWS CloudWatch for performance monitoring.
• Hands-on experience with CI/CD and containerization, preferably using Jenkins.
• Passion for leveraging technology to unlock information, enable data-driven insights, and contribute to life-changing therapies for patients.

What You Will Be Doing Tech Breakdown

• 50% Amazon Web Services (AWS)
• 30% Data Engineering Tools (Apache Airflow, Glue ETL, etc.)
• 20% Programming Languages (Python, SQL, NoSQL)

Daily Responsibilities

• 60% Hands On
• 20% Management Duties
• 20% Team Collaboration

The Offer

• 12% bonus
• $11,500 Stock

You will receive the following benefits:

• Medical Insurance
• Dental Benefits
• Vision Benefits
• Paid Time Off (PTO)
• 401(k) {including match- if applicable}

Applicants must be currently authorized to work in the US on a full-time basis now and in the future.
#LI-MQ1