AI Native, Business Intelligence Analyst

At ConsumerAffairs, we help brands build trust, protect their reputations, and drive meaningful customer connections. As a growing company, we pride ourselves on our entrepreneurial spirit, collaborative culture, and relentless focus on innovation. 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. 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.

What you'll do:

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

Requirements

What you need:

• 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

Technical Skills:

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