Senior Analyst, Business Intelligence Tools

C.A. Fortune; Austin (TX); Hybrid; USD 70,000 - 75,000; Full time

Benefits offered by this job

11 paid company holidays

Fully paid parental leave

401k with company match

Medical, dental, and vision

Job summary

C.A. Fortune in Austin, Texas, is seeking a Senior Analyst for BI Tools to lead the development and scaling of reporting solutions. The role involves building enterprise-grade Power BI dashboards, ensuring data accuracy, and partnering with different teams for analytics needs. Ideal candidates have 4-7+ years in BI, advanced Power BI skills, and a Bachelor's in related fields. The position offers a hybrid work model, comprehensive benefits, and a commitment to inclusivity.

Qualifications

• 4 – 7+ years of experience in BI, analytics, or data visualization roles.
• Advanced Power BI skills including DAX and data modeling.
• Strong experience integrating multiple data sources.

Responsibilities

• Lead development of dashboarding and reporting solutions.
• Establish standardized templates for reporting.
• Translate complex datasets into actionable visualizations.

Skills

Advanced Power BI expertise

Strong experience with cloud-based data platforms

Excellent communication skills

Strong analytical mindset

Education

Bachelor’s degree in Data Analytics, Data Science, Business Analytics

Tools

Power BI

Snowflake

Excel

Job description

At C.A.,we aspire tomaintainour position as the nation’s leading consumer brands agency. We realize how fortunate we are (pun intended) to offer comprehensive solutions to our clients. From sales management to marketing, all the way down to insights and e-commerce, our boutique service model offers a breadth of services to our clients.

People. Passion. Purpose. Our people are the core of our business. Our unique boutique service model allows our people to follow their passions with a purpose, all while delivering excellent services to our clients. We are committed toliving outour values. We are fearless and curious innovators wholead withsolutions, empower others, and do the right thing, always. We are a family-first organization and recognize the importance of a healthy and flexible work-life balance, a positive support system, and the power of diversity and inclusion.

Who We Are

Overview of the Role

• The Senior Analyst, BI Tools will lead the development, standardization, and scaling of dashboarding and reporting solutions across the organization. This role sits at the intersection of data engineering, analytics, and business storytelling—owning the infrastructure and outputs that power insights across sales, category, and paid media teams.
• This is a highly technical, high-impact role responsible for building enterprise-grade Power BI solutions, creating scalable data models, and enabling self-service analytics across stakeholders. The ideal candidate will act as both a builder and a thought partner, helping define how data is structured, accessed, and visualized across the business.
• Fully Remote but if local to Chicago, IL (within 1 hour) will observe a hybrid schedule 3 days in office
• Travel Required: 5–10% - i.e. client meets, Insights Team meetings, and/ or any other events.
• Salary Range: $70,000 – $75,000 based on experience, qualifications and skills.
• At C.A. we’re not looking for perfection, just people that want to commit to a us and grow their careers long‑term. We are on a mission to build better brands that inspire healthier lifestyles for consumers and their families. If you’re looking for a sign to apply, here it is!

WhatYou’llDoat C.A. Fortune

• Design, build, andmaintainscalable Power BI dashboards used across internal teams and client engagements
• Establish standardized templates and best practices to ensure consistency across all reporting outputs
• Translate complex datasets into intuitive, actionable visualizations for business users
• Develop and manage robust data models that integrate multiple data sources (POS, syndicated, retail media, internal systems)
• Clean, transform, and standardize raw datasets using Power Query and other ETL processes
• Ensure data accuracy, governance, and consistency across dashboards and reporting environments
• Automation & Scalability
  • Build automated reporting pipelines that reduce manual work and improve speed to insight
  • Create repeatable frameworks for weekly, monthly, and quarterly reporting
  • Identifyopportunities to streamline workflows andeliminateinefficiencies
• Cross-Functional Enablement
  • Partner with Insights, Sales, and Media teams to understand reporting needs and translate them into scalable BI solutions
  • Act as the internal expert on BI tools and visualization best practices
  • Train and enable team members on dashboard usage and self-service capabilities
• Ad-Hoc Analysis & Support
• Support rapid-turn analysis requests for client meetings, business reviews, and leadershipasks
• Develop custom views and deep dives to answer specific business questions

What You Should Bring to the Table

• 4 – 7+ years of experience in BI, analytics, or data visualization roles (CPG, retail, or ecommerce preferred)
• Advanced Power BIexpertise(DAX, Power Query, data modeling, performance optimization)
• Strong experience with cloud-based data platform, Snowflake
• Strongexperience inintegrating and managing multiple data sources
• Advanced Excel skills (Power Pivot, complex formulas, large dataset manipulation)
• Experience building automated reporting systems used by multiple stakeholders
• Strong analytical mindset with the ability to translate data into business insights
• Excellent communication skills with ability to simplify complex concepts
• Bachelor’s degree in Data Analytics, Data Science, Business Analytics or related is required

You Will Stand Out If You Have

• SQL experience (writing complex queries, working with large datasets)
• Experience with cloud data warehouses (Snowflake, Databricks, etc.)
• Python or R for data manipulation
• Experience with CPG syndicated data sources (NIQ, Circana, SPINS)
• Experience supporting retail media or ecommerce analytics

What We Offer

• 11 paid company holidays
• 1 floating holiday
• 3monthsfully paid parental leave
• Medical, dental, and vision
• 401k with company match
• Summer hours (half-day Fridays)
• Hybrid work flexibility

Come As You Are

C.A. is committed to making our company more inclusive. Diversity fuels our innovation and better connects us to our clients, our colleagues, and our communities. Based on research, we know that women and other marginalized groups tend to apply to roles only when their experience perfectly matches the job description. That said, we encourage you to apply if you meet the majority of qualifications, especially if this role aligns with your career trajectory.