SaaS Executive Reporting and Analytics Lead

Ford Motor • Detroit, MI

6d • $112,680 - $212,760 • Hybrid

About The Position

We are the movers of the world and the makers of the future. We get up every day, roll up our sleeves and build a better world -- together. At Ford, we’re all a part of something bigger than ourselves. Are you ready to change the way the world moves? Launched in 2023, Integrated Services creates and markets new customer experiences by integrating hardware, software and services across Ford Blue, Model e and Ford Pro. These products and services allow Ford's retail and commercial customers to customize their vehicles like never before with OTA (over-the-air)-driven experiences that grow better over time. Ford is developing leadership at the forefront of connected, digital platforms that will revolutionize every aspect of how vehicles function, the way people interact with them, and the value those vehicles provide. In this position... We are seeking a hands-on Reporting & Analytics Lead to transform complex SaaS business metrics into clear executive-level dashboards, automated corporate reporting, and decision-ready insights. This role combines deep technical execution with strategic reporting design — building scalable reporting frameworks while directly supporting C-suite leaders. You will operate as a high-impact individual contributor who thrives in evolving environments, works with incomplete requirements, and builds solutions that scale. This is a hands-on individual contributor role. You will personally design, build, code, and automate dashboards, data models, and reporting workflows.

Requirements

• Bachelor's Degree in Computer Science, MIS, Business Analytics, Industrial or Systems Engineer, or related degree
• 6+ years of hands-on experience in analytics, BI, or executive reporting roles
• Experience in SaaS or high-growth environments
• Proven experience personally building Power BI dashboards and data models
• Strong SQL skills with direct experience querying and transforming data
• Experience automating recurring reporting workflows
• Experience working with SaaS business models and metrics
• Advanced Microsoft Office skills (Excel, PowerPoint, Teams, SharePoint)
• Experience with Smartsheet or similar workflow/reporting tools
• Comfort working without a large data engineering or BI support team
• Ability to present and explain analysis directly to executives

Responsibilities

• Executive Reporting & Visualization Personally design and build Power BI data models and dashboards used by executive leadership
• Translate evolving SaaS KPIs into decision-ready executive visuals that can be run consistently on a regular frequency for ongoing usage.
• Create C-level reporting decks using Excel and PowerPoint, which can be run consistently on a regular frequency for ongoing usage.
• Prototype, iterate, and deploy reporting solutions quickly in ambiguous environments
• Automation & Reporting Operations Automate recurring executive reporting cycles
• Build and maintain automated reporting workflows (Power BI, Smartsheet, Microsoft tools)
• Create reusable reporting templates and scalable automation patterns
• Prototype, iterate, and deploy reporting solutions without relying on data engineering or IT
• SaaS Metrics & Data Integration Define and evolve key SaaS metrics (ARR, churn, margin, pipeline, utilization)
• Integrate data from SaaS platforms and databases
• Normalize data from multiple operational sources
• Ensure data accuracy through validation processes, documentation, and governance practices
• Align metric definitions with Finance and Operations
• Write SQL queries and transformations to integrate SaaS data
• Reporting Strategy & Governance Establish reporting standards and best practices
• Reduce dashboard duplication and sprawl
• Reduce manual reporting across teams
• Leadership & Influence Partner directly with executives and senior stakeholders
• Push back when metrics are unclear or misaligned
• Translate data into clear visuals that tell a story which is easily understood and supports executive decision-making.

Benefits

• Immediate medical, dental, vision and prescription drug coverage
• Flexible family care days, paid parental leave, new parent ramp-up programs, subsidized back-up child care and more
• Family building benefits including adoption and surrogacy expense reimbursement, fertility treatments, and more
• Vehicle discount program for employees and family members and management leases
• Tuition assistance
• Established and active employee resource groups
• Paid time off for individual and team community service
• A generous schedule of paid holidays, including the week between Christmas and New Year’s Day
• Paid time off and the option to purchase additional vacation time.

What This Job Offers

• Job Type: Full-time
• Career Level: Executive