Business Intelligence Specialist
FastTek Global · Dearborn, MI · 2 wk ago
Business DevelopmentFull-time
About the role
Employees in this job function are 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 role leverages expertise in multiple tools for data integration, data modeling, data analysis, and advanced data visualization.
Responsibilities
- 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, dependencies, KPI movement, adoption, financial ROI, realized savings, forecast value, and 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.
- 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.
- Enable Crawl/Walk/Run maturity by supporting 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.
Requirements
- Bachelor's Degree
- 3+ years of specialist experience in a relevant field
- Hands-on experience with Power BI report development, DAX, Power Query, semantic modeling, filters, drilldowns, dashboard UX, and performance tuning (preferred)
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
- Preferred: Communications, Software Communications, Data Modeling, Tech Comms standards
Benefits
- Medical and Dental (FastTek pays majority of the medical program)
- Vision
- Personal Time Off (PTO) Program
- Long Term Disability (100% paid)
- Life Insurance (100% paid)
- 401(k) with immediate vesting and 3% (of salary) dollar-for-dollar match
- Lucrative employee referral program
- Employee recognition culture
FastTek Global was named one of the Top Work Places in Michigan by the Detroit Free Press from 2013 to 2023.