Data Engineer

84604AD - Administration, Exempt Jobs

We are seeking a hard-working, innovative, detail-oriented and creative team player to join our Aptive team! This is a full-time Data Engineer position located in Provo, UT. This is a hybrid position (in-office and work from home). The individual we are looking for is also someone that enjoys working in a team environment, and excels working at an individual level.

What we offer:

• Salaried compensation

• Hybrid work location

• Annual Merit bonuses

• Group Health, Dental, and Vision plans

• Pet insurance, Life insurance, and EAP benefits

• 401K with employer match up to 4%

• Paid holidays and paid time off

• Opportunity for advancement

• Upbeat and exciting company culture and much more!

Responsibilities:

• Design and implement end-to-end data migration pipelines for M&A integrations, ensuring data integrity and validation

• Develop and maintain Airflow data pipelines for extracting, transforming, and validating data across systems

• Build standardization and normalization scripts to ensure consistent data structure post-migration

• Create robust validation processes to identify and document data discrepancies between systems

• Collaborate with IT, M&A teams, and external vendors to coordinate data migrations

• Build observability tools to monitor data quality, completeness, and accuracy

• Implement and maintain documentation for data engineering processes

• Optimize database performance through proper configuration of clustering keys and materialization strategies

• Troubleshoot and resolve data integration issues using systematic debugging approaches

Minimum Qualifications:

• 3+ years of experience in data engineering

• Strong proficiency with AWS services (Lambda, S3, Secrets Manager) and cloud architecture

• Advanced SQL skills with experience in query optimization

• Experience with Python, including type hints and functional programming principles

• Hands-on experience with Airflow (versions 1.10.15 and 2.9)

• Familiarity with dbt for data transformation and testing

• Experience with version control systems (GitHub) and CI/CD pipelines

• Understanding of data validation techniques and processes

• Experience using AI tools and LLMs to automate routine data tasks and improve workflow efficiency

Preferred Qualifications:

• Experience with Snowflake and its optimization techniques

• Experience with CRM data migrations or integrations

• Knowledge of M&A data integration processes

• Bachelor's degree in Computer Science, Information Technology, or related field

• Data engineering certifications (AWS, Snowflake, etc.)

• Experience with API integrations and external vendor collaborations

• Understanding of data governance and compliance requirements

• Experience with scripting for data normalization and standardization

• Advanced expertise in leveraging AI tools for code generation, documentation creation, and data pipeline optimization

• Ability to craft effective prompts for AI assistants to enhance productivity in data engineering workflows

Additional Information:

The Data Engineer will join a team dedicated to building reliable, fast, and cost-efficient data pipelines that support all aspects of our business operations. You'll develop scalable and maintainable data systems using our Snowflake/AWS/Airflow/dbt stack while adhering to rigorous engineering practices. This role requires a systematic approach to planning, implementation, validation, and problem resolution across diverse use cases - from business intelligence to operational analytics and occasional M&A integrations. Your focus will be on creating robust data infrastructure that maintains high standards for data governance, quality, and security while ensuring timely delivery of insights to stakeholders throughout the organization.

Aptive Environmental:

Aptive Environmental provides pest control services to 34 states in the US. Co-founded in 2015 by Vess Pearson and David Royce, Aptive launched with the clear intention of becoming a world-recognized brand.

In 2021, Aptive was included in Inc. Magazine’s "Best in Business" list of companies that make a positive impact. Aptive is also featured on Glassdoor's 2019 list of Top 100 US workplaces and is ranked one of Entrepreneur Magazine's Best Companies in America. We are a proud member of the EPA's Pesticide Environmental Stewardship Program and have partnered with the United Nations Foundation’s "United to Beat Malaria" to help stop the spread of malaria transmitted by mosquito bites.

*Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice. If you require reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please inform your recruiter.