Junior Bi Developer Jobs in Dearborn, MI (NOW HIRING)

Job Title: Junior Program Analyst

Job Description

The Junior Program Analyst serves as a key business partner supporting vehicle program development and Final Assembly Engineering initiatives, with a strong focus on program financials and reporting. The role centers on transforming complex financial and program data into meaningful insights, executive-level reporting, and visual storytelling that drive informed decision-making. The analyst partners closely with cross-functional teams to audit funding utilization, provide financial insights, and enhance visibility into overall program health, while clearly communicating program status, risks, opportunities, and funding needs.

Responsibilities

• Develop and maintain executive-level dashboards and reporting tools using Power BI and other visualization platforms to provide leadership with clear visibility into program performance, budget utilization, funding status, and key program metrics.
• Create compelling presentations, visual aids, charts, and storytelling materials that simplify complex financial and operational information for executive audiences.
• Analyze program budgets, forecasts, actual spend, funding allocations, and financial trends across multiple programs to identify key insights and support decision-making.
• Work closely with engineering, operations, purchasing, manufacturing, IT, and finance teams to collect, validate, and synthesize data from multiple sources into meaningful business insights.
• Drive program financial reporting, including status updates and executive business reviews, by clearly communicating key messages, risks, variances, and recommendations.
• Audit funding utilization and spending activity to ensure financial accuracy, compliance, and alignment with approved program objectives.
• Monitor forecasts, commitments, accruals, purchase orders, and funding requirements to proactively identify issues and support timely corrective actions.
• Develop and maintain scorecards, spend curves, trend analyses, and performance metrics that enable leadership to evaluate program health and financial performance.
• Support project coordination activities related to program financials and reporting, ensuring deadlines are met and deliverables are accurate and complete.
• Use strong communication and organizational skills to manage multiple priorities and ensure stakeholders receive timely and accurate financial information.

Essential Skills

• 3–5 years of program or finance analyst experience supporting large-scale product development, manufacturing, engineering, IT, or corporate programs.
• At least 3 years of experience with financial processes, program funding structures, and tracking and reporting of financial performance.
• Proficiency in financial analysis and financial reporting, including budget analysis, forecasting, and variance analysis.
• Experience with Ariba, SAP, Power BI, Tableau, or similar reporting and analytics tools.
• Strong skills in Power BI and data analysis to build dashboards and visualizations.
• Proficiency in creating executive-level PowerPoint presentations and other visual communication materials.
• Understanding of financial planning, accrual management, purchase order processes, and invoice reconciliation.
• Experience preparing executive-level business reviews and financial status presentations.
• Demonstrated ability to work cross-functionally with engineering, purchasing, manufacturing, operations, IT, finance, and senior leadership.
• Strong communication and organizational skills, with the ability to translate complex financial and operational data into clear, actionable insights.
• Bachelor’s degree in a related field.

Additional Skills & Qualifications

• Experience with Ariba procurement and financial workflows.
• Automotive industry experience or exposure to vehicle program development.
• Background in program management or project coordination supporting technical or engineering programs.
• Advanced data visualization and storytelling skills, including the ability to design clear and engaging charts and dashboards.
• Comfort presenting to executive audiences and tailoring messages to different stakeholder groups.

This is a Contract position based out of Dearborn, MI.

The pay range for this position is $38.00 - $43.00/hr.

Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: • Medical, dental & vision • Critical Illness, Accident, and Hospital • 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available • Life Insurance (Voluntary Life & AD&D for the employee and dependents) • Short and long-term disability • Health Spending Account (HSA) • Transportation benefits • Employee Assistance Program • Time Off/Leave (PTO, Vacation or Sick Leave)

This is a fully onsite position in Dearborn,MI.

This position is anticipated to close on Sep 8, 2026.

Aston Carter provides world-class corporate talent solutions to thousands of clients across the globe. Specialized in accounting, finance, human resources, talent acquisition, procurement, supply chain and select administrative professions, we extend the capabilities of industry-leading companies. We draw on our deep recruiting expertise and expansive network to meet the evolving needs of our clients and talent community with agility and excellence. With offices across the U.S., Canada, Asia Pacific and Europe, Aston Carter serves many of the Fortune 500. We are proud to be a ClearlyRated Best of Staffing® Platinum Award winner for both client and talent service.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please email astoncarteraccommodation@astoncarter.com for other accommodation options.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.