Business Intelligence Engineer

Aptive Pest Control•Provo, UT

1d•Onsite

About The Position

We are seeking a hard-working, innovative, detail-oriented and creative team player to join our Aptive team! This is a full-time Business Intelligence Engineer position located in Provo, Utah . The individual we are looking for is someone who enjoys working in a team environment and excels working at an individual level. What we offer: $94k Annual salary Annual performance bonus 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! 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.

Requirements

Bachelor’s degree required; technical discipline such as Computer Science, Information Systems, Statistics, Mathematics, or related field preferred
Minimum of 2 years of experience in Business Intelligence, Analytics Engineering, or a closely related role preferred
Expert-level proficiency in SQL for complex querying, data modeling, and transformation, with strong knowledge of analytics engineering best practices including data quality, scalability, documentation, and validation
Proficiency with modern data stack tools including Snowflake, DBT, ETL/ELT platforms (e.g., Fivetran, Stitch), BI visualization tools (primarily Sigma Computing; familiarity with Tableau, Power BI, Looker, or Sisense), and working knowledge of version control systems (Git-based platforms)
Strong analytical and critical thinking skills with exceptional attention to detail and disciplined validation habits to ensure accuracy and reliability of outputs
Ability to translate complex data findings into clear, compelling visual narratives and communicate effectively—both written and verbally—with technical and non-technical stakeholders, including executive leadership
Self-motivated and collaborative professional capable of managing multiple concurrent projects, context-switching without loss of quality, actively seeking feedback, and driving continuous improvement

Nice To Haves

Familiarity with AI tools and workflows to accelerate development and improve efficiency, with exposure to AWS, Airflow, Python, and predictive analytics considered a plus

Responsibilities

Design, build, and optimize complex SQL queries, data models, and transformations to support scalable analytics infrastructure
Develop and maintain dashboards, workbooks, and reporting tools for internal teams and external clients using enterprise BI platforms
Manage and support data ingestion, transformation, and pipeline processes across the analytics stack, ensuring data accuracy and reliability
Partner cross-functionally with Strategy, Finance, Sales, Field Operations, Marketing, and Executive Leadership to gather requirements and translate business needs into analytical solutions
Diagnose and resolve reporting discrepancies, data quality issues, and pipeline failures to minimize disruption to business operations
Apply advanced analytics techniques, including statistical modeling, predictive analysis, and experimentation, to generate actionable business insights
Maintain documentation, version control, and data governance standards to ensure long-term maintainability and scalability
Contribute to the continuous improvement of analytics engineering standards, tools, and processes