Lead Business Intelligence and Analytics Solution Engineer

{
  "content_hash": "6e9b7580ab9a60a68f1e5f8450834a978559ed1f319e290b8bbe6faf545139e3",
  "source_hash": "0c2ce685ce4d110fad0989d6d7619b826d87468d1113465e9409786cd845b053",
  "last_changed_at": "2026-06-19T10:41:02.136Z",
  "active_status": "active"
}

{
  "dedupe": null,
  "language": "en",
  "location": {
    "raw": "Mettawa, IL, United States",
    "city": "Mettawa",
    "region": "IL",
    "country": "United States",
    "is_remote": false,
    "confidence": 0.8
  },
  "salary_max": 208500,
  "salary_min": 109500,
  "inferred_at": "2026-06-22T11:43:56.294Z",
  "launch_scope": {
    "reason": "english_us_canada",
    "included": true,
    "language": "en",
    "location": {
      "raw": "Mettawa, IL, United States",
      "city": "Mettawa",
      "region": "IL",
      "country": "United States",
      "is_remote": false,
      "confidence": 0.8
    },
    "countries": [
      "United States"
    ]
  },
  "remote_policy": "hybrid",
  "salary_period": "year",
  "workplace_type": "hybrid",
  "salary_currency": "USD"
}

{}

