Ford Motor Company

Senior Data Analyst- BigQuery and SQL Server

Ford Motor Company • $85K — $135K *
Waterloo, ON N2J 1A1In-Person
Information Technology
Less than 5 years of experience
1 month ago
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Data Science, Computer Science, Statistics, Engineering, or similar quantitative field required.
  • Minimum 3 years of data analysis experience, focusing on time-series/event correlation and relational analysis.
  • Expertise in SQL with proficiency in analytical and window functions, particularly with BigQuery and SQL Server.
  • 5 years of experience using visualization/reporting tools like Power BI or Looker Studio.
  • Ability to identify data anomalies and use findings to refine hypotheses.

Responsibilities

  • Lead rapid investigations to analyze high-priority stakeholder queries and deliver accurate findings.
  • Perform time-series analysis using BigQuery to measure outcome contexts and identify precursor signals.
  • Develop efficient SQL queries for data workflows, focusing on sessionization and event sequences.
  • Conduct relational data analysis in SQL Server and reconcile findings with event-based analytics.
  • Assess data quality, validate results, and iterate on analyses based on new information.
  • Integrate multiple data sources to create a coherent view of events and conditions.
  • Communicate complex findings clearly, especially in high-visibility settings, ensuring a distinction between evidence and hypotheses.

Benefits

  • Hybrid work environment that allows flexible remote working arrangements.
  • Participation in an Annual Compensation bonus program for eligible individuals.
Full Job Description
Job Description

Responsibilities

What you'll do...

The primary responsibilities for this position include but are not limited to:
  • Rapid Investigations & Stakeholder Support: Lead timely analysis for evolving, high-priority stakeholder questions; clarify problem statements, align on definitions, and deliver accurate findings with supporting evidence.
  • Time-Series & Sequence Analysis (BigQuery): Analyze time-ordered event/telemetry data at scale to establish context around key outcomes, identify precursor signals, and measure the frequency of specific event sequences.
  • Advanced SQL Development: Write efficient, well-structured SQL for analytical workflows, including heavy use of window functions for sequencing, sessionization, and "leading up to" / "following" event context.
  • Relational Data Analysis (SQL Server): Analyze non-time-series operational datasets in SQL Server; join across tables, validate definitions, and reconcile findings with event-based analytics where applicable.
  • Data Validation & Hypothesis Development: Assess data quality and result validity, identify anomalies, form and test hypotheses, and iterate analyses as new information emerges.
  • Multi-Source Data Integration: Integrate and reason across multiple data sources to provide a coherent view of what happened and under what conditions.
  • Log Pattern Tool Support (Rules & Execution): Work with stakeholders to define detection requirements, author and refine rule logic for our log-pattern analysis tool, execute investigations, and summarize findings along with recommended rule improvements.
  • Comprehensive Reporting: Deliver outputs ranging from concise executive summaries to detailed technical write-ups that document methods, assumptions, and contributing factors.
  • Cross-Functional Collaboration: Work closely with engineering, product, and process-improvement stakeholders (including Six Sigma/Black Belt practitioners) to frame questions, define metrics, and support structured root-cause analysis efforts.
  • Executive Communication: Communicate complex findings calmly and clearly in high-visibility settings; distinguish evidence from hypotheses and avoid premature conclusions.


Qualifications

You'll have...

Education
  • Bachelor's degree in Data Science, Computer Science, Statistics, Engineering, or a related quantitative field. (Successful candidates will be required to provide proof of degree completion for the highest level of education attained. If the degree was obtained from a school outside of Canada, an Education Credential Assessment report showing Canadian equivalency is also required).

Experience
  • Minimum 3 years experience in:
    -Data analysis, including time-series/event correlation and relational (non-time-series) analysis.
    -SQL, including expert use of analytical/window functions; with BigQuery and SQL Server (or equivalent relational database) experience.
    -Writing performance-conscious queries over large datasets (e.g., partitioning/clustering-aware approaches, minimizing unnecessary scans, and validating results efficiently).
  • Demonstrated ability to identify anomalies, validate assumptions, and use data to test hypotheses and refine problem statements.
  • Minimum 5 years of experience in visualization/reporting tools such as Power BI or Looker Studio.


Even better, you may have...

Education
  • Master's degree in Data Science, Computer Science, Statistics, Engineering, or a related quantitative field (Successful candidates will be required to provide proof of degree completion for the highest level of education attained. If the degree was obtained from a school outside of Canada, an Education Credential Assessment report showing Canadian equivalency is also required).

