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