Senior Data Analyst- BigQuery and SQL Server

We're seeking a Senior Data Analyst to join our Enterprise Technology team. As a Senior Data Analyst, you will lead timely analysis for evolving, high-priority stakeholder questions, clarify problem statements, align on definitions, and deliver accurate findings with supporting evidence.

Your primary responsibilities will include:

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

To succeed in this role, you will need:

• A Bachelor’s degree in Data Science, Computer Science, Statistics, Engineering, or a related quantitative field.
• Minimum 3 years experience in data analysis, including time-series/event correlation and relational (non-time-series) analysis.
• Expert use of SQL, including analytical/window functions, with BigQuery and SQL Server (or equivalent relational database) experience.
• 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.

Preferred qualifications include:

• A Master’s degree in Data Science, Computer Science, Statistics, Engineering, or a related quantitative field.
• 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.

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.