ETL/Data Architect
__jobinformationwidget.freetext.LocationText__
Mettawa, IL
- Commercial
- Hybrid
- Full-time
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.
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.
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.
Salary Range: $160,555 - $178,500 per year
Apply online at https://careers.abbvie.com/en or send resume to Job.opportunity.abbvie@abbvie.com. 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
We have recently become aware of various recruitment phishing scams targeting job seekers. Please be advised:
- AbbVie will never request sensitive personal information (such as bank account details, social security numbers, or payment of any kind) during the recruitment process.
- If you suspect you have received a fraudulent offer or communication claiming to be from AbbVie, please do not respond, open any attachments, or click on any hyperlinks.
If you have any questions or concerns regarding the authenticity of a communication alleged to have been made by or on behalf of AbbVie, please contact us immediately.
Protect yourself by verifying job offers and communications. Your safety is important to us.
Pay Range: $
0 - 0 USD
Where We Work
Role is primarily site- or office-based but can occasionally be performed remotely. Employees who are site/office-based and can occasionally perform their role virtually work both in the office and remotely*, following the policies and regulations in place at their location. US Employees must be in the office on Tuesday, Wednesday, and Thursday with flexibility to work remotely on Mondays and Fridays. Three days in the office is the minimum; some individuals or teams may require more in-office days due to meetings, business/project needs or their role.