> Markdown version of [/jobs/ext/1027639-lead-business-intelligence-and-analytics-solution-engineer](https://www.wearedevelopers.com/jobs/ext/1027639-lead-business-intelligence-and-analytics-solution-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead Business Intelligence and Analytics Solution Engineer - **Company:** AbbVie Inc. - **Location:** Mettawa, IL, United States - **Experience:** Expert - **Salary:** $109,500.0 - **Contract:** Permanent contract - **Skills:** Sql Data Warehouse, Agile Methodology, Data Analysis, Confluence, JIRA, Code Review, Continuous Integration, Data Discovery, Data Files, Data Integration, Data Visualization, Data Warehousing, Dimensional Modeling, Python (Programming Language), Network Connections, Power BI, Tableau (Software), Virtualization Technology, Data Storage Technologies, Cloud Platform System, Sql Optimization, Snowflake, Git, Usage Tracking, Information Technology, Dataiku, Software Coding, Alteryx, Programming Languages - **Published:** June 19, 2026 - **Apply:** https://dejobs.org/x/x/F2BB6DEA53714436BE8649654CE2908A/job/ ## About the Role * Bachelor's degree in computer science or related field with 7 years of relevant experience or master's degree with 6 years of relevant experience; PhD with 2 years' experience. * Experience in requirements gathering, functional/technical documentation, stakeholder engagement, running user training sessions and building a power user business community. * Able to work with business and cross-functional teams to deliver and execute complex analytics projects. Highly autonomous and productive in accomplishing the deliverables with minimal direction. * Experience in BI and Analytics Architecture, Dimensional Modeling, Data Products, Data Visualization, Data discovery, building curated data sets, insight generation and advanced analytics. * Hands-on working experience in writing complex SQL. * Hands-on experience with BI and Data Visualization tools like Power BI, Tableau. * Hands-on experience in Snowflake (stored procs, dynamic tables). * Hands-on experience with Data Prep tools like Dataiku, dbt or Alteryx . * Hands-on experience in CI/CD (dbt, azure repo, git). * Experience in Python. ## Description 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., * 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 ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Improving quality with Agentic AI with Rovo Dev and Xray](https://www.wearedevelopers.com/videos/2005-improving-quality-with-agentic-ai-with-rovo-dev-and-xray) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Integrate your Cognitive Assistant with 3rd-party DBs and software](https://www.wearedevelopers.com/videos/249-integrate-your-cognitive-assistant-with-3rd-party-dbs-and-software) - [Collaboration Quantified: Lessons from Open Source Developer Networks](https://www.wearedevelopers.com/videos/1422-collaboration-quantified-lessons-from-open-source-developer-networks) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)