Talent.com
Onsite - Intermediate Data Analyst to develop dataflows and datasets using Power BI, Power Query, M, DAX & SQL- BC 8143
Onsite - Intermediate Data Analyst to develop dataflows and datasets using Power BI, Power Query, M, DAX & SQL- BC 8143S.i. Systems • Victoria, CA
Onsite - Intermediate Data Analyst to develop dataflows and datasets using Power BI, Power Query, M, DAX & SQL- BC 8143

Onsite - Intermediate Data Analyst to develop dataflows and datasets using Power BI, Power Query, M, DAX & SQL- BC 8143

S.i. Systems • Victoria, CA
14 days ago
Job type
  • Permanent
  • Temporary
Job description

S.i. Systems enterprise manufacturing client is seeking an  Onsite - Intermediate Data Analyst to develop dataflows and datasets using Power BI, Power Query, M, DAX & SQL

Onsite in North Vancouver,  automall area - 5 days / week

12 month contract, 40 hours / week

Max hourly rate $43.16 / hour as a T4 temporary contractor - this is mandatory in order to be eligible to be under our Controlled Goods Clearance

Must be Canadian Citizen or have Permanent Residency AND have lived in Canada for the past 5 years without breaks - this is so that you can obtain Reliability Clearance

As a Data Analyst in the Enterprise Analytics team, you will be responsible for analyzing and interpreting complex data sets and transforming them into information that can be used by business teams to generate actionable insights. Your role will involve gathering information from various sources, analyzing patterns and trends, and presenting findings in a clear and concise manner.

MUST HAVE SKILLS

  • 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.
  • 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.
  • 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, p erformance 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

