BI Data Engineer

6 days ago

Burlington, Ontario, Canada Lakefield Veterinary Group Full time

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

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

  • Azure Data Factory

    1 week ago

    Burlington, Ontario, Canada BURGEON IT SERVICES Full time

    Job Title:Technology Specialist – Cloud Integration (ADF)Location:Burlington, NJ Fully Remote)Contract Duration:12 Months plus only on w2Please share me the resumes atJob DescriptionWe are seeking an experiencedAzure Data Factory (ADF) & Informatica PowerCenter Developerwith strong cloud integration experience. The ideal candidate will design and build...

  • Senior Data Strategist

    3 days ago

    Burlington, Ontario, Canada TransUnion Full time

    TransUnion's Job Applicant Privacy Notice What We'll Bring:At TransUnion, we are dedicated to finding ways information can be used to help people make better and smarter decisions. As a trusted provider of global information solutions, our mission is to help people around the world access the opportunities that lead to a higher quality of life, by helping...

  • Senior Data Strategist

    16 hours ago

    Burlington, Ontario, Canada TransUnion Full time

    TransUnion's Job Applicant Privacy NoticeWhat We'll BringAt TransUnion, we are dedicated to finding ways information can be used to help people make better and smarter decisions. As a trusted provider of global information solutions, our mission is to help people around the world access the opportunities that lead to a higher quality of life, by helping...

  • Deployment Engineer

    1 week ago

    Burlington, Ontario, Canada Evertz Microsystems Limited Full time

    The Deployment Engineer is the Evertz product expert whose role is to ensure that their respective product or products are being developed, configured and deployed in the most optimal way possible for any given project. The Deployment Engineer will work between Principal Architects, Evertz clients, R&D engineers and project managers to understand the needs...

  • Deployment Engineer

    4 days ago

    Burlington, Ontario, Canada Evertz Microsystems Limited Full time

    The Deployment Engineer is the Evertz product expert whose role is to ensure that their respective product or products are being developed, configured and deployed in the most optimal way possible for any given project. The Deployment Engineer will work between Principal Architects, Evertz clients, R&D engineers and project managers to understand the needs...

  • Deployment Engineer

    6 days ago

    Burlington, Ontario, Canada Evertz Full time

    The Deployment Engineer is the Evertz product expert whose role is to ensure that their respective product or products are being developed, configured and deployed in the most optimal way possible for any given project. The Deployment Engineer will work between Principal Architects, Evertz clients, R&D engineers and project managers to understand the needs...

  • Deployment Engineer

    6 days ago

    Burlington, Ontario, Canada Evertz Microsystems Limited Full time

    The Deployment Engineer is the Evertz product expert whose role is to ensure that their respective product or products are being developed, configured and deployed in the most optimal way possible for any given project. The Deployment Engineer will work between Principal Architects, Evertz clients, R&D engineers and project managers to understand the needs...

  • Deployment Engineer

    6 days ago

    Burlington, Ontario, Canada Evertz Microsystems Limited Full time $45,000 - $50,000

    The Deployment Engineer is the Evertz product expert whose role is to ensure that their respective product or products are being developed, configured and deployed in the most optimal way possible for any given project. The Deployment Engineer will work between Principal Architects, Evertz clients, R&D engineers and project managers to understand the needs...

  • Production Engineer

    1 week ago

    Burlington, Ontario, Canada Evertz Microsystems Limited Full time

    Production Engineers are responsible for validating industry leading broadcast and AV solutions at a modular and system level. Candidates should be ready to be challenged in an ever-changing industry. Be on the forefront of the latest cutting edge technologies in traditional broadcast, broadcast SDN and ProAV tech spaces. Take pride knowing you have a...

  • Production Engineer

    1 week ago

    Burlington, Ontario, Canada Evertz Microsystems Limited Full time

    Production Engineers are responsible for validating industry leading broadcast and AV solutions at a modular and system level.  Candidates should be ready to be challenged in an ever-changing industry.Be on the forefront of the latest cutting edge technologies in traditional broadcast, broadcast SDN and ProAV tech spaces.  Take pride knowing you have a...