Business Intelligence Specialist

Stefanini Group•Dearborn, MI

21h•Onsite

About The Position

Stefanini Group is hiring! Stefanini is looking for a Business Intelligence Specialist, Dearborn, MI. We are seeking a Business Intelligence Specialist who will be responsible for enabling intelligent business decisions by designing robust analytics solutions through a blend of business acumen, data and analytics proficiency, and technical solution architecture. This includes leveraging knowledge and expertise in multiple tools for data integration, data modeling, data analysis, advanced data visualization, and related disciplines.

Requirements

3+ years of experience in a relevant field
Hands-on Power BI report development : DAX, Power Query, Semantic modeling, Filters, Drill-downs, Dashboard UX, Performance tuning
Business Intelligence
Business Analytics
Data Analysis
Ad Hoc Reporting
Microsoft Azure
Python
ETL
GCP
Automated Scripting
Data/Analytics Dashboards
Jira
Financial Operations
Data Governance
Data Modeling

Responsibilities

Support integration and data modeling across Jira, Workboard KPI data, Nicus/finance datasets, PC&I Finance datasets, engineering tools, PLM/ERP systems, and centralized datasets as access becomes available.
Support Crawl/Walk/Run maturity by enabling manual data intake where required while designing models and pipelines that can evolve toward governed refresh and automation.
Conduct data validation, reconciliation, exception management, and source-to-dashboard accuracy checks for KPI, Jira, financial, operational, and adoption data inputs.
Analyze change requests and defects, assess impact to existing functionality, create test cases, perform unit testing, support user acceptance testing, and document known limitations.
Participate in design reviews, code/report peer reviews, sprint planning, stakeholder demos, deployment activities, handoff, runbook creation, documentation, and knowledge transfer to teams.
Own assigned backlog items for Power BI dashboard development, analysis, testing, documentation, and release support through sprint delivery.
Partner with PC&I Technology, transformation sponsors, PMO leads, Finance/value realization stakeholders, data governance leads, and workstream teams to gather requirements and convert them into Power BI reporting solutions.
Design and build persona-based Power BI reports and dashboards covering: Portfolio health, Execution velocity, Milestone completion, Risks and dependencies, KPI movement, Adoption, Financial ROI, Realized savings, Forecast value, Value realization
Create and maintain Power BI semantic models, measures, calculations, relationships, filters, drill-through paths, and reusable report patterns that support executive-grade decision-making.
Develop dashboard UX that uses clear information hierarchy, data storytelling, drill-down navigation, accessibility-aware design, and maintainable layouts for executive and workstream audiences.