Principal Data Architect

IDEXX; Westbrook (ME); On-site; USD 115,000 - 157,000; Full time

Benefits offered by this job

Health/Dental/Vision day-one

Annual cash bonus

401k matching 5%

Stock program

Volunteer paid days off

Foundation donation matching

Pet insurance

Job summary

IDEXX is seeking a Principal Data Architect who will shape the VetSoft Analytics data architecture and lead the team that builds it. You will own end-to-end data movement from source systems through pipelines to curated data products powering dashboards, self-service analytics, and AI agents.

Collaborating with Product, Engineering, Sales, Marketing, and Finance, you will set standards, governance, and cost-efficient patterns at scale, while growing a high-impact engineering team.

Qualifications

• 7+ years in data engineering, warehousing, or architecture with leadership experience.
• Expert SQL and hands-on dbt transformations with strong data modeling.
• Cloud data warehousing (Snowflake preferred) and modern ELT/orchestration tooling.

Responsibilities

• Oversee end-to-end data pipeline landscape (ELT) and ensure reliable delivery.
• Lead design/build of the dbt transformation layer with documented models.
• Deliver curated data sets for BI and AI with consistent definitions.
• Translate business requirements into scalable data models.
• Enforce engineering standards: code review, CI/CD, testing, docs.
• Own data governance: lineage, quality, metadata, and PII policies.

Skills

SQL

Python

dbt

Data modeling

Leadership

Data governance

ELT

Tools

Snowflake

Sigma

AWS

Airflow

dbt

Job description

IDEXX is seeking a Principal Data Architect that will drive the vision for the VetSoft Analytics Team’s data architecture and lead the team that builds it. You will own how data moves from source systems through our pipelines and transformation layer into curated, reporting-ready data products that power executive dashboards, self-service analytics, and AI agents. Partnering with stakeholders in Product, Engineering, Sales, Marketing, and Finance, you will set the standards, patterns, and governance that make VetSoft data trustworthy, performant, and cost-efficient at scale.

Why This Role Matters

Your architecture decisions won't just move data, they'll shape how confidently our leaders, sales, and product teams can act on it. As the technical backbone of the VetSoft Analytics Team, the standards and models you set will support every dashboard, self-service report, and AI agent across the business. You'll have the rare opportunity to build this practice from a position of real influence, growing a team while your work directly powers how IDEXX serves veterinary practices and pet owners worldwide.

In this Role

• Oversee the end-to-end data pipeline (ELT) landscape, from ingestion of disparate source systems through orchestration, scheduling, and monitoring, ensuring reliability and timely delivery.
• Lead the design and build-out of the transformation layer in dbt, establishing modular, tested, and well-documented models along with conventions for structure, testing, and deployment.
• Design and deliver curated, reporting-ready data sets that BI tools (Sigma) and AI agents can query with confidence, with consistent business definitions, documented grain, and dependable semantics.
• Partner with cross-functional teams to understand business workflows and translate requirements into conceptual, logical, and physical data models that scale with growth and change.
• Establish and enforce engineering standards for the data platform, including code review, version control, CI/CD, automated testing, and documentation.
• Own data governance initiatives across the organization, including metadata management, data lineage, data quality monitoring, and PII policies, so stakeholders can access trustworthy, compliant, well-documented data assets.

What You Will Need To Succeed

• The ideal candidate will have 7+ years of experience in data engineering, data warehousing, or data architecture, including demonstrated success leading and developing engineering teams.
• Experience with SQL, Python, and DBT.
• Helpful to have experience with Snowflake, Sigma, AWS, Airflow.
• Expert-level SQL skills and hands‑on experience building transformations in dbt, with strong data modeling ability across relational, semi-structured, and unstructured data sets.
• Deep experience with cloud data warehousing platforms (Snowflake strongly preferred), modern ELT and orchestration tooling, and the performance tuning and compute cost optimization that keep them efficient. Python or an equivalent scripting language is a plus.
• A proactive, ownership-oriented mindset with excellent organizational and project management skills, intellectual curiosity, and a commitment to continuous improvement.

What You Can Expect From Us

• Base annual salary target: $115,000 - $157,000 (yes, we do have flexibility if needed)
• Opportunity for annual cash bonus
• Health / Dental / Vision Benefits Day-One
• 5% matching 401k
• Additional benefits including but not limited to financial support, pet insurance, mental health resources, volunteer paid days off, employee stock program, foundation donation matching, and much more!

Why IDEXX?

We’re proud of the work we do, because our work matters. An innovation leader in every industry we serve, we follow our Purpose and Guiding Principles to help pet owners worldwide keep their companion animals healthy and happy, to ensure safe drinking water for billions, and to help farmers protect livestock and poultry from diseases. We have customers in over 175 countries and a global workforce of over 10,000 talented people.

So, what does that mean for you? We enrich the livelihoods of our employees with a positive and respectful work culture that embraces challenges and encourages learning and discovery. At IDEXX, you will be supported by competitive compensation, incentives, and benefits while enjoying purposeful work that drives improvement. Did we mention that we are a dog-friendly office?

IDEXX values a diverse workforce and workplace and strongly encourages women, people of color, LGBTQ+ individuals, people with disabilities, members of ethnic minorities, foreign‑born residents, and veterans to apply.

IDEXX is an equal opportunity employer. Applicants will not be discriminated against because of race, color, creed, sex, sexual orientation, gender identity or expression, age, religion, national origin, citizenship status, disability, ancestry, marital status, veteran status, medical condition, or any protected category prohibited by local, state, or federal laws.

Let’s pursue what matters together.