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