Covetrus is a global animal-health technology and services company dedicated to empowering veterinary practice partners to drive improved health and financial outcomes. We are bringing together products, services, and technology into a single platform that connects our customers to the solutions and insights they need to work best. Our passion for the well-being of animals and those who care for them drives us to advance the world of veterinary medicine. Covetrus has more than 5,500 employees, serving over 100,000 customers around the globe.SummaryThe Senior Data Architect partners with various lines of business, information technology, engineering and operations to develop data-oriented solutions that support enterprise platforms. Develop semantic data layer that supports real-time data exchange between external and internal applications, and integration of data warehouse and existing operational processes. The Senior Data Architect will also be involved in developing the governance of business processes and data architecture, ensuring that all fields and mappings contain complete, well-formed and accurate definitions and the design structure aligns with the best practices of the given component.Essential Duties And Responsibilities
Create and implement the future state data architecture that aligns with business and IT strategy.
Development of a reliable and scalable data pipeline and processes to support data integration with servicing applications.
Maintain and publish architecture documents including data model diagrams, data dictionary, and mapping documents, data integration coding standards and other technical specifications. Ensures existing data assets are identified, stewarded and leveraged across the enterprise.
Participate in projects and work to ensure quality implementations using agile methodology including gathering requirements, gaining business consensus, assist in performing vendor and product evaluations and assistance in delivering solutions, training, and documentation.
Actively contribute to improving the Enterprise Architecture by closely cooperating with Enterprise Architecture and other IT leaders.
Support the processes to identify, capture and store data in the various databases.
Produce database/architecture documentation and technical specifications for the ETL programs to implement data warehouse and BI platforms.
Evaluate existing ETL and other data integration processes for poorly performing, unnecessarily complex, difficult to maintain, or unstable processes. Develop refactoring solutions to streamline and simplify where possible and effectively communicate with both technical and non-technical team members.
Develops specific metrics and control procedures for data quality and consistency.
QUALIFICATIONS: EDUCATION AND/OR EXPERIENCE
Bachelor’s Degree in Computer Science, Information Technology or related field required.
6+ years of professional Data Architecture experience
Competencies (skills And Abilities)
Advanced level of SQL and/or Stored Procedures programming and troubleshooting.
Served as data modeler, data architect, or related database management positions and developed expertise in master data management, data warehouse, and data integration areas.
5+ years of experience in logical/physical dimensional data modeling. In-depth knowledge of database structures for data warehouse, data mart, operational data store, and the related ETL and reporting procedures.
Production experience with Snowflake, including Snowpipe, Stages/Pipes, File Ingestion Formats.
Familiarity or experience with the Data Vault 2.0 specification is preferred.
Production experience with Json, Avro and Parquet is preferred.
2+ years of experience with AWS, most notably S3, IAM roles, RDS MySQL
Experience working with data analysts and data engineers for SQL development, troubleshooting and performance tuning.
Jira or Azure DevOps and other agile development software experience is preferred.
Broad understanding of strategy and architecture modeling standards and how to interface with other systems.
Must have excellent communication skills, including the ability to collaborate with business stakeholders and converse clearly with a business vocabulary.
PHYSICIAL DEMANDS/WORK ENVIRONMENTThe physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.Covetrus is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.Jobs that are in Colorado:If you are a Colorado applicant, you are eligible to receive information about the salary range and benefits for this role. Please firstname.lastname@example.org