Senior Business Intelligence Analyst

Job Title: Senior Business Intelligence Analyst Salary Range: $120,000 - $150,000 per year DOE Position Type: Full-time, Exempt Position Location: 100% On-site — Miami, FL Company Overview AardvarkInsure.com Corporation aka Aardy.com is one of the leading Insure Tech companies in the USA, helping customers choose great travel insurance for their next trip. The company has the highest Trustpilot score of any travel insurance company in the United States and is certified as a Great Place to Work. Aardy is on a high growth trajectory and values excellent customer service skills and high performance. Position Overview Senior Business Intelligence Analyst who will build and maintain systems that drive business results from data. The role works closely with a data engineer to create pipelines that collect, clean, and transform data, then visualizes it in executive and marketing dashboards. The analyst reports directly to the CEO and supports all C‑level members to deliver insights that shape strategy and accelerate growth. Key Responsibilities Own and maintain the executive reporting suite — dashboards, KPI trackers, and ad hoc analyses for the CEO and full C‑suite, as well as marketing dashboards for the broader team. Develop the reporting framework for the next phases of growth beyond first touch and last touch attribution, understanding how email, paid, and other touch points contribute to the customer journey. Proactively surface insights that help leadership anticipate future business trends and deliver revenue‑driving insights. Enhance existing dashboards primarily in Looker, and leverage other tools, including AI interfaces, to complete executive reporting and marketing dashboards. Connect systems to generate tables in BigQuery and other tools that serve as master data sources powering visualization tools like Looker. Write SQL from scratch to build, maintain, and troubleshoot datasets in BigQuery, transforming raw data into usable tables that drive powerful insights. Work with FiveTran and Segment to support data pipelines in collaboration with the data engineer. Partner with the data engineering team to design tables, build pipelines, and establish data practices that will scale, minimize errors, and build confidence in reporting. Present findings directly to the CEO and C‑level team; own the narrative from data pull to executive briefing. Work across departments as a senior resource to solve problems, answer business questions, support maintenance of campaigns, and enable deep segmentation and analysis. Deliver insightful reporting that drives business decisions and results beyond current reporting. Translate complex data into clear, actionable recommendations for non‑technical senior leaders. Maintain the data dictionary, document reporting logic, and keep assets organized and reproducible. Balance competing data requests from multiple C‑suite members and communicate priorities clearly. Perform other related duties as assigned. Qualifications (Mandatory) Bachelor’s degree in a relevant field. Minimum of five (5) years of experience in a data analyst or business analyst role. Minimum of one (1) year of experience working directly with or supporting C‑level teams. Proficiency writing complex SQL from scratch (CTEs, window functions, joins, aggregations). Hands‑on experience with BigQuery as a data warehouse, including best practices in data analysis and data engineering. Experience building production dashboards and reports in Looker, Google Data Studio, or a comparable BI platform. Familiarity with FiveTran and Segment for data ingestion and pipeline management. Experience collaborating with a data team to design, build, and maintain a governed, source‑of‑truth data foundation. Strong business acumen with the ability to understand executive and marketing team needs and solve for them with data. Excellent communication and presentation skills – able to convey technical findings to non‑technical leaders clearly and confidently. Experience working with Google Sheets and Excel for ad hoc executive deliverables. Preferred Qualifications Background in high‑growth or operationally complex businesses. Experience as a solo data owner or primary BI lead for an executive or C‑suite team, with a track record as the “owner” of all things data. Experience with tools such as MixPanel, Segment, Salesforce, and visualization platforms including Looker and PowerBI. Experience building underlying data systems and processes that drive first touch and last touch attribution models, and eventually a multi‑touch attribution model. Familiarity with AI tools for reporting automation and visualization. Experience connecting multiple data sources and maintaining data pipeline integrity. Strong desire to learn and grow with the business. Master’s degree in data science, analytics, or a comparable field preferred. Benefits 15 days (120 hours) of PTO per year. 6 paid holidays. Paid bereavement leave. Equipment: PC + monitor, standard peripherals. Retirement Plan: 401(k) safe harbor plan with up to a 6% company match. ICHRA – Individual Coverage Health Reimbursement Arrangement: up to $600 per month for employee only and up to $800 for employee + dependent(s). Peer Rewards: Bonusly platform. Equal Employment Opportunity Statement AardvarkInsure.com Corporation provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. AardvarkInsure.com Corporation is an E‑Verify employer. AardvarkInsure.com Corporation conducts background checks via Checkr. #J-18808-Ljbffr Aardy