Sql data analyst Jobs in Burnaby, BC

Duties and Responsibilities are:

-Collect, analyze, and interpret project, financial, and operational data from construction systems (ERP, project management, equipment, and safety).
-Develop and maintain dashboards and reports to monitor project performance, costs, schedules, productivity, and safety metrics.
-Track key construction KPIs and provide actionable insights to support project planning, forecasting, and decision-making.
-Extract, transform, and validate data obtained from various to build clean and consistent datasets for analysis.
-Develop and maintain standardized data models and metrics that promote a single source of truth across teams.
-Ensure data accuracy and consistency across projects and reporting tools.
-Automate reporting processes and support BI system implementation and optimization.
-Collaborate with Project Managers, Finance, and Operations to meet data and reporting needs.
-Monitor data quality and proactively identify inconsistencies or gaps in data integrity, working with technical teams to resolve issues.
-Automate recurring data requests and streamline manual reporting processes.
-Present insights clearly to management and assist teams in using dashboards effectively.
-Stay updated on BI tools and construction analytics best practices to improve reporting and analysis.

Qualifications/Experience/Competencies

-Completion of a bachelor’s degree in computer science/data science/information systems or related field
-3+ years of experience as a Business Intelligence Analyst, Data Analyst, or similar role within a data-driven environment.
-Experience with machine learning and analytics
-Strong proficiency in SQL for querying and manipulating large datasets.
-Hands-on experience with data visualization tools such as Power BI
-Experience with Google Sheets, including Google Apps Script for automation and integrations.
-Familiarity with ETL concepts and data transformation tools
-Comfortable working with APIs and cloud-based data platforms
-Good understanding of data modeling, data governance, and best practices for maintaining data quality and consistency
-Strong analytical and problem-solving skills with high attention to detail and data accuracy.
-Excellent communication skills; able to simplify complex data findings for non-technical audiences
-Proactive, curious, and comfortable working both independently and collaboratively in a team setting
-Organized, with the ability to manage multiple priorities and meet deadlines in a dynamic environment

Salary Range: $65,000 – $85,000 annually, depending on experience and qualifications

The Data Analyst is responsible for transforming data into actionable insights that drive business decisions. This role involves gathering, analyzing, and interpreting large datasets; developing dashboards and reports; and collaborating with cross-functional teams to support strategic planning and operational efficiency.

Pourquoi nous rejoindre ?

- Competitive, experience‑based salary with annual pay reviews
- Extended health benefits
- RRSP matching up to 5% of base salary per year
- Employee Stock Ownership Program – become a Vinci Construction group shareholder
- 3 weeks paid vacation starting Day 1 + paid holiday shutdown
- Milestone awards to celebrate your achievements
- Employee referral bonuses up to $2,000
- Full training catalogue to support long‑term career growth
- Maternity Leave Top‑Up (SUB Plan)
- Employee Assistance Program (EAP) for 24/7 personal support
- Friday office snacks
- Family‑friendly company events throughout the year
- Free on‑site parking

BA Blacktop is proud to be an equal opportunity employer that is committed to inclusion and diversity. We are committed to equal employment opportunity regardless of race, color, religion, sex, national origin, sexual orientation, gender identity or gender expression, age, disability or veteran status. BA Blacktop believes in building better, together.

Entité

BA Blacktop, qui fait partie de VINCI Construction Canada, a été fondée dans la province de la Colombie-Britannique en 1956. Nous sommes devenus un important entrepreneur général et concepteur-constructeur, avec un groupe d'entreprises innovantes et multidisciplinaires offrant des services spécialisés de pavage, de béton, de fraisage, de récupération et de recyclage, ainsi que la construction de ponts à travées multiples et des solutions novatrices en matière de structures en béton à des clients de l'ensemble de la Colombie-Britannique.