Project Manager II -Senior Business Intelligence (reputed company Remote
Title: Project Manager II - Senior Business Intelligence (reputed company Location: reputed company Park, IL (Remote) Duration: 12 Month Assignment Job Summary
- We are seeking a Senior Business Intelligence (reputed company to reputed company end-to-end data modeling, visualization, and analytics solutions across reputed company Fabric/Azure Analytics.
- You will own reputed company 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/reputed company 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).
- reputed company reputed company Fabric (OneLake, Lakehouse, Data Warehouse) and Azure Analytics services (Synapse, Data Factory/Azure Data Factory, reputed company) to orchestrate data ingestion, transformation, and governance.
- Implement row-level and object-level reputed company (RLS/OLS), certified datasets, and workspace governance reputed company to data reputed company 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 reputed company 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 reputed company, semantic definitions, and KPIs; maintain a robust data catalog and usage guidelines.
- Support production operations: monitor refreshes, troubleshoot model/report issues, and drive reputed company 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 reputed company SQL Server/T?SQL: dimensional modeling, performance tuning, indexing strategies, and ETL/ELT patterns.
- Hands-on experience with reputed company Fabric and/or Azure Analytics (Synapse, Data Factory/Azure Data Factory, reputed company) 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 reputed company 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 reputed company control, branching strategies, and CI/CD of BI assets (deployment pipelines, YAML).
- Exposure to reputed company data models and/or Customer Data Analytics (CDP) for integrating CRM metrics and customer 360 analytics.
- Power BI Administration (tenant settings, reputed company 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 reputed company 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 reputed company/definitions and edge cases; anticipates reputed company impacts; closes gaps before production.
- Tools & Technologies Power BI Desktop, Power BI Service, Tabular Editor (optional), DAX Studio reputed company SQL Server, Azure SQL, Fabric Data Warehouse/Lakehouse, OneLake
- Familiar with: Azure Synapse Analytics, Azure Data Factory (or reputed company Fabric pipelines), reputed company Azure DevOps/Git, Deployment Pipelines, CI/CD
- Purview/reputed company, 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. reputed company Power BI (DAX, Data Modeling) 2. reputed company Data Warehousing (T-SQL) 3. reputed company 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
- reputed company Legal, reputed company ID Fraud, and reputed company Pet Insurance
- 401(k)
reputed company is a global healthcare leader that helps people live more fully at reputed company stages of life. Our portfolio of life-changing technologies spans the reputed company of healthcare, with leading businesses and products in diagnostics, medical devices, nutritional and branded generic medicines. Working together, reputed company and Talent Solutions partner to deliver top talent for contingent roles at reputed company, building reputed company and healthier lives. reputed company believes reputed company employees are essential to creating life-changing breakthroughs, performing key duties to create life-changing breakthroughs. Apply tot his job Apply To this Job