{
  "id": "3743990013686766",
  "ref": "https://api.smartrecruiters.com/v1/companies/abbvie/postings/3743990013686766",
  "name": " Lead Business Intelligence and Analytics Solution Engineer ",
  "uuid": "a962f03b-6c8c-4021-b2ac-8f3ca169a55e",
  "detail": {
    "id": "3743990013686766",
    "name": " Lead Business Intelligence and Analytics Solution Engineer ",
    "uuid": "a962f03b-6c8c-4021-b2ac-8f3ca169a55e",
    "jobAd": {
      "sections": {
        "jobDescription": {
          "text": "<p>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.&#xa0;</p><p><strong>Responsibilities</strong></p><ul><li>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.&#xa0;</li></ul><ul><li>A successful candidate will bring analytics knowledge of best-in-class business intelligence practices, deep understanding of Data Modeling, Dimensional Modeling and Data warehouse&#xa0;</li></ul><ul><li>Help business stakeholders by providing actionable data insights, discovering trends and patterns, anomalies, outliers, and correlations to drive better business decisions&#xa0;</li></ul><ul><li>Design/Develop impactful and intuitive data visualizations to effectively communicate data findings&#xa0;</li></ul><ul><li>Develop mockups based on business requirements and curate data to scope out reporting needs&#xa0;</li></ul><ul><li>Strong knowledge of creating sematic models (involving complex logical attributes and KPI measures) adhering to metric governance standards.&#xa0;</li></ul><ul><li>Establish and follow BI and Analytics best practices including peer review, code review, documentation, coding standards, data quality and ensure reproducibility and compliance.&#xa0;</li></ul><ul><li>Serve as internal SME on BI platform and drive the self-service COE with office hours training.&#xa0;</li></ul><ul><li>Establish data and metric governance around the curated datasets and metrics, and best practices&#xa0;</li></ul><ul><li>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&#xa0;</li></ul><ul><li>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&#xa0;</li></ul><ul><li>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&#xa0;</li></ul><ul><li>Perform requirement lifecycle management, epic and story creation (Jira/Confluence), change management, functional testing, coordinating user acceptance testing and training&#xa0;</li></ul><p><strong>Tools and skills you will use in this role:&#xa0;</strong></p><ul><li>Advanced SQL&#xa0;</li></ul><ul><li>BI and Data Visualization and Data Discovery tools like Power BI, Tableau&#xa0;</li></ul><ul><li>Data Prep tools like Dataiku or similar tools like Alteryx, Tableau Data Prep&#xa0;</li></ul><ul><li>Python, or R&#xa0;</li></ul><ul><li>Cloud data warehouse Snowflake&#xa0;&#xa0;</li></ul><ul><li>JIRA, Confluence and Agile project methodology&#xa0;</li></ul>",
          "title": "Job Description"
        },
        "qualifications": {
          "text": "<ul><li>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.</li><li>Experience in requirements gathering, functional/technical documentation, stakeholder engagement, running user training sessions and building a power user business community.&#xa0;</li><li>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.&#xa0;</li><li>Experience in BI and Analytics Architecture, Dimensional Modeling, Data Products, Data Visualization, Data discovery, building curated data sets, insight generation and advanced analytics.&#xa0;</li><li>Hands-on working experience in writing complex SQL.&#xa0;</li><li>Hands-on experience with BI and Data Visualization tools like Power BI, Tableau.&#xa0;</li><li>Hands-on experience in Snowflake (stored procs, dynamic tables).&#xa0;&#xa0;</li><li>Hands-on experience with Data Prep tools like Dataiku, dbt or Alteryx&#xa0;.</li><li>Hands-on experience in CI/CD (dbt, azure repo, git).&#xa0;</li><li>Experience in Python.&#xa0;</li></ul>",
          "title": "Qualifications"
        },
        "companyDescription": {
          "text": "<p><strong>About AbbVie</strong></p><p>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 including immunology, oncology and neuroscience - and products and services in our Allergan Aesthetics portfolio. For more information about AbbVie, please visit us at&#xa0;<a href=\"http://www.abbvie.com/\" rel=\"noopener noreferrer\">www.abbvie.com</a>. Follow @abbvie on&#xa0;<a href=\"https://www.linkedin.com/company/abbvie/\" rel=\"noopener noreferrer\">LinkedIn,</a>&#xa0;<a href=\"https://www.facebook.com/AbbVieGlobal/\" rel=\"noopener noreferrer\">Facebook</a>,&#xa0;<a href=\"https://www.instagram.com/abbvie/\" rel=\"noopener noreferrer\">Instagram</a>,&#xa0;<a href=\"https://twitter.com/abbvie\" rel=\"noopener noreferrer\">X</a>&#xa0;and&#xa0;<a href=\"https://www.youtube.com/user/AbbVie\" rel=\"noopener noreferrer\">YouTube.</a></p>",
          "title": "Company Description"
        },
        "additionalInformation": {
          "text": "<p>Applicable only to applicants applying to a position in any location with pay disclosure requirements under state or&#xa0;local law:&#xa0;​</p><ul><li><p>The compensation range described below is the range of possible base pay compensation that the Company&#xa0;believes in&#xa0;good faith it will pay for this role at the time&#xa0;of this postingbased on the job grade for this position.&#xa0;Individual&#xa0;compensation paid within this range will depend on many factors including geographic location, and&#xa0;we&#xa0;may ultimately&#xa0;pay more orless than the posted range. This range may be modified in the&#xa0;future.&#xa0;​</p></li><li><p>We offer a comprehensive package of benefits including paid time off (vacation, holidays, sick),&#xa0;medical/dental/vision&#xa0;insurance and 401(k) to eligible&#xa0;employees.​</p></li><li><p>This job is eligible to participate in our short-term incentive&#xa0;programs.&#xa0;​</p></li></ul><p>Note: No amount of pay&#xa0;is considered to be&#xa0;wages or compensation until such amount is earned, vested, and&#xa0;determinable.&#xa0;The amount and availability of any bonus,&#xa0;commission,incentive, benefits, or any other form of&#xa0;compensation and benefits&#xa0;that are allocable to a particular employee remains in the Company's sole and&#xa0;absolute&#xa0;discretion unless and until paidand&#xa0;may be modified at the Company’s sole and absolute discretion, consistent with&#xa0;applicable law.&#xa0;​</p><div sr-tagline=\"\"></div><p>AbbVie is an equal opportunity employer and is committed to operating with integrity, driving innovation, transforming lives and serving our community.  Equal Opportunity Employer/Veterans/Disabled.&#xa0;</p><p>US &amp; Puerto Rico only - to learn more, visit&#xa0;<a href=\"https://www.abbvie.com/join-us/equal-employment-opportunity-employer.html\" rel=\"noopener noreferrer\">https://www.abbvie.com/join-us/equal-employment-opportunity-employer.html</a></p><p>US &amp; Puerto Rico applicants seeking a reasonable accommodation, click here to learn more:</p><p><a href=\"https://www.abbvie.com/join-us/reasonable-accommodations.html\" rel=\"noopener noreferrer\">https://www.abbvie.com/join-us/reasonable-accommodations.html</a></p>",
          "title": "Additional Information"
        }
      }
    },
    "jobId": "0c1fe1e6-1c8e-4f2f-985c-6860fd5a7c8c",
    "active": true,
    "company": {
      "name": "AbbVie",
      "identifier": "AbbVie"
    },
    "creator": {
      "name": "",
      "avatarUrl": ""
    },
    "jobAdId": "533032d3-f734-4a53-afce-f369f7227c0c",
    "applyUrl": "https://jobs.smartrecruiters.com/AbbVie/3743990013686766--lead-business-intelligence-and-analytics-solution-engineer-?oga=true",
    "function": {
      "id": "information_technology",
      "label": "Information Technology"
    },
    "industry": {
      "id": "pharmaceuticals",
      "label": "Pharmaceuticals"
    },
    "language": {
      "code": "en",
      "label": "English",
      "labelNative": "English (US)"
    },
    "location": {
      "city": "Mettawa",
      "hybrid": true,
      "region": "IL",
      "remote": false,
      "country": "us",
      "latitude": "42.2333571",
      "longitude": "-87.9259058",
      "fullLocation": "Mettawa, IL, United States"
    },
    "refNumber": "R00142809",
    "postingUrl": "https://jobs.smartrecruiters.com/AbbVie/3743990013686766--lead-business-intelligence-and-analytics-solution-engineer-",
    "visibility": "PUBLIC",
    "customField": [
      {
        "fieldId": "65806674cbfd1911c2f5d15b",
        "valueId": "15188940",
        "fieldLabel": "Hiring Manager",
        "valueLabel": "Ajith Ponnamaneni (15188940)"
      },
      {
        "fieldId": "65807663cbfd1911c2f5d15f",
        "valueId": "FUNCTION_HQIT",
        "fieldLabel": "Workday Function",
        "valueLabel": "HQIT Information Technology"
      },
      {
        "fieldId": "657cc8550d0b1f2ef38a3fc9",
        "valueId": "Mettawa",
        "fieldLabel": "City",
        "valueLabel": "Mettawa"
      },
      {
        "fieldId": "657ccabf0d0b1f2ef38a3fce",
        "valueId": "208500",
        "fieldLabel": "Segment 5 (Maximum)",
        "valueLabel": "208500"
      },
      {
        "fieldId": "657ccbce3fd51d6d84c0bc3a",
        "valueId": "COMPENSATIONGRADE_18",
        "fieldLabel": "Workday Global Grade",
        "valueLabel": "18"
      },
      {
        "fieldId": "6580668ecbfd1911c2f5d15c",
        "valueId": "Associate Director Business Intelligence EngineeringAnalytics - AA",
        "fieldLabel": "Hiring Manager Title",
        "valueLabel": "Associate Director Business Intelligence Engineering/Analytics - AA"
      },
      {
        "fieldId": "6580763744b74c1731e95352",
        "valueId": "FUNCTION_HQTR",
        "fieldLabel": "Parent Function",
        "valueLabel": "HQTR Headquarters"
      },
      {
        "fieldId": "656747e5a29e121ffd619b85",
        "valueId": "default",
        "fieldLabel": "Brands",
        "valueLabel": "AbbVie"
      },
      {
        "fieldId": "657ccad53fd51d6d84c0bc37",
        "valueId": "109500",
        "fieldLabel": "Salary Min",
        "valueLabel": "109500"
      },
      {
        "fieldId": "657ccae70d0b1f2ef38a3fcf",
        "valueId": "208500",
        "fieldLabel": "Salary Max",
        "valueLabel": "208500"
      },
      {
        "fieldId": "COUNTRY",
        "valueId": "us",
        "fieldLabel": "Country/Region",
        "valueLabel": "United States"
      },
      {
        "fieldId": "657ccc330d0b1f2ef38a3fdb",
        "valueId": "Salaried",
        "fieldLabel": "Salary/Hourly Pay Indicator",
        "valueLabel": "Salaried"
      },
      {
        "fieldId": "657cc8220d0b1f2ef38a3fc8",
        "valueId": "US",
        "fieldLabel": "Workday Country",
        "valueLabel": "United States of America"
      },
      {
        "fieldId": "657cca530d0b1f2ef38a3fcc",
        "valueId": "109500",
        "fieldLabel": "Segment 1 (Minimum)",
        "valueLabel": "109500"
      },
      {
        "fieldId": "657ccc1c0d0b1f2ef38a3fda",
        "valueId": "Job_Family_Information_Technology",
        "fieldLabel": "Workday Job Family",
        "valueLabel": "Information Technology"
      },
      {
        "fieldId": "657ccc483fd51d6d84c0bc3c",
        "valueId": "COMPENSATIONGRADE_18",
        "fieldLabel": "Posting Grade",
        "valueLabel": "18"
      }
    ],
    "referralUrl": "https://jobs.smartrecruiters.com/external-referrals/company/AbbVie/publication/a962f03b-6c8c-4021-b2ac-8f3ca169a55e?dcr_ci=AbbVie",
    "compensation": {
      "max": 208500,
      "min": 109500,
      "period": "YEARLY",
      "currency": "USD"
    },
    "defaultJobAd": true,
    "releasedDate": "2026-06-18T16:17:17.082Z",
    "experienceLevel": {
      "id": "mid_senior_level",
      "label": "Mid-Senior Level"
    },
    "typeOfEmployment": {
      "id": "permanent",
      "label": "Full-time"
    }
  },
  "company": {
    "name": "AbbVie",
    "identifier": "AbbVie"
  },
  "jobAdId": "533032d3-f734-4a53-afce-f369f7227c0c",
  "function": {
    "id": "information_technology",
    "label": "Information Technology"
  },
  "industry": {
    "id": "pharmaceuticals",
    "label": "Pharmaceuticals"
  },
  "language": {
    "code": "en",
    "label": "English",
    "labelNative": "English (US)"
  },
  "location": {
    "city": "Mettawa",
    "hybrid": true,
    "region": "IL",
    "remote": false,
    "country": "us",
    "latitude": "42.2333571",
    "longitude": "-87.9259058",
    "fullLocation": "Mettawa, IL, United States"
  },
  "refNumber": "R00142809",
  "department": {},
  "visibility": "PUBLIC",
  "customField": [
    {
      "fieldId": "65807663cbfd1911c2f5d15f",
      "valueId": "FUNCTION_HQIT",
      "fieldLabel": "Workday Function",
      "valueLabel": "HQIT Information Technology"
    },
    {
      "fieldId": "657cc8550d0b1f2ef38a3fc9",
      "valueId": "Mettawa",
      "fieldLabel": "City",
      "valueLabel": "Mettawa"
    },
    {
      "fieldId": "657ccabf0d0b1f2ef38a3fce",
      "valueId": "208500",
      "fieldLabel": "Segment 5 (Maximum)",
      "valueLabel": "208500"
    },
    {
      "fieldId": "656747e5a29e121ffd619b85",
      "valueId": "default",
      "fieldLabel": "Brands",
      "valueLabel": "AbbVie"
    },
    {
      "fieldId": "COUNTRY",
      "valueId": "us",
      "fieldLabel": "Country/Region",
      "valueLabel": "United States"
    },
    {
      "fieldId": "657cca530d0b1f2ef38a3fcc",
      "valueId": "109500",
      "fieldLabel": "Segment 1 (Minimum)",
      "valueLabel": "109500"
    },
    {
      "fieldId": "657ccc1c0d0b1f2ef38a3fda",
      "valueId": "Job_Family_Information_Technology",
      "fieldLabel": "Workday Job Family",
      "valueLabel": "Information Technology"
    },
    {
      "fieldId": "657ccc483fd51d6d84c0bc3c",
      "valueId": "COMPENSATIONGRADE_18",
      "fieldLabel": "Posting Grade",
      "valueLabel": "18"
    },
    {
      "fieldId": "65806674cbfd1911c2f5d15b",
      "valueId": "15188940",
      "fieldLabel": "Hiring Manager",
      "valueLabel": "Ajith Ponnamaneni (15188940)"
    },
    {
      "fieldId": "657ccbce3fd51d6d84c0bc3a",
      "valueId": "COMPENSATIONGRADE_18",
      "fieldLabel": "Workday Global Grade",
      "valueLabel": "18"
    },
    {
      "fieldId": "6580668ecbfd1911c2f5d15c",
      "valueId": "Associate Director Business Intelligence EngineeringAnalytics - AA",
      "fieldLabel": "Hiring Manager Title",
      "valueLabel": "Associate Director Business Intelligence Engineering/Analytics - AA"
    },
    {
      "fieldId": "6580763744b74c1731e95352",
      "valueId": "FUNCTION_HQTR",
      "fieldLabel": "Parent Function",
      "valueLabel": "HQTR Headquarters"
    },
    {
      "fieldId": "657ccad53fd51d6d84c0bc37",
      "valueId": "109500",
      "fieldLabel": "Salary Min",
      "valueLabel": "109500"
    },
    {
      "fieldId": "657ccae70d0b1f2ef38a3fcf",
      "valueId": "208500",
      "fieldLabel": "Salary Max",
      "valueLabel": "208500"
    },
    {
      "fieldId": "657ccc330d0b1f2ef38a3fdb",
      "valueId": "Salaried",
      "fieldLabel": "Salary/Hourly Pay Indicator",
      "valueLabel": "Salaried"
    },
    {
      "fieldId": "657cc8220d0b1f2ef38a3fc8",
      "valueId": "US",
      "fieldLabel": "Workday Country",
      "valueLabel": "United States of America"
    }
  ],
  "defaultJobAd": true,
  "releasedDate": "2026-06-18T16:17:17.082Z",
  "detail_errors": [],
  "experienceLevel": {
    "id": "mid_senior_level",
    "label": "Mid-Senior Level"
  },
  "typeOfEmployment": {
    "id": "permanent",
    "label": "Full-time"
  }
}