Come to work each day with an inclusive and collaborative business technology team. As a Senior Business Intelligence and Analytics Engineer in AbbVie Business Technology Solutions (BTS), you’ll 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. 

Responsibilities

• Foster strong relationships with key business stakeholders and clients with strong interpersonal communication and able to work with business and cross-functional teams to deliver and execute complex analytics projects. 

• A successful candidate will bring analytics knowledge of best-in-class business intelligence practices, deep understanding of Data Modeling, Dimensional Modeling and Data warehouse 

• Help business stakeholders by providing actionable data insights, discovering trends and patterns, anomalies, outliers, and correlations to drive better business decisions 

• Design/Develop impactful and intuitive data visualizations to effectively communicate data findings 

• Develop mockups based on business requirements and curate data to scope out reporting needs 

• 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 

• Conceive, design, engineer, and implement technology solutions by studying information needs; conferring with users; studying systems flow, data usage, and work processes; investigating problem areas; Demonstrate the ability to resolve key project hurdles and assumptions by effectively utilizing available information and technical expertise 

• Demonstrate high proficiency across a wide range of technologies and platforms related to design and development, programming languages, data integration, data warehousing, data analysis and visualization tools, data storage, network connectivity, and virtualization/cloud environments 

• As lead engineer, mentor and guide junior resources in architecting BI solutions and manage and prioritize multiple projects to meet priorities with efficient time management 

• Perform requirement lifecycle management, epic and story creation (Jira/Confluence), change management, functional testing, coordinating user acceptance testing and training 

Tools and skills you will use in this role: 

• Advanced SQL 

• BI and Data Visualization and Data Discovery tools like Power BI, Tableau 

• Data Prep tools like Dataiku or similar tools like Alteryx, Tableau Data Prep 

• Python, or R 

• Cloud data warehouse Snowflake  

• JIRA, Confluence and Agile project methodology