Senior Data Analyst- BigQuery and SQL Server

Description

We get up every day roll up our sleeves and build a better world -- together. At Ford were all a part of something bigger than ourselves. Are you ready to change the way the world moves

Ford of Canadas operations include a national headquarters three vehicle assembly and engine manufacturing plants three parts distribution centers and three Connectivity and Innovation centers. Ford employs approximately 7000 people in Canada while an additional 18000 people are employees in the more than 400 Ford and Ford-Lincoln dealerships across the country. For more information please visit

Enterprise Technology plays a critical part in shaping the future of mobility. If youre looking for the chance to leverage advanced technology to redefine the transportation landscape enhance the customer experience and improve peoples lives this is the opportunity for you. Join us and challenge your IT expertise and analytical skills to help create vehicles that are as smart as you are.

Responsibilities

What youll 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

Youll have...

Education

• Bachelors 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

• Masters 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 Beltlevel 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 $85000.00 - $135000.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.

We thank all candidates for their interest but only those selected for an interview will be contacted.

Ford of Canada is an Equal Opportunity Employer and is committed to a culturally diverse workforce.

Accommodations for applicants with disabilities throughout the recruitment selection and/or assessment processes where needed are available upon request. Please inform Human Resources of the nature of any accommodation(s) that you may require.

Candidates for this position must be legally entitled to work in Canada. Ford Motor Company of Canada Limited does not sponsor work permit applications.

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

Required Experience:

Senior IC