Business Intelligence Analyst

AWL; United States; Remote; USD 70,000 - 110,000; Full time

Job summary

AWL is seeking a Business Intelligence Analyst to turn raw data into decisions that move AWL forward. You’ll work with SQL, Excel, QlikSense dashboards and AI tools to translate information into actionable insights for executives and stakeholders.

This fully remote role in Texas collaborates with engineers and other analysts in a fast-paced, data-driven environment. You’ll validate data quality, build ingestion pipelines, and help design analytics that guide strategic decisions across the

Qualifications

• Bachelor’s degree, ideally in engineering, finance, accounting, statistics, economics, math, or related field.
• 3+ years’ experience as a business intelligence analyst, software engineer, or database application developer.
• Strong analytical skill set for translating business requirements into reports, grounded in a solid knowledge of economics and statistics.
• Ability to think strategically and to relate data to strategic decisions.
• 5+ years’ experience with Microsoft Excel; expert-level formula and pivot table development.
• Intermediate to Expert level SQL skills.
• Comfort writing clear, structured prompts to extract and validate analysis from AI tools.
• Intellectual curiosity and a drive to optimize – a genuine passion for using data and technology to explore and solve problems, and to understand what makes things tick.

Responsibilities

• Develop and utilize internal tools, SQL, Excel & QlikSense dashboards that will drive core business decisions.
• Leverage AI-assisted analytics tools and natural language querying to accelerate data exploration and reporting.
• Validate the correctness and accuracy of internal and external report data, including insights and queries generated by AI, before they reach stakeholders.
• Provide situation-specific analyses to support business critical decisions.
• Use AI to help build and maintain data ingestion pipelines, and continually optimize our internal data systems and analysis infrastructure.

Skills

SQL

Excel

QlikSense

AI Tools

NL querying

Data analysis

Prompts for AI

Education

Bachelor’s degree

Tools

Databricks

Python

Job description

As our Business Intelligence Analyst, you will turn raw data into the decisions that move AWL forward – aggregating, analyzing, and translating information into insights leaders can act on. You will work across the full modern analyst’s toolkit, from SQL, Excel, and QlikSense dashboards to emerging AI tools, always pairing that speed with the judgment to know when a result is right. Data sits at the core of every decision we make, and you will partner closely with executives, stakeholders, engineers, and fellow analysts to sharpen how the business runs. We work to foster a fast paced, fun, highly collaborative environment where results are both expected and rewarded.

Fully remote opportunity in TX.

General Responsibilities

• Develop and utilize internal tools, SQL, Excel & QlikSense dashboards that will drive core business decisions.
• Leverage AI-assisted analytics tools and natural language querying to accelerate data exploration and reporting.
• Validate the correctness and accuracy of internal and external report data, including insights and queries generated by AI, before they reach stakeholders.
• Provide situation-specific analyses to support business critical decisions.
• Use AI to help build and maintain data ingestion pipelines, and continually optimize our internal data systems and analysis infrastructure.

Requirements

• Bachelor’s degree, ideally in engineering, finance, accounting, statistics, economics, math, or related field.
• 3+ years’ experience as a business intelligence analyst, software engineer, or database application developer.
• Strong analytical skill set for translating business requirements into reports, grounded in a solid knowledge of economics and statistics.
• Ability to think strategically and to relate data to strategic decisions.
• 5+ years’ experience with Microsoft Excel; expert-level formula and pivot table development.
• Intermediate to Expert level SQL skills.
• Comfort writing clear, structured prompts to extract and validate analysis from AI tools.
• Intellectual curiosity and a drive to optimize – a genuine passion for using data and technology to explore and solve problems, and to understand what makes things tick.

Preferred Qualifications

• Statistics background / Predictive analytics.
• Experience building or maintaining machine learning pipelines, especially in Databricks.
• Familiarity with prompt evaluation and spotting where AI-generated queries go wrong.
• Experience with scripting languages / light programming.

AI is welcome here — but we still want to meet YOU.
Our team personally reviews applications and resumes, and our hiring process includes video interviews with real people. Feel free to use AI as a tool, but make sure your application reflects your actual experience, perspective, and voice. We’re looking forward to meeting the person behind the résumé!

About AWL

AWL (All Web Leads, Inc.) is one of the most successful customer acquisition marketing companies in the US. Simply put, we help our customers acquire customers for the US insurance industry. Our amazing team of nearly 1,000 talented and successful professionals use internet marketing strategies to turn consumer interest in insurance products into policy sales for the world’s largest insurance carriers and more than 30,000 of their agents. We are Austin-born, and our growth from a 2‑person startup in 2005 to a highly profitable business has been a remarkable journey. We are a tight‑knit team with a fast‑paced, energetic, and entrepreneurial company culture. We have been ranked an Austin Best Place to Work over 10 times by Austin Business Journal, Austin Statesman, Built‑in and Glassdoor! AWL fosters a vibrant, dynamic work culture built on trust, data, technology, passion, collaboration, and winning, where employees want to engage and be impactful. We provide competitive pay, outstanding benefits, and a fabulous, fun, collaborative environment that allows our people to be their best.