Business Intelligence Analyst

Summary

AWL (All Web Leads, Inc.) is a customer acquisition marketing company that helps customers acquire customers for the US insurance industry. The Business Intelligence Analyst will transform raw data into actionable insights by developing dashboards, conducting analyses, validating reports, and using AI to improve data pipelines and internal analytics systems.

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

• * 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
• * 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

Qualifications

Must Haves

• * 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

Nice to Haves

• * 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

Benefits

• Fully remote opportunity in TX.