Lead Business Intelligence and Analytics Solution Engineer
AbbVie
4 hours ago
On-site
Mettawa, IL
IT
Responsibilities:
- Foster strong relationships with key business stakeholders and clients; work with business and cross-functional teams to deliver complex analytics projects.
- Apply best-in-class business intelligence practices; deep understanding of Data Modeling, Dimensional Modeling, and data warehouse.
- Provide actionable data insights by identifying trends, patterns, anomalies, outliers, and correlations to drive better business decisions.
- Design/develop impactful, intuitive data visualizations.
- Develop mockups based on business requirements; curate data to scope reporting needs.
- Create semantic models with logical attributes and KPI measures, adhering to metric governance standards.
- Establish and follow BI/Analytics best practices (peer review, code review, documentation, coding standards, data quality, reproducibility, compliance).
- Serve as internal SME for BI platform and drive self-service COE with office hours training.
- Establish data and metric governance for curated datasets and metrics.
- Conceive, design, engineer, and implement technology solutions; resolve project hurdles and assumptions.
- Demonstrate proficiency across data integration, data warehousing, data analysis/visualization, storage, network connectivity, and virtualization/cloud environments.
- Mentor junior resources; architect BI solutions; manage/prioritize multiple projects.
- Perform requirement lifecycle management: epic/story creation (Jira/Confluence), change management, functional testing, UAT coordination, and training.
Tools/Skills:
- Advanced SQL; Power BI; Tableau; Dataiku/Alteryx/Tableau Data Prep; Python or R; Snowflake; JIRA; Confluence; Agile.
Qualifications:
- BS in computer science or related field with 7 years’ relevant experience, or MS with 6 years, or PhD with 2 years.
- Experience with requirements gathering, technical/functional documentation, stakeholder engagement, user training, and building power-user community.
- Experience in BI/Analytics architecture, dimensional modeling, data products, data visualization, data discovery, curated datasets, insight generation, and advanced analytics.
- Hands-on: complex SQL; Power BI/Tableau; Snowflake (stored procs, dynamic tables); data prep tools (Dataiku/dbt/Alteryx); CI/CD (dbt, Azure repo, Git); Python.
Benefits (as stated):
- Paid time off (vacation, holidays, sick); medical/dental/vision insurance; 401(k) to eligible employees; eligibility for short-term incentive programs.
- Foster strong relationships with key business stakeholders and clients; work with business and cross-functional teams to deliver complex analytics projects.
- Apply best-in-class business intelligence practices; deep understanding of Data Modeling, Dimensional Modeling, and data warehouse.
- Provide actionable data insights by identifying trends, patterns, anomalies, outliers, and correlations to drive better business decisions.
- Design/develop impactful, intuitive data visualizations.
- Develop mockups based on business requirements; curate data to scope reporting needs.
- Create semantic models with logical attributes and KPI measures, adhering to metric governance standards.
- Establish and follow BI/Analytics best practices (peer review, code review, documentation, coding standards, data quality, reproducibility, compliance).
- Serve as internal SME for BI platform and drive self-service COE with office hours training.
- Establish data and metric governance for curated datasets and metrics.
- Conceive, design, engineer, and implement technology solutions; resolve project hurdles and assumptions.
- Demonstrate proficiency across data integration, data warehousing, data analysis/visualization, storage, network connectivity, and virtualization/cloud environments.
- Mentor junior resources; architect BI solutions; manage/prioritize multiple projects.
- Perform requirement lifecycle management: epic/story creation (Jira/Confluence), change management, functional testing, UAT coordination, and training.
Tools/Skills:
- Advanced SQL; Power BI; Tableau; Dataiku/Alteryx/Tableau Data Prep; Python or R; Snowflake; JIRA; Confluence; Agile.
Qualifications:
- BS in computer science or related field with 7 years’ relevant experience, or MS with 6 years, or PhD with 2 years.
- Experience with requirements gathering, technical/functional documentation, stakeholder engagement, user training, and building power-user community.
- Experience in BI/Analytics architecture, dimensional modeling, data products, data visualization, data discovery, curated datasets, insight generation, and advanced analytics.
- Hands-on: complex SQL; Power BI/Tableau; Snowflake (stored procs, dynamic tables); data prep tools (Dataiku/dbt/Alteryx); CI/CD (dbt, Azure repo, Git); Python.
Benefits (as stated):
- Paid time off (vacation, holidays, sick); medical/dental/vision insurance; 401(k) to eligible employees; eligibility for short-term incentive programs.