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 . on Twitter , Facebook , Instagram , YouTube and LinkedIn .
Job Description
Our Business Technology Solutions (BTS) team shapes the digital transformation accelerating the future of medicine at AbbVieand we do it together, asking bold questions and taking on tough challenges through deep, honest collaboration. In the role of Senior Business Intelligence & Analytics Engineer, you will join a diverse, global team that invests in your customized career growth and uses technology and data to positively impact peoples lives.
The Senior Business Intelligence & Analytics Engineer is responsible to help build, automate, and maintain enterprise BI and analytic solutions. This is an opportunity to help design, build and implement business capabilities and partner with key stakeholders across the business to drive strategic impact. As a Senior BI & Analytics Engineer you are a problem solver and genuinely like helping others solve complex problems. We are specifically seeking a candidate with knowledge and experience of designing and operationalizing BI and analytic solutions for self-service. This role is a hybrid role, 3 days in, 2 days out per week in Lake County.
Responsibilities
- Apply concepts related to BI solution delivery including database querying, data modeling, visual design concepts and code deployment to translate AbbVie business needs to design, build and deploy various Business Intelligence solutions.
- Work collaboratively with various business partners to assist in the design and implementation of analysis tools to answer business challenges
- Drive operational excellence for data ingestion, transformation and publication to ensure confidence in solutions
- Partner with business units and technology to prioritize and define data and BI development needs
- Work with business partners in different teams to identify new BI capabilities and projects
- Analyze and visualize data to present the findings and opportunities, and output solid analysis report with recommendations
- Sync your activities and share your experience with a diverse team
- Develop queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting
Qualifications
- Bachelor's degree required in technical field preferred plus 8 years experience or Masters Degree plus 7 years experience
- Proven proficiency in SQL, DAX and Power Query M language
- Proven experience and knowledge with major BI reporting tools, Power BI preferred
- Experience navigating in both relational (SQL Server, Oracle, etc.) and non-relational (Hadoop) database/data lake environments
- Demonstrated proficiency across a wide range of data technologies, including data warehousing, data integration, data visualization and analysis
- Proven experience partnering with key stakeholders in understanding business requirements to solve key strategic initiatives
- Ability to make recommendations for new metrics, strategies, and methods to improve measurement and data collection practices
- Exposure to AWS and Microsoft technologies such as Lambda, EC2, RDS, Athena, Fabric, Power Automate, etc.
- Enforces standard data architecture processes and procedures
- Full life cycle methodology including change management processes and ensuring changes are properly tested and migrated to production
- Highly motivated, self-directed, innovative and able to work independently or among teams with keen judgement, common sense and resourcefulness
- Adapts and thrives in a demanding, fast-paced environment
- Possesses a high level of critical thinking
- Operates with a high level of professionalism and integrity, including dealing with confidential information
Additional Information
Applicable only to applicants applying to a position in any location with pay disclosure requirements under state orlocal law:
The compensation range described below is the range of possible base pay compensation that the Companybelieves ingood faith it will pay for this role at the timeof this posting based on the job grade for this position.Individualcompensation paid within this range will depend on many factors including geographic location, andwemay ultimatelypay more or less than the posted range. This range may be modified in thefuture.
We offer a comprehensive package of benefits including paid time off (vacation, holidays, sick),medical/dental/visioninsurance and 401(k) to eligibleemployees.
This job is eligible to participate in our short-term incentiveprograms.
This job is eligible to participate in our long-term incentiveprograms
Note: No amount of payis considered to bewages or compensation until such amount is earned, vested, anddeterminable.The amount and availability of any bonus,commission, incentive, benefits, or any other form ofcompensation and benefitsthat are allocable to a particular employee remains in the Company's sole andabsolutediscretion unless and until paid andmay be modified at the Companys sole and absolute discretion, consistent withapplicable law.
AbbVie 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.