NICE TO HAVE SKILLS

  • Experience with Azure Analytics Services, including Azure Analysis Services
  • Experience with the Microsoft Power Platform, including Power Apps and Power Automate (Flow)
  • Duties / Accountabilities

  • 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.
  • Create a job alert for this search

    Onsite Intermediate Data Analyst to develop dataflows and datasets using Power BI Power Query M DAX SQL BC 8143 • Victoria, CA

    Similar jobs
    Data Analyst with Experience in Pharmaceutical - victoria

    Data Analyst with Experience in Pharmaceutical - victoria

    Sophus IT Solutions • victoria, bc, ca
    Full-time
    Data Analyst with Experience in Pharmaceutical or Life Sciences Manufacturing.The Data Analyst is responsible for collecting, categorizing, and submitting data generated by Vision AI monitoring sys...Show more
    Last updated: 3 days ago • Promoted
    Technical Sales Specialist Data Center

    Technical Sales Specialist Data Center

    RM Staffing B.V. • Victoria, BC, CA
    Full-time
    You’ll be the face of our technical expertise, conducting compelling.By effectively communicating the value of our services, you'll help prospective customers understand how our solutions can solve...Show more
    Last updated: 30+ days ago
    Information Technology Private Tutoring Jobs Brentwood Bay

    Information Technology Private Tutoring Jobs Brentwood Bay

    Superprof • Brentwood Bay, Canada
    Full-time +1
    Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi...Show more
    Last updated: 30+ days ago • Promoted
    (Remote) Support Analyst

    (Remote) Support Analyst

    Equest • Victoria, British Columbia, Canada
    Remote
    Full-time
    Join a community where people come first.Systems & Software, a division of Harris, is hiring a Support Analyst to join our collaborative, community-driven team. At Harris, you are not just a number : ...Show more
    Last updated: 13 days ago • Promoted
    Remote Senior Data Scientist - AI Trainer

    Remote Senior Data Scientist - AI Trainer

    SuperAnnotate • North Saanich, British Columbia, CA
    Remote
    Full-time
    As a Senior Data Scientist, you will work remotely on an hourly paid basis to review AI-generated analytical reasoning, code, and model outputs, as well as generate high-quality reference solutions...Show more
    Last updated: 30+ days ago
    Senior Medical Director, South Okanagan

    Senior Medical Director, South Okanagan

    Interior Health Authority • Southern Gulf Islands Electoral Area, BC, Canada
    Full-time
    To build the capacity for effective physician governance, physician integrated leadership, and engagement within IH.To improve the quality of medical care within IH by collaborating directly with p...Show more
    Last updated: 2 days ago • Promoted
    Remote Customer Service Sales

    Remote Customer Service Sales

    HMG Careers • North Saanich, British Columbia, CA
    Remote
    Full-time
    This full-time position offers flexible work hours and ample opportunities for advancement into management roles.You will work remotely to serve clients and offer valuable advice and protection to ...Show more
    Last updated: 21 hours ago • Promoted • New!
    Data Analyst with Experience in Pharmaceutical - Sophus IT Solutions

    Data Analyst with Experience in Pharmaceutical - Sophus IT Solutions

    Sophus IT Solutions • victoria, bc, ca
    Full-time
    Data Analyst with Experience in Pharmaceutical or Life Sciences Manufacturing.The Data Analyst is responsible for collecting, categorizing, and submitting data generated by Vision AI monitoring sys...Show more
    Last updated: 3 days ago • Promoted
    Business Analyst- Secret Clearence Level 2 - VBeyond Corporation

    Business Analyst- Secret Clearence Level 2 - VBeyond Corporation

    VBeyond Corporation • victoria, bc, ca
    Full-time
    We are looking for a Business Analyst-.Canadian Security : Secret Clearance (Level II).The role involves working closely with business stakeholders, technical teams, and vendors to gather requiremen...Show more
    Last updated: 7 days ago • Promoted
    Business Analyst- Secret Clearence Level 2 - victoria

    Business Analyst- Secret Clearence Level 2 - victoria

    VBeyond Corporation • victoria, bc, ca
    Full-time
    We are looking for a Business Analyst-.Canadian Security : Secret Clearance (Level II).The role involves working closely with business stakeholders, technical teams, and vendors to gather requiremen...Show more
    Last updated: 7 days ago • Promoted
    Algebra Private Tutoring Jobs North Island, Sunshine Coast, and Southern Gulf Islands

    Algebra Private Tutoring Jobs North Island, Sunshine Coast, and Southern Gulf Islands

    Superprof • North Island, Sunshine Coast, and Southern Gulf Islands, Canada
    Full-time +1
    Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi...Show more
    Last updated: 30+ days ago • Promoted
    Enterprise Applications Analyst (CRM)

    Enterprise Applications Analyst (CRM)

    Semios • Victoria, BC, CA
    Remote
    Full-time
    Quick Apply
    We are a bunch of people who really care about agriculture, food and the challenges facing farming.We want to help farmers with data driven decision making to help nature feed a growing population....Show more
    Last updated: 30+ days ago
    Tier I SOC Analyst - CyberClan

    Tier I SOC Analyst - CyberClan

    CyberClan • victoria, bc, ca
    Full-time
    Tier I SOC Analyst - Job Description.Established in 2006, CyberClan’s carefully selected team of experts are capable of solving complex cyber security challenges – keeping data secure and businesse...Show more
    Last updated: 7 days ago • Promoted
    Tier I SOC Analyst

    Tier I SOC Analyst

    CyberClan • victoria, bc, ca
    Full-time
    Tier I SOC Analyst - Job Description.Established in 2006, CyberClan’s carefully selected team of experts are capable of solving complex cyber security challenges – keeping data secure and businesse...Show more
    Last updated: 7 days ago • Promoted
    Remote Senior SQL Engineer - AI Trainer

    Remote Senior SQL Engineer - AI Trainer

    SuperAnnotate • North Saanich, British Columbia, CA
    Remote
    Full-time
    As a Senior SQL Engineer, you will work remotely on an hourly paid basis to review AI-generated SQL queries, database designs, and data-processing logic, as well as generate high-quality reference ...Show more
    Last updated: 30+ days ago
    JavaScript Integration Engineer : Customer Data (Remote)

    JavaScript Integration Engineer : Customer Data (Remote)

    Constructor • Victoria, BC, CA
    Remote
    Full-time
    Quick Apply
    Founded in 2019, Constructor is an AI-first e-commerce search and discovery platform that helps shoppers find the right products at the right time and enables leading global e-commerce brands to dr...Show more
    Last updated: 20 days ago
    Algebra Private Tutoring Jobs Central Saanich

    Algebra Private Tutoring Jobs Central Saanich

    Superprof • Central Saanich, Canada
    Full-time +1
    Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi...Show more
    Last updated: 30+ days ago • Promoted
    Business Analyst- Secret Clearence Level 2

    Business Analyst- Secret Clearence Level 2

    VBeyond Corporation • victoria, bc, ca
    Full-time
    We are looking for a Business Analyst-.Canadian Security : Secret Clearance (Level II).The role involves working closely with business stakeholders, technical teams, and vendors to gather requiremen...Show more
    Last updated: 7 days ago • Promoted