Business Intelligence Analyst, ConsumerAffairs

AI Native

Salary not provided

SQL

Tableau

Airflow

Snowflake

JIRA

Atlassian

Slack

Git

Mid and Senior level

Remote from US

Online marketplace and advocacy organization

Job no longer available

Online marketplace and advocacy organization

201-500 employees

B2BMarketplaceMarket researchSaaSMedia

Job no longer available

Salary not provided

SQL

Tableau

Airflow

Snowflake

JIRA

Atlassian

Slack

Git

Mid and Senior level

Remote from US

201-500 employees

B2BMarketplaceMarket researchSaaSMedia

Company mission

To enable people to make data driven life decisions when they need it the most.

Job

Company

Role

Who you are

If you thrive in a fast-paced environment, are passionate about data-driven decision-making, and are excited to grow alongside a team of experts, we’d love to meet you
Bachelor’s degree in Data Science, Computer Science, Information Systems, Business Analytics, or a related field (Master’s a plus)
3+ years of professional experience in business intelligence or analytics roles with demonstrated success in similar environments
Advanced expertise in relational databases, with strong preference for Snowflake experience
Proficient in BI platforms, specifically Tableau, with proven experience developing enterprise-level dashboards and data models
Familiarity with project management and agile methodologies, with hands-on experience in tools like Jira
Practical knowledge of AI/ML applications in data analysis, such as utilizing LLMs for data summarization, anomaly detection, and report generation
Strong SQL skills and understanding of database design and optimization principles
Experience collaborating with data engineering teams on ETL/ELT processes and orchestration frameworks like Airflow
Excellent communication skills, with the ability to translate technical findings into actionable business insights
A demonstrated eagerness for continuous learning, adaptability to emerging technologies, and a growth mindset
Masters Degree or PhD a plus
Advanced SQL: Writing complex queries, optimizing performance, and developing data models in relational databases (Snowflake strongly preferred)
Tableau Development: Building scalable dashboards, managing data extracts, creating calculated fields, and designing custom visualizations
Data Modeling: Designing and implementing snowflake schemas and common data source models for analytics efficiency
ETL/ELT and Data Pipeline Orchestration: Collaborating with Data Engineers to design, monitor, and troubleshoot workflows in tools like Apache Airflow
AI/ML Integration for BI: Utilizing AI tools, including LLMs, for data preparation, report generation, anomaly detection, and insights automation
Prompt Engineering for LLMs: Crafting effective, context-aware prompts to optimize AI/LLM outputs for data analysis, summarization, and decision support
Version Control: Working knowledge of Git for managing Tableau workbooks, SQL scripts, and other analytical assets collaboratively
Project Management Tools: Proficiency in using Jira for sprint planning, task management, and progress tracking within agile frameworks
Domain Expertise in Digital Marketing and Consumer Technology: Applying industry-specific knowledge to interpret data trends, optimize lead generation, and support brand reputation strategies

What the job involves

We're expanding our Business Intelligence capabilities and looking for a dynamic Business Intelligence Analyst to join our team
In this role, you’ll work at the intersection of data, technology, and business strategy — developing scalable data visualizations, collaborating on data infrastructure, and applying cutting-edge AI tools to unlock actionable insights
Design, develop, and maintain dashboards and reports primarily using Tableau, ensuring scalable and reusable data models
Collaborate closely with Data Engineering and Data Architecture teams to design optimized Snowflake data marts and ensure efficient, high-quality data pipelines
Develop and manage common data source models in Tableau to promote consistency and scalability across multiple departments
Partner with Engineering teams to automate data workflows and orchestrate data refreshes using tools like Airflow
Lead initiatives to push automated report distribution (e.g., Slack notifications, scheduled email reports) and drive broader data accessibility across the organization
Apply business knowledge to translate complex data into strategic insights
Leverage AI and large language models (LLMs) to enhance reporting, analytics processes, and overall business intelligence capabilities
Collaborate cross-functionally to gather requirements, prioritize initiatives, and deliver data-driven solutions that align with business objectives
Manage tasks and project timelines using Atlassian Jira, ensuring high transparency and accountability across deliverables
Continuously identify opportunities to improve data visualization best practices, driving a culture of data literacy throughout the company

Our take

ConsumerAffairs is an online marketplace and advocacy organization that helps consumers make smart buying decisions for all of life’s biggest purchases. The rapidly growing platform serves consumers while working with brands in order to provide a comprehensive collection of market research and news to empower confident purchase decisions.

The company’s coverage is truly all-encompassing, as consumers are able to find information and reports on just about any topic they can think of. ConsumerAffairs also has a range of free newsletters available for its users to stay informed on topics from daily news, monthly senior consumer (aged 60+) based resources, and recall alerts – all delivered to their email inboxes.

It is a guarantee that all consumers will have numerous purchase decisions to make throughout their lives, and having one platform that they can access to find information and advice for all those decisions is a truly beneficial (and convenient) advantage.