Position: Business Intelligence Specialist- 330356 Location: Dearborn, MI Duration: 12 months MOI: MS Teams Direct Client: FORD Motors
Position Description:
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; leveraging knowledge and expertise in multiple tools for data integration, data modeling, data analysis tools, advanced data visualization tools etc.
Key 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, Nicfinance datasets, PC&I Finance datasets, engineering tools, PLM/ERP systems, and centralized datasets as access becomes available.
Skills Required:
Business Intelligence, Business Analytics, Data Analysis, Ad Hoc Reporting, Microsoft Azure, Python, ETL, Google Cloud Platform, Automated Scripting, Data/Analytics dashboards, Jira, Financial Operations, Data Governance
Skills Preferred:
Communications, Software Communications - Other, Data Modeling, Tech Comms standards
Experience Required:
Specialist Exp: 3+ experience in relevant field
Experience Preferred:
Hands-on Power BI report development, DAX, Power Query, semantic modeling, filters, drilldowns, dashboard UX, performance tuning.
Education Required:
Bachelor's Degree
Education Preferred:
Certification Program