Abbott

Compensation

Full Description

Work options: Remote Title: Project Manager II - Senior Business Intelligence (Power BI) Developer Location: Abbott Park, IL (Remote) Duration: 12 Month Assignment Job Summary • We are seeking a Senior Business Intelligence (Power BI) Developer to lead end-to-end data modeling, visualization, and analytics solutions across Microsoft Fabric/Azure Analytics. • You will own complex semantic models, optimize DAX, engineer performant T?SQL data marts, and establish Power BI governance and best practices. • This role partners closely with product, engineering, and business stakeholders to translate requirements into reliable, scalable, and insightful BI products that drive decision-making. Key Responsibilities • Design, build, and maintain enterprise-grade Power BI datasets, semantic models, and reports using star/snowflake schemas and robust DAX patterns. • Utilize performant T-SQL data pipelines, views, and stored procedures for curated data marts and dimensional models (SCD handling, surrogate keys, conformed dimensions). • Leverage Microsoft Fabric (OneLake, Lakehouse, Data Warehouse) and Azure Analytics services (Synapse, Data Factory/Azure Data Factory, Databricks) to orchestrate data ingestion, transformation, and governance. • Implement row-level and object-level security (RLS/OLS), certified datasets, and workspace governance aligned to data security and compliance standards. Own Performance Optimization • measure and tune DAX queries, model relationships, aggregations, incremental refresh, and DirectQuery/Composite models. • Utilize standards and CI/CD practices for BI assets (e.g., deployment pipelines, parameterization, versioning) preferably via Azure DevOps/Git integration. • Collaborate with stakeholders to elicit requirements, define success metrics, and deliver clear, actionable insights; present findings to executive and non-technical audiences. • Document data lineage, semantic definitions, and KPIs; maintain a robust data catalog and usage guidelines. • Support production operations: monitor refreshes, troubleshoot model/report issues, and drive continuous improvement across the BI estate. Required Qualifications • Expert-level Power BI, including DAX (calculated columns/measures), Tabular modeling, relationships, hierarchies, calculation groups, and advanced filtering techniques. • Strong data warehousing with Microsoft SQL Server/T?SQL: dimensional modeling, performance tuning, indexing strategies, and ETL/ELT patterns. • Hands-on experience with Microsoft Fabric and/or Azure Analytics (Synapse, Data Factory/Azure Data Factory, Databricks) for scalable data engineering. • Proven rigor and thoroughness: disciplined testing, validation, and documentation; ability to enforce standards and maintain data quality. • Fluent communicator: able to translate business needs into technical designs and explain complex concepts clearly to diverse audiences. • 7+ years in BI/Analytics engineering with a track record of delivering enterprise BI solutions at scale. Preferred Qualifications • Experience with Azure DevOps/Git for source control, branching strategies, and CI/CD of BI assets (deployment pipelines, YAML). • Exposure to Salesforce data models and/or Customer Data Analytics (CDP) for integrating CRM metrics and customer 360 analytics. • Power BI Administration (tenant settings, capacity management, monitoring, usage analytics). • Performance tuning with aggregation tables, composite models, calculation groups, and query caching. • Data governance, cataloging, and metadata management using Purview or similar tools. • Bachelor's/master's in computer science, Information Systems, or related field (or equivalent experience). Core Competencies Competency What Good Looks Like Fluent Communicator Produces concise artifacts, clearly articulates trade-offs, tailors messaging to executives and practitioners, facilitates decision-making. • High Rigor Applies disciplined testing/validation, peer reviews, reproducible pipelines, and auditability; adheres to standards and enforces governance. • Thoroughness Consider lineage/definitions and edge cases; anticipates downstream impacts; closes gaps before production. • Tools & Technologies Power BI Desktop, Power BI Service, Tabular Editor (optional), DAX Studio Microsoft SQL Server, Azure SQL, Fabric Data Warehouse/Lakehouse, OneLake • Familiar with: Azure Synapse Analytics, Azure Data Factory (or Microsoft Fabric pipelines), Databricks Azure DevOps/Git, Deployment Pipelines, CI/CD • Purview/Lineage, Monitoring/Usage Analytics Utilize CI/CD for BI assets with automated validation and rollback; 1% failed deployments per quarter. • Work Model & Location Primary location: Remote. Occasional travel for workshops and stakeholder engagement (up to 10%). • Hard Skills: 1. Microsoft Power BI (DAX, Data Modeling) 2. Microsoft Data Warehousing (T-SQL) 3. Microsoft Fabric / Azure Analytics Soft Skills: 1. Fluent Communicator 2. High Rigor 3. Thoroughness Consultants Eligible Benefits Upon Waiting Period • Medical and Prescription Drug Plans • Dental Plan • Vision Plan • Health Savings Account (for High-Deductible Health Plans) • Flexible Spending Accounts (Health, Limited Purpose, Dependent Care, Commuter Parking and Commuter Transit) • Supplemental Life Insurance • Short Term Disability (coverage varies by state) • Long Term Disability • Critical Illness, Hospital coverage, Accident Insurance • MetLife Legal, MetLife ID Fraud, and MetLife Pet Insurance • 401(k) Abbott is a global healthcare leader that helps people live more fully at all stages of life. Our portfolio of life-changing technologies spans the spectrum of healthcare, with leading businesses and products in diagnostics, medical devices, nutritional and branded generic medicines. Working together, Abbott and Talent Solutions partner to deliver top talent for contingent roles at Abbott, building better and healthier lives. Abbott believes all employees are essential to creating life-changing breakthroughs, performing key duties to create life-changing breakthroughs.