Note: The job is a remote job and is open to candidates in USA. AWL is a customer acquisition marketing company serving the US insurance industry. The Business Intelligence Analyst will transform raw data into actionable business insights by developing dashboards, conducting analyses, validating reports, and supporting data infrastructure and ingestion pipelines using SQL, Excel, QlikSense, and AI-assisted tools.
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
Benefits
- Fully remote opportunity in TX.
Company Overview