Senior Business Intelligence And Analytics Engineer

Summary

Join AbbVie's Business Technology Solutions (BTS) team as a Senior Business Intelligence and Analytics Engineer and contribute to the digital transformation of a leading biopharma company. You will leverage your analytics expertise to provide impactful data insights, design intuitive data visualizations, and develop curated datasets using tools like Dataiku or Alteryx. This role requires collaboration with business stakeholders and cross-functional teams to solve complex analytics problems. You will also be responsible for establishing BI and analytics best practices, managing multiple tasks, and fostering strong stakeholder relationships. The ideal candidate possesses a Bachelor's or Master's degree in a related field with significant experience in BI, data visualization, SQL, and cloud data warehouses. AbbVie offers a comprehensive benefits package.

Requirements

• Bachelor’s degree in computer science or related field with 6 + years of relevant experience or master’s degree with 5+ years of relevant experience
• 4+ years of experience in BI and Analytics, Data Visualization, Data discovery, building curated data sets, insight generation and advanced analytics
• 5+ years of hands-on working experience in writing complex SQL
• 4 + years of hands-on experience with BI and Data Visualization tools like Power BI
• 3+ years of hands-on experience with Data Prep tools like Alteryx
• 3+ years of hands-on experience in cloud data warehouse, data lake like Snowflake
• Experience in Python
• Experience in running user training sessions and building a power user business community
• Excellent oral and written communication skills, analytical skills, and stakeholder engagement

Responsibilities

• Help business stakeholders by providing impactful data insights, discovering trends and patterns, anomalies, outliers, correlations to drive better business decisions
• Design/Develop impactful and intuitive data visualizations to effectively communicate data findings to both technical and non-technical audiences
• Ability to work with business and cross functional teams to deliver and execute complex analytics problems
• Develop curated datasets using Dataiku or similar tools like Alteryx, Tableau Data Prep per business use cases and facilitate self-service analytics
• Strong knowledge of creating sematic models (involving complex logical attributes and KPI measures) adhering to metric governance standards
• Establish and follow BI and Analytics best practices including peer review, code review, documentation, coding standards, data quality and ensure reproducibility and compliance
• Serve as internal SME on BI platform and drive the self-service COE with office hours training
• Establish data and metric governance around the curated datasets and metrics, and best practices on taxonomy, and other
• Manage and prioritize multiple tasks to meet deadlines with efficient time management
• Foster strong relationships with key business stakeholders and clients with strong interpersonal communication
• Develop and deliver highly impactful and creative presentations
• Perform requirement lifecycle management, epic and story creation (Jira/Confluence), change management, functional testing, coordinating user acceptance testing and training
• Expand BI and Analytics skillset through research, continuous learning, and development opportunities

Preferred Qualifications

• Experience with Life Sciences Commercial Pharma including insights into Sales Operations, marketing is a plus
• Consulting experience in Business Intelligence and Analytics domain

Benefits

• Paid time off (vacation, holidays, sick)
• Medical/dental/vision insurance
• 401(k)
• Short-term incentive programs