Business Intelligence Specialist

Ford Motor Company

Dearborn, MI, United States

5 days ago

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

3 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Microsoft Access Business Analytics Applications Data Analysis JIRA Microsoft Azure Data Governance Data Integration Extract Transform Load (ETL) Data Presentation Data Visualization Python (Programming Language) Performance Tuning

+9 more

Power BI Software Tools Scripting Google Cloud Powerquery Build Management Data Analytics Drilldown Custom Reports

Job 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., 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.

Requirements

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.