JOB DESCRIPTION
Abbott is a global healthcare leader that helps people live more fully at all stages of life. Our portfolio of life-changing technologies spans the spectrum of healthcare, with leading businesses and products in diagnostics, medical devices, nutritionals and branded generic medicines. Our 115,000 colleagues serve people in more than 160 countries.
WORKING AT ABBOTT
At Abbott, you can do work that matters, grow, and learn, care for yourself and family, be your true self and live a full life. You’ll also have access to:
Career development with an international company where you can grow the career you dream of.
Free medical coverage for employees* via the Health Investment Plan (HIP) PPO
An excellent retirement savings plan with high employer contribution
Tuition reimbursement, the Freedom 2 Save student debt program and FreeU education benefit - an affordable and convenient path to getting a bachelor’s degree.
A company recognized as a great place to work in dozens of countries around the world and named one of the most admired companies in the world by Fortune.
A company that is recognized as one of the best big companies to work for as well as a best place to work for diversity, working mothers, female executives, and scientists.
THE OPPORTUNITY
This position will work out of one of our two offices in the office of either site: LAKE FOREST J55 IN IL OR ST. PAUL IN MN within the BI & DA organization.
The SR. DATA ENGINEER is responsible for designing, building, and maintaining pipelines and reusable components to support reporting and analytics data products. This position will be responsible for partnering with team members to implement the best technical solution with performance, governance, scalability, security, and maintainability in mind. The person hired in this role will also have the opportunity to participate in solution architecture with senior IT staff.
WHAT YOU’LL WORK ON
If you enjoy organizing raw data, then this is a great job for you! The data that this team sees and organize in data bricks will then go to multiple groups in the company. This team has high exposure to projects companywide and worldwide at Abbott. If making a difference with data extraction and loading the data using Azure Cloud is your “superpower”, then please apply!
WHAT YOUR RESPONSIBILITIES WOULD BE IF HIRED:
Create and maintain an optimal data pipeline architecture by assisting with the designing and implementation of data ingestion solutions on Azure using DataBricks and/or Datafactory.
Writing complex queries to transform raw data sources into accessible models.
Clean, prepare, transform, and optimize data at scale.
Assist with designing and optimizing data models on Azure cloud using Azure Analysis Services.
Read, extract, transform, stage and load data to selected tools and frameworks as required and requested.
Ensure your work remains backed-up and readily accessible to relevant co-workers using GIT or Azure Cloud for Doc Control or (other programs the team uses for this purpose).
Providing system support to end users and administrators to resolve business and technical problems. Including possible rotation on call on a third tier level on occasion at most.
Using/improving existing standards, methodologies, and processes and understanding other systems/business processes related to each other. In addition, you will understand SDLC in Waterfall or Agile methodologies in your current or past roles.
Working with CI/CD and version control tools such as GIT.
You will have knowledge of working with healthcare data for HIPPA Privacy and International Data Privacy Agreement Laws.
Competencies:
Strong problem-solving skills, attention to detail and organization / documentation skills
Ability to prioritize and triage deadline-driven tasks in a high-pressure environment.
REQUIRED:
Bachelor’s degree (± 16 years) in any of the following – Math, Physics, Computer Science, Statistics, Economics, Quantitative Sciences.
Minimum 7 years of experience in IT as a Data Engineer
At least one year of experience with developing ETL pipelines in one or more of the following tools: Azure Data Factory, Azure functions, Data Flow, Event hubs, Event grids, Informatica
At least one year of experience with Databricks and/or Spark
At least two years of experience with SQL and data modeling
At least two years of experience with Python and some ETL libraries like Pandas.
PREFERRED:
* Participants who complete a short wellness assessment qualify for FREE coverage in our HIP PPO medical plan. Free coverage applies in the next calendar year.
LEARN MORE ABOUT OUR HEALTH AND WELLNESS BENEFITS, WHICH PROVIDE THE SECURITY TO HELP YOU AND YOUR FAMILY LIVE FULL LIVES: www.abbottbenefits.com
Follow your career aspirations to Abbott for diverse opportunities with a company that can help you build your future and live your best life. Abbott is an Equal Opportunity Employer, committed to employee diversity.
Connect with us at www.abbott.com, on Facebook at www.facebook.com/Abbott and on Twitter @AbbottNews and @AbbottGlobal.
The base pay for this position is $80,700.00 – $161,300.00. In specific locations, the pay range may vary from the range posted.