# Senior Data Analyst- BigQuery and SQL Server

**Company**: Ford of Canada
**Location**: Waterloo
**Work arrangement**: hybrid
**Experience**: senior
**Job type**: full-time
**Salary**: $85,000.00 - $135,000.00
**Category**: Engineering
**Industry**: Automotive

**Apply**: https://efds.fa.em5.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/62284
**Canonical**: https://yubhub.co/jobs/job_feec74b2-210

## Description

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.

## Skills

### Required
- BigQuery
- SQL Server
- SQL
- Time-series analysis
- Sequence analysis
- Data validation
- Hypothesis development
- Multi-source data integration
- Log pattern tool support
- Comprehensive reporting
- Cross-functional collaboration
- Executive communication

### Nice to have
- Master's degree in Data Science, Computer Science, Statistics, Engineering, or a related quantitative field
- Six Sigma, DMAIC
- Python (Pandas, NumPy)
- R
- Infotainment and vehicle systems
- Automotive data analysis
- Google Cloud Platform (GCP) data services
- Data transformation tools (dbt)
- Cloud infrastructure
- DevOps
- Embedded teams
- Effective written and verbal communication skills