Company DescriptionAlliance Animal Health is a fast-growing, private equity backed Veterinarian Service Organization that operates as a majority owner and business partner to many veterinarian practices across the US. Our goal is to make it easier for our practices at every step by providing world-class business solutions like talent acquisition, marketing, human resources, finance, and operations, so that they can focus their energy on providing incredible care for animals. In fact, our Core Values are (quite literally) written with PETS in mind: Passion, Engagement, Trust and Service.We want our doctor partners to choose what's best for their practice because they are the experts in medicine, while we customize the support, the co-ownership approach, and business solutions based on their goals. We pride ourselves on maintaining a culture of open communication and collaboration to deliver innovative solutions to advance today’s veterinary environment - without disrupting the medical autonomy and what makes each of our hospitals unique. Because at the end of the day, our central support team exists to serve our practices. So, if you’re excited about using your talents to make an impact on the health and wellness of pets - we’d love to talk with you!Job DescriptionDoes managing data hygiene make you smile? Does architecting and loading a wide set of data sources to a single source of truth warehouse make your heart sing? Do you love animals? Then this is the role for you!This is the perfect opportunity for someone to drive and lead our data ecosystem for the company. This individual will partner closely with stakeholders across the organization and through external vendors to develop our data environment that powers and creates a single source of truth for all departments.Your duties would include identifying our internal and external data sources, collaborating with department heads to determine their data storage and organizational needs, and using the information to create and maintain data infrastructure. You will be developing, optimizing, and maintaining our data systems including implementing APIs for accurate data extraction, ensuring data security, monitoring the system, ensuring data cleanliness and hygiene, maintaining our data dictionary, and supervising system migrations.The ideal candidate will thrive in a fast-paced, entrepreneurial environment with a no-job-too-big or small attitude. They will have a mix of inquisitiveness, learning agility, emotional intelligence, and drive for success.Key ResponsibilitiesFamiliar with data integration and ETL pipelines using Redshift/S3 and data lake best practicesOutlining data flows, i.e., which parts of the organization generate data, which require data to function, how data flows are managed, and how data changes in transitionOverseeing the integration of new technologies and initiatives into data standards and structuresTranslating business requirements into technical specifications, including data streams, integrations, transformations, databases, and data warehousesEvaluating the design, selection, and implementation of new databases or database changes and recommending optimal data solutions for the organizationCreating systems to keep data secure and ensuring data and information security by integrating and upholding digital security systemsDesigning, developing, and modifying data infrastructure to accelerate the processes of data analysis and reportingPublishing and/or presenting reports, timeline updates, or recommendationsIdentifying areas for improvement in current systemsCoordinating with other team members to reach project milestones and deadlinesAuditing databases regularly to maintain qualityIngest new practices to our portfolio to map and connect them appropriately to our data environmentEducate staff members through training and individual supportQualificationsDesired experience2+ years of experience in a data architecture and/or engineeringStrong competence in/with database technologies: AWS Redshift, Snowflake, SQL Server, ETL (AWS), Amazon S3, SQL, Python.Data Visualization and Reporting experience: TableauPreferred experience in working with 3rd parties who manage MDM layersPreferred prior experience in a startup environment or client-facing/consulting experienceThis role must be familiar with database design and systems, database technology, and logical data analysis. To succeed, you will also need additional skills and qualifications, including:Excellent communication skills to translate complex problems using non-technical termsIn-depth understanding of modern database and information technologiesExcellent time management skills and the ability to work towards meeting multiple deadlines simultaneouslyHands-on aptitude with a willingness to troubleshoot and solve complex problemsIntellectual curiosity to discover new approaches and insightsAbility to collaborate cross functionality and function effectively as an individual leaderStrong attention to detailAdditional InformationThe anticipated starting base salary for applicants expressing interest in this role ranges around $110,000 - $120,000/yr. We also offer a robust set of medical, non-medical and retirement benefits that we encourage our employees to take advantage of.We want nothing more than to fuel your career goals, which is why we’ve created exclusive programs like Alliance Educates, Alliance Propel and Alliance Cares - to bring you financial, learning and wellness opportunities designed to enrich your growth.WE ARE A DRUG-FREE, EQUAL OPPORTUNITY EMPLOYER.Company Policy & Federal & State Laws Forbid Discrimination Because of Age, Color, Race, Religion, Sex, Disability, Sexual Orientation or National Origin
