Sql data analyst • vancouver 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... Show more
We are seeking a highly analytical and motivated.Reporting to the Manager of FP&A, this role will support business performance through financial reporting, forecasting, budgeting, modeling, and... Show more
DarkVision, a Koch Engineered Solutions company, is looking for a Data (Python) Developer to join the Data Development Team in North Vancouver, BC.In this role, you will work collaboratively with t... Show more
We are seeking a highly accomplished and analytical Senior Analyst for an enterprise-level contract opportunity based out of Vancouver.In this role, you will take on a key capacity within a dedicat... Show more
Position:           Application Analyst Location:          Vancouver, Canada Department:    ... Show more
Join VetCare on its path to becoming a leading acquirer and operator of animal hospitals in Canada! We are seeking a detail-oriented and proactive Procurement Analyst to join our team and help stre... Show more
Mekanism is a full-service modern agency making unexpected ideas unstoppable through the power of Soul & Science.We partner with brands to unleash breakthrough creativity and drive impact acros... Show more
Senior Data AnalystReporting to the Manager, Business Intelligence & Analytics, the Senior Data Analyst will have a deep understanding of Data, AI, and Analytics solutions.You will be responsible f... Show more
With over $45 billion in assets under administration, our "booming" business means you gain high-level exposure and real opportunities for career advancement.We are professional yet enjoyable.We pr... Show more
Engineers and Geoscientists British Columbia is currently searching for a  Functional Analyst  to join our team in Burnaby!  The Functional Analyst at EGBC plays a crucial role in en... Show more
The Finance Analyst, FP&A is responsible for delivering high-quality operating and capital expenditure reporting, forecasting, and budget support.The role partners closely with budget owners, Accou... Show more
CGI is the world’s fifth-largest independent provider of IT and business process services, offering advanced business and IT consulting, systems integration, and comprehensive IT and business manag... Show more
At Aviso, we are dedicated to improving the financial well-being of Canadians.As a leading wealth management organization, we are committed to leadership, innovation, partnership, responsibility, a... Show more
Brighter Staffing Agency is a leading recruitment firm dedicated to connecting exceptional talent with organizations across a wide range of industries.Our mission is to deliver outstanding staffing... Show more
Description & Requirements.Setting the bar in technical fabrics and functional design, we create transformational products and experiences that support people in moving, growing, connecting, an... Show more
Master Data Management Analyst / Specialist.Location: Richmond, BC (Head Office).London Drugs is a leading Canadian retailer known for innovation, strong community values, and exceptional customer ... Show more
The Data Lab team is looking for a detail-oriented and highly analytical Data Analyst with FP&A expertise to support data-driven decision-making across the organization.In this role, you will combi... Show more
Putting people first, every day.BDO is a firm built on a foundation of positive relationships with our people and our clients.Each day, our professionals provide exceptional service, helping client... Show more
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.
