Financial Analyst – Advanced Analytics, BI

Jobtailor; Dearborn (MO); On-site; USD 120,000 - 160,000; Full time

Job summary

Jobtailor in the United States is seeking a data product engineer to design, build, and deploy scalable data products that combine BI, cloud data, and AI/ML for finance and engineering teams.

You will replace manual processes, analyze BOMs and quotes to drive cost savings, and design pipelines on GCP/BigQuery while delivering actionable insights through Power BI dashboards. Strong SQL, Python, and financial modeling skills are essential.

Qualifications

• Bachelor's degree in a highly quantitative field (Finance, Economics, Data Science, CS, Engineering)
• Proven track record of self-led learning of new technical tools
• Strong experience in SQL and querying large, complex datasets
• Experience with Google Cloud Platform (GCP)/BigQuery or similar cloud platforms is highly valued
• Experience using Python, Pandas, NumPy, scikit-learn to build predictive models and automate workflows
• Power BI dashboard design and data storytelling
• Solid understanding of financial principles (cost forecasting, NPV/ROI, budgeting, capital investment)
• Ability to connect financial drivers with scalable data and analytics solutions
• Must be legally authorized to work in the United States
• Visa sponsorship is not available

Responsibilities

• Design, build, and deploy scalable data products combining BI, Cloud Data, and AI/ML
• Replace manual processes across Product Development Finance and enable faster, more informed decision-making
• Analyze Bills of Materials, supplier quotes, and engineering specs to identify cost savings and waste reduction
• Design secure data pipelines and data models on Google Cloud Platform and BigQuery
• Write optimized SQL and Python to automate analyses and generate actionable insights
• Explore and prototype AI-enabled solutions for finance and engineering teams
• Build dynamic Power BI dashboards translating data into clear insights for leadership
• Own code, models, and data quality
• Prioritize projects based on business impact and deliver fast, repeatable value
• Share expertise and upskill peers across teams

Skills

SQL querying

Python programming

Pandas

NumPy

Scikit-learn

Data modeling

Predictive modeling

Data pipeline design

Cost forecasting

NPV/ROI modeling

Education

Bachelor's degree in Finance, Economics, Data Science, Computer Science, Engineering

Tools

GCP

BigQuery

Power BI

Job description

• Design, build, and deploy scalable data products combining BI, Cloud Data, and AI/ML
• Replace manual processes across Product Development Finance and enable faster, more informed decision-making
• Analyze Bills of Materials, supplier quotes, and engineering specifications to identify, quantify, and track material cost savings and waste reduction
• Design secure data pipelines and data models on Google Cloud Platform and BigQuery
• Write optimized SQL and Python to automate analyses, build predictive models, and generate actionable insights
• Explore and prototype AI-enabled solutions for finance and engineering teams
• Build dynamic Power BI dashboards translating complex technical and financial data into clear insights for engineering and senior finance leadership
• Own code, models, and data quality
• Prioritize projects based on business impact and deliver fast, repeatable value
• Share technical expertise and upskill peers while collaborating across teams

Requirements

• Bachelor's degree in Finance, Economics, Data Science, Computer Science, Engineering, or a related highly quantitative field
• Proven track record of teaching yourself new technical tools
• Strong experience in SQL and querying large, complex datasets
• Experience with Google Cloud Platform (GCP)/BigQuery or similar cloud platforms is highly valued
• Experience using Python, Pandas, NumPy, scikit-learn or similar to build predictive models, perform feature engineering, and automate workflows
• Power BI dashboard design and data storytelling
• Strong understanding of financial principles, including cost forecasting, NPV/ROI modeling, budgeting, and capital investment analysis
• Ability to connect financial drivers with scalable data and analytics solutions
• Must be legally authorized to work in the United States
• Visa sponsorship is not available

Core Competencies

Demonstrates expertise in designing and deploying scalable data products using SQL, Python, and Google Cloud Platform, while effectively translating complex financial data into actionable insights through Power BI dashboards. Strong understanding of financial principles and ability to automate workflows and build predictive models to drive informed decision-making.

Highest-signal resume keywords

• SQL Querying
• Google Cloud Platform (GCP)
• Python Programming
• Power BI Dashboard Design
• Financial Analysis

ATS Optimization Keywords

Hard Skills

• SQL
• Python
• Pandas
• NumPy
• Scikit-learn
• Data Modeling
• Predictive Modeling
• Data Pipeline Design
• Cost Forecasting
• NPV/ROI Modeling

Soft Skills

• Collaboration
• Teaching
• Upskilling

Industry Keywords

• Data Science
• Finance
• Engineering
• Data Analytics
• Cost Savings
• Waste Reduction

Tools & Technologies

• Google Cloud Platform
• BigQuery
• Power BI