Analytics Engineer

Position Overview The Analytics Engineer will own data modelling 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. This is a remote position.   Essential Duties and Responsibilities:
•Develop and maintain SQL transformation pipelines (via DBT) including change management, testing, and modeling best practices.
•Test, monitor, and report on data health and data quality.
•Ensure all data tables are loaded efficiently and are using correct and consistent KPI logic.
•Collaborate with rest of business intelligence team to ensure timely delivery of BI initiatives.
•Working closely with Director of BI to execute on the strategic vision for UVC BI.
•Supporting the data warehouse in identifying and revising requirements.
•Troubleshooting the reporting database environment and reports.
•Contribute to the design and implementation of Power BI reports from single or multiple systems.
•Contribute to the documentation of data assets.
Qualifications/Requirements:
•Bachelor’s Degree or combination of education and experience required.
•Expert/Advanced proficiency in SQL required.
•Intermediate proficiency in data modelling required.
•Experience using python for data related tasks.
•Exposure to using DBT to transform data.
•Some proficiency in Power BI preferred but not required.
•Some proficiency in Azure Data Factory a plus but not required.
•1-5 years of relevant experience in a multisite business preferred.
•Excellent verbal and written communication skills and respond both promptly and diplomatically.
•Strong interpersonal communication skills, writing skills, relationship-building skills, and an ethical mindset.
•Ability to present complex information to all levels of the organization including the executive team.
•Keen sense of prioritization with the ability to multitask and meet deadlines in a fast-paced environment. Physical Requirements:
•Frequent work at a computer for 90-100% of the time.
•Frequent to moderate noise level in the work environment.
•Frequent ability to carry our instructions furnished in written, oral or diagram form to solve problems involving several variables.
•Ability to stand, walk, stoop, kneel, crouch as well as manipulate (life, carry and move) up to 15 pounds.
•The physical requirements and work environment characteristics described here are representative of those that must be met by a team member to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. 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.
United Veterinary Care (UVC) is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, transgender status, national origin, citizenship, age, disability or military or veteran status, or any other legally protected status. UVC is an Equal Opportunity Employer. Minorities/Women/Veterans/Disabled.