Published: Tue, 17 Jun 2025 14:50:32 GMT
Our team of experts and analysts continuously researches and reviews the best products and services to help you find the right solutions for your needs. Join us in our mission to empower consumers and build trust in the marketplace.
Position: Business Intelligence Analyst
Company: ConsumerAffairs
Location: [Insert location]
Type: Full-time
Salary: [Insert salary range]
About ConsumerAffairs:
At ConsumerAffairs, we are committed to helping brands build trust, protect their reputations, and drive meaningful customer connections. As a rapidly growing company, we pride ourselves on our entrepreneurial spirit, collaborative culture, and relentless focus on innovation.
Role Overview:
We are expanding our Business Intelligence capabilities and seeking a dynamic Business Intelligence Analyst to join our team. In this role, you will 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.
Key Responsibilities:
• Design, develop, and maintain dashboards and reports 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:
• 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.
• Master’s 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
About the Company:
ConsumerAffairs is the go-to service for life’s important purchases. We provide resources and thousands of consumer reviews to help individuals make smarter buying decisions. Our team of experts and analysts continuously research and review the best products and services to help consumers find the right solutions for their needs. Join us in our mission to empower consumers and build trust in the marketplace.
Apply link