Principle Data Architect, Data Integration Hub

As Principle Data Architect, you will drive the vision and create the architecture for data solutions, ensuring access, performance, and security of data systems and applications, aligning data architecture with overall enterprise architecture, and maintaining extensive knowledge of databases and their relation to business operations. You will translate strategic requirements into a usable enterprise data framework and guide data solutions development while facilitating consistent data design, optimization, archiving, and recovery strategy.Our team includes a range of data engineers, data architects, and data-centric business system analysts, focusing heavily on cloud-based "big data" projects. Some team members provide knowledge and support over our traditional data warehouse applications, building upon these environments with SQL and traditional ETL methods. At the same time, our newest technology expands our data models via Snowflake, bringing the best of cloud scale and compute capabilities and long-lived data engineering practices.Our stack: AWS (S3, EMR, Glue, DocumentDB, DynamoDB, OpenSearch), Snowflake, Oracle, MySQL, Python, Scala, Terraform, gitIn this role:• You will develop and maintain the overall system's technical architecture• You will collaborate with technology and management teams to understand structural requirements and define standards for storing, consuming, integrating, and managing data across the organization and translating it into a usable blueprint• You will build an inventory of data needed to implement the architecture and create a vision for how data will flow through the organization• You will design and build complex data models and approve modifications to and implement systems• You will implement measures to ensure data accuracy and accessibility, constantly monitoring and refining the performance of data management systems.• You will produce and enforce database development standards• You will provide architectural design and planning of technical activities, including application architecture, system landscape, installation sizing and planning, system change management, performance monitoring, performance tuning, troubleshooting, problem analysis, and problem resolution• You will ensure interoperability at the data level across a full range of relevant Company products and services• You will ensure data integrity and the data's strategic value is understood and practiced throughout the Company• You will mentor other development and business teams on data architecture design and requirements• You will manage incoming technical requests and design systems for optimum performance; proactively identify potential problems; create and modify strategies to resolve problems; document issues and resolutions• You will maintain descriptions of data, structures, and metadataWhat you will need to succeed:• You have experience as Data Engineer, ETL developer, or report metadata designer• You can build distributed and cloud-based data pipeline architectures• Your tech stack includes SQL-based technologies like Oracle, PostgreSQL, and MySQL, NoSQL technologies like Cassandra and MongoDB and of course Python• You are familiar with industry-standard entity relationship modeling software• You are good at analyzing and solving problems• You are an excellent communicator, both in writing and verbally• You are driven and take the initiative• You have skills in:• Data and information modeling for relational, semi, and non-structured datasets• General DevOps, such as building infrastructure and CI/CD pipelines• Development management• You have a solid understanding of:• Data warehousing solutions• Data distribution service models and methods, including API-based publish and subscribe architectures• Software development lifecycle, including internal enterprise projects and commercialized software products• You know how to:• Understand business requirements and translate them into conceptual, logical, and physical models• Articulate and define architectural patterns for data pipelines and ecosystems resilient to growth and change• Use SQL to examine data and load or modify data in relational tables• Use Python or equivalent high-level language to review, load, or modify data in relational tables• Create reusable scripts to implement, load, and test physical models• Multi-task, prioritize, and meet deadlinesWhy 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.Let’s pursue what matters together.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.What you can expect from us:• Base annual salary target: $170,000-190,000 (yes, we do have flexibility if needed)• Opportunity for annual cash bonus and equity package• 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!#LI-REMOTE