Experience
  • Familiarity with structured problem-solving / continuous improvement approaches (e.g., Six Sigma, DMAIC), and comfort collaborating with Black Belt-level stakeholders.
  • Proficiency in Python (Pandas, NumPy) or R for analysis and workflow automation.
  • Knowledge of infotainment and vehicle systems, or experience in automotive data analysis.
  • Experience with Google Cloud Platform (GCP) data services beyond BigQuery.
  • Experience with data transformation tools such as dbt.
  • Familiarity working with cloud infrastructure, DevOps, or embedded teams in cross-functional environments.
  • Effective written and verbal communication skills, including the ability to tailor explanations for both technical and non-technical audiences.
  • Ability to manage shifting priorities and deliver accurate work on tight timelines.


This posting is for an existing vacancy within our team.

The expected annual salary range for this Ford of Canada position is $85,000.00 - $135,000.00 and individuals may be eligible to participate in our Annual Compensation bonus program.

Our focus is to build the best team. If you think you can bring value to Ford, love to collaborate, prioritize and aim to deliver excellence in everything you do, we encourage you to apply!

Successful candidates will be required to provide proof of degree completion for the highest level of education attained. If the degree was obtained from a school outside of Canada, an Education Credential Assessment report showing Canadian equivalency is also required.

This position is hybrid. Candidates who are in commuting distance to a Ford hub location may be required to be onsite four or more days per week.

#LI-Hybrid

#LI-NJ1

About Ford Motor Company

Ford Motor Company manufactures or distributes automobiles in addition to offering financial services. The company sells to dealerships for retail sales, and for sale to fleet customers, including commercial fleet customers, daily rental car companies, and governments. Ford’s vehicle portfolio includes automobiles, buses, tractors, and trucks. Retail financing includes retail installment sale contracts for new and used vehicles, and direct financing leases for new vehicles to retail customers, government entities, daily rental car companies, and fleet customers. Finance receivables in the non-consumer portfolio include products offered to automotive dealers. Ford’s environmental initiatives include compressed natural gas, flexible fuel vehicles, electric drive vehicles, Hydrogen, PC power management, and so on. Ford Motor Company was founded by Henry Ford in 1903 and is headquartered in Dearborn, Michigan.

Ford Motor Company Careers

Join the dynamic team at Ford Motor Company, a global leader in automotive innovation and manufacturing. At Ford, we are committed to driving human progress by providing outstanding vehicles and mobility solutions. This is an exciting time to become part of our inclusive team, where job opportunities abound and growth is not just a possibility, but a promise.

Work You’ll Do

At Ford Motor Company, you will collaborate with some of the brightest minds in the industry. Our professionals are at the forefront of automotive technology, leading projects that redefine transportation and sustainability. With a culture rooted in continuous improvement and respect for all, Ford offers a workplace where leadership, diversity training, and innovation are part of everyday life.

Join Our Market-Leading Team

Ford’s commitment to excellence is why we are a leader in the automotive sector. We offer a variety of career paths, from engineering to marketing, all designed to foster professional and personal growth. Our team benefits from Ford’s commitment to professional development and networking opportunities, ensuring that every team member can reach their full potential.

Innovative Work

Engage in work that makes a difference. Ford Motor Company is pioneering developments in electrification, autonomous vehicles, and smart mobility solutions. Our team of over 190,000 employees worldwide is dedicated to crafting experiences that improve the way the world moves.

Be Part of a Great Team

Working at Ford means more than just having a job; it means being part of a global family. Our culture promotes teamwork, integrity, and respect—values that underpin everything we do. We believe in nurturing a diverse and inclusive environment where every employee can thrive.

Future-Proof Your Career

Ford Motor Company is not just a great place to work; it’s a place to build a lasting career. Our employees enjoy competitive benefits, comprehensive health care, and retirement plans that rank among the best in the industry. We support career advancement through extensive training programs and hands-on experience in the latest automotive technologies.

Explore Job Opportunities and Internships

Whether you’re a seasoned professional looking for your next challenge or a student interested in an internship, Ford has opportunities that will harness your skills and ignite your ambition. Our hiring process is straightforward and respectful, designed to match your skills and passions with the right position.

Stay Connected

Join Our Team Search open positions that match your skills and interests. We look for passionate, curious, creative, and solution-driven team players. Ready to start your journey with Ford? Prepare your resume, sharpen your interview skills, and become part of a company that’s building the future of transportation.

Keep Up to Date

Stay ahead with career tips, insider perspectives, and industry-leading insights you can put to use today—all from the people who work here.

Job Alert Emails

Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Discover the exciting and rewarding career opportunities awaiting you at Ford Motor Company. Join us at Ford, where we go further so you can go farther in your career.
Learn more about Ford Motor Company
Size
183,000 employees
Market Cap
$44.8 billion
Industry
Manufacturing & Automotive
Net Income
-$1.2 billion
Founded
1903
5 Year Trend
-2.1%
Revenue
$127.1 billion
NASDAQ
F
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Ford Motor Company

More Information Technology Jobs

Find similar Senior Data Analyst- BigQuery and SQL Server jobs:

NationwideWaterloo, ON