Business Intelligence Analyst, ConsumerAffairs
AI Native
Online marketplace and advocacy organization
Be an early applicant
Online marketplace and advocacy organization
201-500 employees
Be an early applicant
201-500 employees
Company mission
To enable people to make data driven life decisions when they need it the most.
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.
Kirsty
Company Specialist at Welcome to the Jungle
Insights
0% employee growth in 12 months
Company
Company benefits
- Comprehensive premium health, dental, and vision coverage
- Retirement plans with a company-matched 401k
- Open PTO to take time off whenever you need it
- Work anywhere or side-by-side with your team members at our Tulsa office
- Learning and development to support your professional growth
Company HQ
East Village District, Tulsa, OK
Leadership
Zac Carman
(CEO)Zac has served as the CEO of ConsumerAffairs since 2010. Prior to this, they spent nearly 5 years at Mainsail Partners as a Senior Associate and Entrepreneur in Residence. They were also a Program Manager at Hitachi GST and an Engineer at IBM.
Chang Paik
(CFO)Chang joined the ConsumerAffairs team in 2021 as CFO. Prior to this, they spent 4 years at MakeSpace as CFO and COO. They also spent 3 years at BeenVerified as CFO and 6 years at Goldman Sachs as an Associate and VP.
Adam Joffe
(CTO)Adam has been CTO at ConsumerAffairs since 2017. Prior to this, they were the COO/CTO at Dividend Solar and T-Ink Software. They also served as the CTO at Blurb and worked at PayPal as a VP of Data Management & Credit Technology.
Share this job
View 1 more job at ConsumerAffairs