Business Intelligence Analyst

AWL; San Antonio (TX); On-site; USD 70,000 - 100,000; Full time

Job summary

AWL is seeking a Business Intelligence Analyst to turn raw data into actionable insights, collaborating with executives, engineers, and analysts. You will work across SQL, Excel, QlikSense dashboards and AI tools to enable faster, better decision-making in a fast-paced, collaborative environment.

The role emphasizes building AI-enabled analytics, data ingestion pipelines, and data quality validation while aligning analyses with strategic business goals.

Qualifications

• Bachelor's degree in engineering, finance, accounting, statistics, economics, math, or related field.
• 3+ years' experience as a BI analyst, software engineer, or database application developer.
• Strong analytical skills grounded in economics and statistics.
• Ability to think strategically and relate data to decisions.
• 5+ years' experience with Excel; expert-level formulas and pivot tables.
• Intermediate to expert SQL skills.
• Comfort writing clear prompts to extract and validate AI analysis.

Responsibilities

• Develop and utilize internal tools, SQL, Excel & QlikSense dashboards that 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 AI-generated insights, before stakeholders.
• Provide situation-specific analyses to support business critical decisions.
• Use AI to build and maintain data ingestion pipelines and optimize data systems.

Skills

Strong analytical skills

Strategic thinking

Economics knowledge

Prompt writing

Excel expert

SQL proficiency

Education

Bachelor's degree in related field

Tools

QlikSense

AI tools

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.

Individuals seeking employment at All Web Leads are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.