Senior Data Engineer at MedVet

Job description

MedVet is the leading veterinarian owned and led network of specialty and emergency hospitals and dedicated to delivering exceptional care and a deeply supportive experience to pets and their loving families, referring veterinarians, and our team members. Reporting directly to the Director of Data & Analytics, the Senior Data Engineer will provide technical leadership in designing, building, and supporting scalable enterprise data solutions that enable analytics, reporting, and business decision-making. This role is accountable for the architecture, development, and ongoing evolution of data warehouse structures, data models, ETL/ELT pipelines, and governed data products using Microsoft Fabric and related Microsoft data platform tools. The Senior Data Engineer partners with analytics, IT, and business stakeholders to define data strategy and requirements, establish engineering standards, guide technical decisions, and ensure data is accurate, secure, scalable, and ready for reporting and advanced analytics. Responsibilities include, but are not limited to • Lead the design, development, and maintenance of scalable data pipelines, lakehouse solutions, and data warehouse structures that support enterprise analytics and reporting needs. • Define and guide data architecture and workflow patterns that align operational source systems, curated data layers, semantic models, and enterprise data warehouse standards. • Lead the development and optimization of complex ETL/ELT processes, data ingestion patterns, transformations, and orchestration workflows using Microsoft Fabric, SQL, pipelines, notebooks, and related tools. • Own the design and maintenance of dimensional models, fact and dimension tables, data marts, and reusable analytics-ready datasets for Power BI and other reporting platforms. • Establish and enforce data quality checks, validation routines, reconciliation processes, and governance standards to ensure trusted and consistent data delivery. • Develop, review, tune, and troubleshoot advanced SQL, Spark SQL, and/or PySpark code to support complex data transformation, warehouse performance, and reporting needs. • Proactively monitor, diagnose, and improve the performance, reliability, and cost efficiency of pipelines, warehouse queries, semantic models, scheduled refreshes, and data processing workflows. • Serve as a senior technical partner to analysts and business stakeholders, translating complex reporting and analytics requirements into reliable data structures and reusable data products. • Document data lineage, source-to-target mappings, technical specifications, test scripts, policies, and support procedures. • Collaborate with IT, reporting, analytics, and operational teams to support secure, governed, and scalable data solutions. • Provide technical guidance, peer reviews, and mentoring to data engineers and analytics team members; promote engineering standards, reusable patterns, and continuous improvement. • Continually evolve MedVet’s data platform, data warehouse, and data engineering practices to support a data-driven organization. Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa for this position at this time. Knowledge, Skills, and Abilities Our ideal candidate has a minimum of 7 years of progressive experience in data engineering, data warehouse architecture, data modeling, or data platform development, including experience leading complex technical initiatives and influencing engineering standards. • Advanced hands-on experience with Microsoft Fabric, Microsoft data platform tools, cloud data architecture, and business intelligence environments is required. • Experience in the healthcare and/or veterinary industry is a plus but not required. In addition, this position requires: • Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field, or an equivalent combination of education and experience • Expert knowledge of data warehouse concepts, dimensional modeling, relational data modeling, ETL/ELT patterns, cloud data architecture, and scalable analytics platform design • Demonstrated ability to communicate complex technical concepts, influence architecture decisions, and build alignment with technical and non-technical stakeholders in both verbal and written formats • Strong analytical, problem-solving, systems-thinking, and technical decision-making skills, with the ability to resolve ambiguous and complex data challenges • Ability to work independently, but maintain active and timely communication with the requestor in a fast-paced environment • Ability to manage multiple projects and adjust priorities as necessary Required Technical Skills • Microsoft Fabric, including Data Factory pipelines, Lakehouse, Warehouse, OneLake, notebooks, and semantic model integration • Advanced SQL, data modeling, data warehouse design, ETL/ELT development, and performance optimization Preferred Technical Skills • Power BI, Azure Data Factory, Azure Synapse, Databricks, Python/PySpark, Spark SQL, Git/Azure DevOps, APIs, and cloud data platform experience • Proficient with leveraging AI and generative AI tools (e.g., Copilot, Claude, ChatGPT) to augment data analysis, automate workflows, and improve productivity. Perks and Benefits include:   • Comprehensive Health Benefits  • Vision and Dental  • 401k with Employer Match  • Paid Time Off (PTO) • Employee Pet Discounts • Elective Short-Term Disability • Life and Accident Insurance The posted range for this position is $130,000-$190,000. which is the expected starting base salary range for an employee who is new to the role to fully proficient in the role. Many factors go into determining employee pay within the posted range including prior experience, current skills, location/labor market, internal equity, etc. Come as you are. MedVet is an equal opportunity employer. We are also a drug-free organization; therefore, employment with MedVet is dependent upon the passing of a drug screen and background check. MedVet does not accept unsolicited resumes from third-party recruiters.

Requirements

Must-haves

Responsibilities include, but are not limited to
Lead the design, development, and maintenance of scalable data pipelines, lakehouse solutions, and data warehouse structures that support enterprise analytics and reporting needs.
Define and guide data architecture and workflow patterns that align operational source systems, curated data layers, semantic models, and enterprise data warehouse standards.
Lead the development and optimization of complex ETL/ELT processes, data ingestion patterns, transformations, and orchestration workflows using Microsoft Fabric, SQL, pipelines, notebooks, and related tools.
Own the design and maintenance of dimensional models, fact and dimension tables, data marts, and reusable analytics-ready datasets for Power BI and other reporting platforms.
Establish and enforce data quality checks, validation routines, reconciliation processes, and governance standards to ensure trusted and consistent data delivery.
Develop, review, tune, and troubleshoot advanced SQL, Spark SQL, and/or PySpark code to support complex data transformation, warehouse performance, and reporting needs.
Proactively monitor, diagnose, and improve the performance, reliability, and cost efficiency of pipelines, warehouse queries, semantic models, scheduled refreshes, and data processing workflows.
Serve as a senior technical partner to analysts and business stakeholders, translating complex reporting and analytics requirements into reliable data structures and reusable data products.
Document data lineage, source-to-target mappings, technical specifications, test scripts, policies, and support procedures.
Collaborate with IT, reporting, analytics, and operational teams to support secure, governed, and scalable data solutions.
Provide technical guidance, peer reviews, and mentoring to data engineers and analytics team members; promote engineering standards, reusable patterns, and continuous improvement.
Continually evolve MedVet’s data platform, data warehouse, and data engineering practices to support a data-driven organization.
Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa for this position at this time.
Knowledge, Skills, and Abilities
Advanced hands-on experience with Microsoft Fabric, Microsoft data platform tools, cloud data architecture, and business intelligence environments is required.
Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field, or an equivalent combination of education and experience
Expert knowledge of data warehouse concepts, dimensional modeling, relational data modeling, ETL/ELT patterns, cloud data architecture, and scalable analytics platform design
Demonstrated ability to communicate complex technical concepts, influence architecture decisions, and build alignment with technical and non-technical stakeholders in both verbal and written formats
Strong analytical, problem-solving, systems-thinking, and technical decision-making skills, with the ability to resolve ambiguous and complex data challenges
Ability to work independently, but maintain active and timely communication with the requestor in a fast-paced environment
Ability to manage multiple projects and adjust priorities as necessary

Nice-to-haves

Experience in the healthcare and/or veterinary industry is a plus but not required.
Preferred Technical Skills

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlazurepythonaigo

Platform: jobvite
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401k

Pto

Paid Time Off