Skip to content

Analytics Engineer

United Veterinary Care LogoUnited Veterinary Care
View Organization

The Analytics Engineer will own data modeling and transformation within the UVC data warehouse, as well as contribute to data ingestion processes and BI reporting initiatives. A key weighted member of the Business Intelligence team serves as a strategic partner in the BI team’s growth for the future.

Essential Duties and Responsibilities

  1. Develop and maintain SQL transformation pipelines (via DBT) including change management, testing, and modeling best practices.
  2. Test, monitor, and report on data health and data quality.
  3. Ensure all data tables are loaded efficiently and are using correct and consistent KPI logic.
  4. Collaborate with rest of business intelligence team to ensure timely delivery of BI initiatives.
  5. Working closely with Director of BI to execute on the strategic vision for UVC BI.
  6. Supporting the data warehouse in identifying and revising requirements.
  7. Troubleshooting the reporting database environment and reports.
  8. Contribute to the design and implementation of Power BI reports from single or multiple systems.
  9. Contribute to the documentation of data assets.

Qualifications/Requirements

  1. Bachelor’s Degree or combination of education and experience required.
  2. Expert/Advanced proficiency in SQL required.
  3. Intermediate proficiency in data modeling required.
  4. Experience using python for data related tasks.
  5. Exposure to using DBT to transform data.
  6. Some proficiency in Power BI preferred but not required.
  7. Some proficiency in Azure Data Factory a plus but not required.
  8. 3-5 years of relevant experience in a multisite business preferred.
  9. Excellent verbal and written communication skills and respond both promptly and diplomatically.
  10. Strong interpersonal communication skills, writing skills, relationship-building skills, and an ethical mindset.
  11. Ability to present complex information to all levels of the organization including the executive team.
  12. Keen sense of prioritization with the ability to multitask and meet deadlines in a fast-paced environment.

Core Competencies:

1. Attitude – demonstrate a positive attitude, resilience, and openness to change. Adapt your approach as requirements of a situation change, be comfortable in ambiguous situations and work effectively with various individuals or groups of diverse backgrounds and experiences.

2. Judgement – use professional experiences to make assessments of facts, data, credibility, and situations. Applies professional knowledge to analyze issues, clarify positions and determine workable options or reach reasoned decisions. Applies sound judgement with assessment of credibility.

3. Teamwork – the ability to develop, maintain, and strengthen partnerships with others inside and outside of the organization, while providing information, assistance, and support. Seek to understand and build on differing perspectives of others; fostering collaboration and teamwork, enhance team effectiveness, ensure alignment, proactively assist, involve, and support others, resolve conflict, build bridges and collaboration between teams. Empower other team members with confidence to be successful, especially at challenging new tasks, delegate significant responsibility and authority, while allowing team members freedom to decide how they will accomplish goals and resolve issues.

4. Results – maintain focus on key performance drivers, continuously improve processes, and consistently deliver results. Apply strategic thinking to organizational and business perspectives to identify and focus on key drivers of organizational performance and results that are scalable.

‌