BI Data Engineer

Lakefield Veterinary Group; Burlington; Híbrido; CAD 123.558 - 144.151; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

PTO

Employee Assistance

401(K)

Medical

Dental

Vision

Bonuses based on performance

Descripción de la vacante

A veterinary services provider seeks a Data Analyst responsible for collecting and analyzing data to support strategic initiatives. The role involves creating PowerBI dashboards, working closely with stakeholders, and improving data delivery through Azure services. Ideal candidates have strong SQL skills, experience in report creation, and a desire to enhance business processes. This full-time position offers competitive compensation between $90,000 - $105,000 annually.

Formación

• 2+ years’ experience in MS SQL writing efficient queries.
• 3+ years in an Analyst role creating PowerBI dashboards.
• Ability to tune performance of queries and dashboards.

Responsabilidades

• Lead design and implementation of PowerBI dashboards.
• Gather requirements from stakeholders and translate them into reports.
• Use Azure services to speed up data product delivery.

Conocimientos

MS SQL expertise

PowerBI reporting

Data analysis

DAX calculations

Data modeling principles

Herramientas

Power BI

Azure ADLS

Azure Data Factory

PowerApps

Descripción del empleo

Overview

The Data Analyst position is responsible for the collection and analysis of data to support strategic initiatives and operational decision making. This position will work closely with business stakeholders to understand their needs and transform those into comprehensive reporting solutions. The ideal candidate will take ownership of the reporting pipeline, empower internal business partners, and provide a foundation to help The Lakefield Veterinary Group make data driven decisions. Successful candidates will have strong engineering, communication and knowledge in on-prem SQL Server and Azure data systems. They will also have the desire to dive into the complexity of our business and navigate both relationships and process. Familiarity with common cloud data tools, best practices, and experience with PowerApps is a plus.

Responsibilities

• Lead the design, implementation, and support of PowerBI dashboards and reports.
• Work closely with business stakeholders to gather requirements and translate them into reports that drive operational efficiencies.
• Use Azure services such as Azure ADLS, Event Hub, Data Factory, and Purview to improve and speed up the delivery of our data products and services.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery and reliability.
• Communicate technical concepts to non-technical audiences both in written and verbal form.
• Develop and refine dashboards and data visualizations in Power BI to measure KPIs.
• Analyze and document business requirements and data specifications.
• Identify and analyze issues and problems, determine root cause, report on problem status and resolution.
• Support development of end user training and reference materials.
• Develop technical solutions and documentation reflecting data design and mapping.

Required Qualifications

• 2+ years’ experience working in MS SQL with a proven ability to write efficient queries.
• 3+ years’ experience in an Analyst role creating reports and dashboards in PowerBI.
• Ability to assess performance and tune performance of queries and dashboards.
• Expertise in creating complex DAX calculations.
• Experience with data modeling principles like star schema and dimensional modeling.

Desired Qualifications

• Experience programing in additional languages such as Python and C#.
• Experience creating Microsoft PowerApps.
• Solid understanding of data architecture and BI best practice principles.

Work Type

In-Office / Hybrid (Candidate must reside in the state of Washington)

Benefits

• PTO
• Employee Assistance
• 401(K)
• Medical
• Dental
• Vision
• Voluntary Life and AD&D insurance, long-term care, Accident, Critical Illness, and Hospital Indemnity Employer Paid Life and AD&D
• Employer Paid STD and LTD
• Bonuses based on Individual and Company Performances
• Compensation Range: $90,000 - $105,000 USD

Seniority Level

Mid-Senior level

Employment Type

Full-time

Job Function

Business Development and Sales

Industries

Veterinary Services