Data Engineer

Company Description

Alliance 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 Description

Does 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 Responsibilities 

• Familiar with data integration and ETL pipelines using Redshift/S3 and data lake best practices 

• Outlining 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 transition 

• Overseeing the integration of new technologies and initiatives into data standards and structures  

• Translating business requirements into technical specifications, including data streams, integrations, transformations, databases, and data warehouses 

• Evaluating the design, selection, and implementation of new databases or database changes and recommending optimal data solutions for the organization 

• Creating systems to keep data secure and ensuring data and information security by integrating and upholding digital security systems  

• Designing, developing, and modifying data infrastructure to accelerate the processes of data analysis and reporting  

• Publishing and/or presenting reports, timeline updates, or recommendations 

• Identifying areas for improvement in current systems 

• Coordinating with other team members to reach project milestones and deadlines 

• Auditing databases regularly to maintain quality 

• Ingest new practices to our portfolio to map and connect them appropriately to our data environment 

• Educate staff members through training and individual support 

Qualifications

Desired experience 

• 2+ years of experience in a data architecture and/or engineering  

• Strong competence in/with database technologies: AWS Redshift, Snowflake, SQL Server, ETL (AWS), Amazon S3, SQL, Python. 

• Data Visualization and Reporting experience: Tableau  

• Preferred experience in working with 3rd parties who manage MDM layers 

• Preferred prior experience in a startup environment or client-facing/consulting experience  

This 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 terms  

• In-depth understanding of modern database and information technologies  

• Excellent time management skills and the ability to work towards meeting multiple deadlines simultaneously  

• Hands-on aptitude with a willingness to troubleshoot and solve complex problems 

• Intellectual curiosity to discover new approaches and insights 

• Ability to collaborate cross functionality and function effectively as an individual leader 

• Strong attention to detail 

Additional Information

The 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