Business Intelligence Specialist

Stefanini Group is hiring!

Stefanini is looking for a Business Intelligence Specialist, Dearborn, MI

For quick apply, please reach out to Saurabh Kapoor at 248-582-6559/saurabh.kapoor@stefanini.com

Note: This is a W2 requirement only, we are not working on C2C/C2H.

We are seeking 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.

Key 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.

Skills Required

• 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

Experience Required

• 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

Education Required

• Bachelor's Degree

Education Preferred

• Certification Program