Senior Data Engineer Job at AbbVie in Mettawa

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 Come to work each day with an inclusive and collaborative Business technology team As a Senior Data Engineer in AbbVie Business Technology Solutions (BTS), youll have opportunities to contribute to the digital transformation of a leading biopharma company, helping to create solutions that impact patients and their communities for the better. This is a hybrid role based in Lake County, IL Responsibilities In this role you will be responsible for: Deep understanding on Data concepts, Data analytics, complex Data structures and Data relationships. Stay updated on industry trends and emerging technology solutions relevant to the assigned business area. Advise business stakeholders on the most appropriate and optimal approaches to achieve their objectives, which may involve technology solutions, process changes, or other options. Create and maintain system and project documentation, such as change requests, functional requirements, test plans, data migration plans, and cutover plans. Delegate relevant tasks to junior analysts as appropriate. Review data models for development projects and assist team members in understanding and adhering to established standards. Maintains relationships with affiliates, subsidiaries, and vendors in accordance with Abbvie Values, Vendor Management Office, and Purchasing to further the mission, vision and goals of the organization. Coordinate and submit ServiceNow requests for new database accounts, permissions, and collaborate with DBAs for approval. Provide documentation of technical standards and best practices, incorporating contributions from team members. Collaborate with project development teams on the SDLC (Software Development Life Cycle) and code promotion process. Review effort estimates for all activities including analysis, documentation, development, testing, bug fixing, deployment, and support. Significant Work Activities -Continuous sitting for prolonged periods (more than 2 consecutive hours in an 8 hour day) Tools and skills you will use in this role: Data Analytics SQL, PL/SQL Python Pyspark Snowflake Qualifications Required: Bachelors Degree with at least 5 years experience; Masters Degree with 4 years experience OR equivalent work experience Excellent programming skills in SQL, PL/SQL, and NoSQL. Proven experience in working with / implementing a full-scale Data Warehouse/Data Lake solution based on cloud databases such as Snowflake, Azure SQL Database, RedShift, etc. Experience interpreting data analytic outputs and performing data audits using visualization reports or dashboards such as Qlik, Tableau, Power BI, etc. Experience using one of the Data Modeling tools such as Erwin Data Modeler, DbVisualizer, Lucidchart, etc. Experience working in Unix/Linux environments. Knowledge in Python or R with at least one Data science and Machine learning framework like PyTorch, TensorFlow, Scikit-Learn is a plus. Ability to gather requirements and develop and prepare use cases, functional specifications, mapping documents for data integration, and technical requirements for data warehouse applications. Ability to work with IT and business teams to coordinate multiple IT projects in the sales planning area. Strong written and verbal communication skills. Beneficial: Experience in Microsoft PowerBI Knowledge in DevOps concepts and how code promotions are done via build pipelines. Experience with cloud computing services (AWS, Azure, or GCP) Strong understanding of the pharmaceutical industry and related data Experience working with Life Sciences Sales Planning and Sales Operations Teams. Additional Information Applicable only to applicants applying to a position in any location with pay disclosure requirements under state or local law: The compensation range described below is the range of possible base pay compensation that the Company believes ingood faith it will pay for this role at the time of this posting based on the job grade for this position. Individualcompensation paid within this range will depend on many factors including geographic location, and we may ultimatelypay more or less than the posted range. This range may be modified in the future. We offer a comprehensive package of benefits including paid time off (vacation, holidays, sick), medical/dental/visioninsurance and 401(k) to eligible employees. This job is eligible to participate in our short-term incentive programs. Note: No amount of payis considered to bewages or compensation until such amount is earned, vested, and determinable.The amount and availability of any bonus, commission, incentive, benefits, or any other form of compensation and benefitsthat are allocable to a particular employee remains in the Company's sole and absolute discretion unless and until paid andmay be modified at the Companys sole and absolute discretion, consistent with applicable law. AbbVie is an equal opportunity employer and is committed to operating with integrity, driving innovation, transforming lives, serving our community and embracing diversity and inclusion. It is AbbVies 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. 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