Job Information
AbbVie Business Intelligence Engineer in North Chicago, Illinois
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 Twitter, Facebook, Instagram, YouTube and LinkedIn.
Job Description
Key Responsibilities
Work with business requirements to identify and understand source data systems.
Provide resolutions to all data issues and coordinate with data analyst to validate all requirements.
Develop and perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications using SQL.
Utilize experience in Snowflake, SQL, and AWS infrastructure.
Design, develop, and debug new business intelligence tools to solve complex engineering challenges in a dynamic environment.
Utilize experience in ETL and/or other data manipulation languages such as Python, SAS, and R.
Adapt ETL processes to accommodate changes in source systems and new business user requirements.
Provide application analysis and data modeling design to collect data for centralized data warehouse.
Ensure high levels of business Intelligence availability through support functions and in-depth testing.
Responsible for properly following all IT standards, processes, and methodologies as applicable including but not limited to Quality Assurance (QA).
Collaborate with customers and stakeholders as well as other members of IT.
Work with Data tools like AWS Lambda, Step Functions, CloudWatch, Eventbridge and Snowflake to deliver Data products.
Architect and design the implementation plan for delivering the Data Products across Finance, Data Science etc.
Connect data sets to data visualization tools and create reports using Tableau and Power BI.
Cross Collaborate with different teams in the organization
Qualifications
Must possess a Bachelor’s degree or foreign academic equivalent in Computer Science, Data Engineering, or a highly related field of study with at least 3 years of related experience in:
working with Data tools like AWS Lambda, Step Functions, CloudWatch, Eventbridge and Snowflake to deliver Data products;
experience in SQL and AWS infrastructure;
experience in ETL and other data manipulation languages such as Python, SAS, and R;
connecting data sets to data visualization tools and creating reports using Tableau and Power BI.
100% telecommuting permitted.
Salary Range: $140,400 - $157,500 per year.
Apply online at https://careers.abbvie.com/en. Refer to Req ID: REF24720Y.
Additional Information
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.