ETL​/Data Architect

Company Description

Abb Vie'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 Abb Vie, please visit us  Follow @abbvie onX,Facebook,Instagram,You Tube,Linked Inand Tik  Tok.

• 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.

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:

• working in data integration, data warehousing, cloud-related initiatives, and development & implementation of data solutions;
• writing complex SQL queries;
• partnering with external vendors or implementation partners to optimize service delivery;
• working with data warehousing, data technologies, & ETL solutions;
• leading end-to-end data engineering & data modelling activities, including design, implementation, testing, deployment, & support;

Of experience required, must have 3 years:

• applying architecture patterns & data integration design principles;
• working in a matrix organization, balancing customer needs against organizational goals;
• identifying & recommending appropriate product/service offerings to meet functional needs;
• executing project delivery & client relationship management within a technology environment;
• preparing data visualizations using Clik & PowerBI.

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

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.

Abb Vie is committed to operating with integrity, driving innovation, transforming lives, serving our community, and embracing diversity and inclusion. It is Abb Vie’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.

Abb Vie 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

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

Our work can—and does—have a tangible, lasting impact on millions of people. But it’s not just the results that matter. How we achieve them matters, too. Leading with purpose, we work to build a more sustainable future for generations to come. We do that by putting our expertise, resources and talent to work to make a real difference for patients, communities and our world.