Sql data analyst • burnaby bc
Validate data sources, transformations, and analysis against reference data to ensure quality, accuracy, and completeness of derived reports.Complete data discovery and mapping of shipyard enterpri... Voir plus
Designs, develops, and maintains highly complex Power BI reports and dashboards, incorporating advanced data modeling techniques to integrate data from disparate shipbuilding systems.Works extensiv... Voir plus
Our employees are at the heart of everything we do.Together, we help people, businesses, and society prosper in good times and be resilient in bad times.Our employee promise represents Intact’s com... Voir plus
We are a Sports & Entertainment Marketing business.We grow audiences and revenues.We do that by knowing fans best.We work with clients to help them understand & influence what their fans ar... Voir plus
As the Senior Analyst/Analyst, Workforce Planning you will:.Accurately project volume and determine labour requirements.Prepare, build, and publish optimized schedules.Support the business with liv... Voir plus
Our client, is seeking a high-performing, self-directed HR Systems Analyst to join their human resources technology team during a period of rapid system transformation.In this critical, hands-on ro... Voir plus
Located in the heart of downtown Vancouver, between the Pacific Ocean and the Coast Mountains, Teck’s Corporate Office sits in one of Canada’s most culturally diverse cities.Surrounded by world-ren... Voir plus
With over 60 years of industry experience, Gescan has 29 branches located across Western Canada.At Gescan, we leverage our strong global resource base, our local expertise, and our family-oriented ... Voir plus
Affiliation: Management & Exempt.Employment Status: Full-Time Regular.Expected Hiring Range: $97,100.Short-term Incentive Eligible: Yes.Posting End Date: Open until filled.As the province’s lar... Voir plus
We are hiring for this position out of our Vancouver office.Successful candidates who apply outside of these areas will be expected to relocate and reside in a location that is within a commutable ... Voir plus
Job Title: Accounts Payable AnalystPrimary Location: Vancouver, BC Job Status: Full-Time, PermanentEmail to applyPrimex Investments Ltd.Primex) is a BC-owned and operated real estate investment, d... Voir plus
Our client is seeking a junior data analyst to assist with customer compliance and documentation within their data domain.This is a junior position and is open to new or recent graduates.A Bachelor... Voir plus
Entity: WELL Health Technologies.Position Title: Financial Analyst.Salary Range: $80,000 - $90,000.WELL Health Technologies is an innovative technology-enabled healthcare company whose overarching ... Voir plus
Leading end-to-end lending solution.Canada’s most advanced cloud and AI platform, delivering end-to-end financing technology solutions for lenders in the digital age.Nesto Cloud is Canada's cloud-n... Voir plus
Vancouver is consistently ranked as one of the world’s most liveable and environmentally sustainable cities.Recognized among BC’s Top Employers and Canada’s Greenest Employers, the City of Vancouve... Voir plus
The person will be responsible for leading Microsoft SQL Server database administration, production support, operational governance and database service delivery for the BC Hydro PU13 Database towe... Voir plus
Data Governance & Master Data Senior Analyst (1 year contract, hourly).Data Governance & Master Data Senior Analyst (1 year contract, hourly).Sunrise Farms is one of Canada's leading food processin... Voir plus
We are recruiting a proactive and detail-oriented Security Analyst to join our growing IT department.Reporting to the Director of IT, this role plays a vital operational part in safeguarding our gl... Voir plus
At Deloitte, our Purpose is to make an impact that matters.We exist to inspire and help our people, organizations, communities, and countries to thrive by building a better future.Our work underpin... Voir plus
Validate data sources, transformations, and analysis against reference data to ensure quality, accuracy, and completeness of derived reports.
Complete data discovery and mapping of shipyard enterprise applications.
Develops documentation of business requirements, data sources, infrastructure, and reports to provide clarity and context for data consumers throughout the shipyard
Experience with data visualization tools such as Tableau, Power BI, or Looker to create interactive dashboards and reports is an asset.
Develop dataflows and datasets using Power Query, M, DAX & SQL.
Proficiency in SQL for querying and analyzing data from relational databases is an asset
Knowledge of programming languages such as Python or R for data analysis and manipulation is an asset.
Build dataset requirements, metrics, data/report definitions and establishes reporting governance processes.
Optimizes and standardizes all stages of the data analysis process, from extraction through to modelling & visualization.
Collects, validates, interprets, and organizes various types of data into relevant metrics and reports and/or summaries for designated business objectives.
Collaborates with and supports training and knowledge transfer to business end-users of data sources.
Acts as a Business Intelligence Subject Matter Expert (SME) by supporting team members in the use and interpretation of data and understanding of metrics and reporting requirements.
Understanding business objectives and providing ad hoc data extracts by working with business partners.
Effectively interpret diverse data sources and extract meaningful information while maintaining expert knowledge of all these data sources.
What you must have:
Minimum Bachelor’s degree in Computer Science, Statistics, Business, or a relevant field. An equivalent combination of education and/or work experience will be considered.
Minimum 4 years of experience with business analytics, statistical analytics, KPI development and metrics reporting, preferably in a Program & Project Management environment with quantitative, financial or metric analysis on multiple large-scale data warehouses.
Skills, Knowledge and Required Competencies
Experience with ground-up / full stack analytics solutions is an asset, including development of data sources, loading/transformation, analysis/modelling, reporting, and end user experiences. Skills, Knowledge and Required Competencies.
Well-developed understanding of database structure, business object models, and large-scale data processing techniques.
Significant experience with Microsoft Power Query, M, DAX & SQL.
Proven experience working with data and databases, including working experience with programming languages and business intelligence tools such as SQL and Power BI, to build dataflows, datasets and analytical solutions and create visual insights and dashboards
Familiarity and understanding of KPI analysis, performance measurement, financial systems and project scheduling/controls systems
Demonstrated data analytic skills including proven ability to merge multiple data sources into meaningful information, review incomplete data, problem solve to fill in gaps and provide recommendation for meaningful solutions
Strong technical communication ability, including the ability to clearly and concisely document and communicate complex data structures and process maps.
Strong analytical and problem-solving skills
Excellent verbal/written communication and interpersonal skills for effectively communication
Well-developed organizational skills, including ability to prioritize a variety of work assignments
Experience with Azure Analytics Services, including Azure Analysis Services, is an asset.
Ability to work independently with minimal supervision and superior time management skills.
Experience with the Microsoft Power Platform, including Power Apps and Power Automate (Flow) is an asset.
Salary/Rate Range: $42.00 -$57.00 per hour
Thank you for your interest in this opportunity. If you are selected to move forward in the process, we will contact you directly. If you do not hear from us, we encourage you to continue visiting our website for other roles that may be a good fit.
