Business Intelligence Engineer

We are looking to add a Business Intelligence Engineer to our Data team located in Provo. The Data Team is primarily responsible for enabling Aptive in making data-driven decisions. The focus of this role is to build and maintain Aptive’s “Source of Truth” database as well as our reporting suite. Your day-to-day will typically include writing complex SQL queries, contributing to our modern analytics & engineering pipeline, designing effective data visualizations, and communicating closely with a variety of stakeholders.

What we offer:

• Group Health, Dental, and Vision plans

• Pet insurance, Life insurance, and EAP benefits

• 401K with employer match

• Paid holidays and paid time off

• Opportunity for advancement

• Upbeat and exciting company culture and much more!

Responsibilities include:

• Write sophisticated SQL queries while developing and maintaining data models and their dependencies

• Support partner teams (strategy, finance, sales, field operations, marketing, etc.) with the creation, manipulation and cleansing of new and existing data sources

• Utilize BI visualization tools – primarily Sigma Computing – to build comprehensive data workbooks for use by both internal and external clients

• Handle issues in the existing reporting suite and be able to diagnose and resolve them in a timely fashion

• Collaborate closely with partner teams and executive leadership to understand their business needs and opportunities and then recommend and facilitate analytical solutions

• Work with scalability in mind and make valuable contributions to data quality and accuracy across our data technology stack

Qualifications:

• Education: Bachelor’s Degree (Technical Degree preferred)

• Experience: Business Intelligence or Analytics Engineering Related (Two Years Minimum preferred)

Required Skills:

• Learn and live the principles of the Ideal Team Player by Patrick Lencioni

• Crave feedback and continually strive to improve your relationships with and earn the trust of your co-workers

• Have a knack for problem solving and attention to detail, often double and triple checking your work

• Excellent with written and oral communication and have worked with passionate leaders who aren’t afraid to challenge you

• Self-motivated, not intimidated by balancing multiple difficult projects in tandem and ability to move back and forth between them without missing a beat

• Leveraging data visualizations to tell important business stories and influence decisions (Sigma Computing, Sisense, Tableau, Power BI, Looker, etc.)

• Expert in SQL

• Proficient in the following:

  • Snowflake

  • DBT

  • ETL/ELT tools (Fivetran, Stitch, etc.)

  • Git (Bitbucket, Gitlab, Github, etc.)

• Experience in the following a plus:

  • AWS

  • Airflow

  • Python

Aptive Environmental:

Aptive Environmental provides environmentally responsible residential and commercial pest services to more than 5,000 cities across North America. Co-founded in 2015 by Vess Pearson and David Royce, Aptive launched with the clear intention to grow as a world-recognized brand.

In 2021, Aptive was included in Inc. Magazine’s “Best in Business” list of companies that made the biggest 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 "Nothing But Nets" 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.

#LI-MW