BI Data Engineer

1 week 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

    2 weeks 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...

  • Business Analyst-Asset Data

    36 minutes ago

    Burlington, Ontario, Canada DLL Full time

    Job DescriptionBusiness Analyst – Asset Data & ReportingYou will implement the asset data strategy, and as such connect with all DLL countries to develop both the quantity and quality of Asset Data. You will gather data requirements for monitoring and performance dashboards for Asset Management and Asset Sales globally. You will specify these requirements...

  • Senior Data Strategist

    4 days 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...

  • Senior Data Strategist

    59 minutes 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...

  • HR Data Analytics Specialist

    2 weeks ago

    Burlington, Ontario, Canada Quadra Full time

    Position: HR Data Analytics SpecialistLocation: Ontario (Burlington or Oakville)Workplace Flexibility: We have a hybrid policy where we require a presence in office of minimum 2 days / week.Status: 12-months contract – Maternity Leave Replacement Are you passionate about turning data into meaningful insights that drive better people decisions? We are...

  • HR Data Analytics Specialist

    2 weeks ago

    Burlington, Ontario, Canada Quadra Full time

    Position: HR Data Analytics SpecialistLocation: Ontario (Burlington or Oakville) or Vaudreuil-Dorion, QCWorkplace Flexibility: We have a hybrid policy where we require a presence in office of minimum 2 days / week.Status: 12-months contract – Maternity Leave Replacement Are you passionate about turning data into meaningful insights that drive better...

  • Senior Data Strategist

    1 day ago

    Burlington, Ontario, Canada TransUnion Full time US$98,000 - US$147,000

    TransUnion's Job Applicant Privacy NoticeWhat 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...

  • IT - Manufacturing Applications Intern

    1 day ago

    Burlington, Ontario, Canada Opta Group Full time

    ABOUT OPTA From our roots providing sand to local foundries in the 1880's, Opta has grown to an international group of companies committed to delivering optimal results for our customers. Opta's purpose is to create solutions that enhance productivity and set new standards for industrial performance. Our mission is to consistently deliver custom-engineered...

  • Deployment Engineer

    5 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...

  • Business Intelligence

    1 week ago

    Burlington, Ontario, Canada American Excelsior Company Full time

    Department:ITEmployment Type:Full TimeLocation:Corporate OfficeReporting To:Adam OlsonCompensation:$ $33.00 / hourDescriptionPosition SummaryThis role combines business intelligence development, database support, and Tier-1 IT assistance. The primary focus is building and maintaining Power BI dashboards, developing SQL-based data models, and ensuring clean,...