ETL/Data Architect

Reposted 15 Days Ago
Be an Early Applicant
Mettawa, IL, USA
Hybrid
161K-179K Annually
Mid level
Healthtech • Pharmaceutical
The Role
The ETL/Data Architect will define development standards, design ETL solutions, lead full lifecycle data projects, optimize costs, and implement operational improvements.
Summary Generated by Built In
Company Description

AbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas – immunology, oncology, neuroscience, and eye care – and products and services in our Allergan Aesthetics portfolio. For more information about AbbVie, please visit us at www.abbvie.com. Follow @abbvie on X, Facebook, Instagram, YouTube, LinkedIn and Tik Tok.

Job Description

Key Responsibilities

  • Define & enforce development standards for ETL/Data Warehousing.
  • Design, code, test, & document reusable objects using Snowflake & IICS. 
  • Lead full lifecycle Data Warehousing & integration projects from requirements to deployment. 
  • Collaborate with Data Engineering team to implement solutions aligned with business needs.
  • Optimize infrastructure & reduce Data platform costs.
  • Implement operational improvements, including processes, controls, & code reviews.

Qualifications

Education & Experience

Must have a Bachelor’s or foreign education equivalent in Engineering, Computer Science or Biotechnology, or foreign education equivalent & 4 years of experience as a data architect or in related field.

Of experience required, must have 4 years:

                        (i)         working in data integration, data warehousing, cloud-related initiatives, & development &

                                    implementation of data solutions;

                        (ii)        writing complex SQL queries;

                       (iii)        partnering with external vendors or implementation partners to optimize service delivery;

                        (iv)        working with data warehousing, data technologies, & ETL solutions; &

                        (v)        leading end-to-end data engineering & data modelling activities, including design,

                                    implementation, testing, deployment, & support; &

Of experience required, must have 3 years:

(i)         applying architecture patterns & data integration design principles;

(ii)        working in a matrix organization, balancing customer needs against organizational goals;

(iii)        identifying & recommending appropriate product/service offerings to meet functional needs;

(iv)        executing project delivery & client relationship management within a technology environment; &

(v)        preparing data visualizations using Clik & PowerBI.

Work experience may be gained concurrently.

Additional Information

Salary Range:  $160,555 - $178,500 per year

Apply online at https://careers.abbvie.com/en or send resume to [email protected]. Refer to Req ID: REF49791V

----------------------------------------------------------------------------

We offer a comprehensive package of benefits including paid time off (vacation, holidays, sick), medical/dental/vision insurance and 401(k) to eligible employees.  This job is eligible to participate in our short-term and long-term incentive programs.

AbbVie is committed to operating with integrity, driving innovation, transforming lives, serving our community, and embracing diversity and inclusion. It is AbbVie’s policy to employ qualified persons of the greatest ability without discrimination against any employee or applicant for employment because of race, color, religion, national origin, age, sex (including pregnancy), physical or mental disability, medical condition, genetic information, gender identity or expression, sexual orientation, marital status, status as a protected veteran, or any other legally protected group status.

AbbVie is an equal opportunity employer and is committed to operating with integrity, driving innovation, transforming lives and serving our community.  Equal Opportunity Employer/Veterans/Disabled. 

US & Puerto Rico only - to learn more, visit https://www.abbvie.com/join-us/equal-employment-opportunity-employer.html

US & Puerto Rico applicants seeking a reasonable accommodation, click here to learn more:

https://www.abbvie.com/join-us/reasonable-accommodations.html

Skills Required

  • Bachelor's degree in Engineering, Computer Science or Biotechnology
  • 4 years experience as a data architect or in related field
  • 4 years experience in data integration, data warehousing, and cloud initiatives
  • 4 years experience writing complex SQL queries
  • 4 years experience collaborating with vendors to optimize service delivery
  • 4 years experience in data technologies and ETL solutions
  • 4 years experience leading data engineering activities
  • 3 years experience applying architecture patterns and design principles
  • 3 years experience in matrix organizations
  • 3 years experience in project delivery and client relationship management
  • 3 years experience preparing data visualizations using Clik and PowerBI

AbbVie Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about AbbVie and has not been reviewed or approved by AbbVie.

  • Retirement Support 401(k) contributions include a dollar-for-dollar match up to 6% plus an additional annual company contribution tied to age and service. Company-paid life insurance and other financial protections further strengthen long-term security.
  • Parental & Family Support Paid leave programs include up to 12 weeks at 100% for parental leave and separate paid caregiver leave, with eligibility after six months where noted. Adoption and surrogacy reimbursements and family-building resources add further support.
  • Healthcare Strength Health coverage begins on day one with medical, dental, vision, mental health, and prescription benefits, and preventive care covered at 100%. Options such as HSAs/FSAs and coverage for spouses/domestic partners and children up to age 26 broaden accessibility.

AbbVie Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Chicago, IL
50,000 Employees
Year Founded: 2013

What We Do

AbbVie is a global biopharmaceutical company focused on creating medicines and solutions that put impact first — for patients, communities, and our world. We aim to address complex health issues and enhance people's lives through our core therapeutic areas: immunology, oncology, neuroscience, eye care, aesthetics and other areas of unmet need.

Similar Jobs

Beyond Finance Logo Beyond Finance

React Native Developer

Fintech • Financial Services
Easy Apply
Hybrid
Chicago, IL, USA
2200 Employees
120K-140K Annually

Circle Logo Circle

Director, Arc - Capital Markets Strategy & GTM

Blockchain • Fintech • Payments • Financial Services • Cryptocurrency • Web3
In-Office or Remote
25 Locations
1050 Employees
213K-273K Annually

Circle Logo Circle

Senior Director, Arc - Agentic Commerce Strategy & GTM

Blockchain • Fintech • Payments • Financial Services • Cryptocurrency • Web3
In-Office or Remote
25 Locations
1050 Employees
245K-308K Annually

Morningstar Logo Morningstar

Sales Development Representative

Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Hybrid
Chicago, IL, USA
11500 Employees
100K-500K Annually

Similar Companies Hiring

Camber Thumbnail
Fintech • Healthtech • Social Impact
New York, New York
90 Employees
Sailor Health Thumbnail
Healthtech • Social Impact • Telehealth
New York City, NY
20 Employees
Granted Thumbnail
Mobile • Insurance • Healthtech • Financial Services • Artificial Intelligence
New York, New York
23 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account