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 interpret data trends, optimize lead generation, and support brand reputation strategies.
Benefits
- Health Care Plan (Medical, Dental & Vision)
- Retirement Plan (401k)
- Life Insurance (Basic, Voluntary & AD&D)
- Paid Time Off (Vacation, Sick & Public Holidays)
- Family Leave (Maternity, Paternity)
- Short Term & Long Term Disability
- Training & Development
