Senior Business Analyst, Growth Operations Reporting & Analytics

Cetera Financial Group, Inc.; Texas; Hybrid; USD 75,000 - 105,000; Full time

Job summary

Cetera Financial Group, Inc. is seeking a Senior Business Analyst to aggregate data from enterprise sources, build advanced financial models in Excel, and deliver insights that drive growth and efficiency.

The role sits at the intersection of business strategy and AI tooling, leveraging Snowflake, Claude, and Copilot Studio to scale data-driven decisions. The ideal candidate will thrive in ambiguous environments, guide projects from ideation to executive delivery, and develop dashboards and

Qualifications

• 5+ years of experience in data analytics and SQL for aggregating datasets
• 5+ years of experience building financial models in Excel with advanced functions and scenario modeling
• Experience prototyping agentic AI solutions (Snowflake Cortex, Claude-based, or Copilot Studio)
• Experience with visualization/reporting tools such as Tableau and Snowflake Streamlit
• Comfort learning new tooling like Airtable and emerging AI platforms
• Ability to derive data-driven insights from large, ambiguous datasets

Responsibilities

• Identify, collect, and analyze data to produce advanced analytics and insights for senior leaders
• Build conversational/workflow agents in Claude and Copilot Studio integrated with Snowflake and Salesforce
• Develop advanced financial models in Excel to support strategic decisions
• Collaborate with stakeholders to translate business outcomes into data/reporting requirements
• Create dashboards and reports (Tableau, Snowflake Streamlit) visualizing results and forecasts
• Automate data collection/reporting with Snowflake Tasks/Streams and Alteryx
• Lead analytics on special projects from ideation through executive delivery

Skills

Data analytics

SQL

Financial modeling

Agentic AI

Tableau

Communication

Education

Bachelor's degree in finance, economics, CS, data analytics

Tools

Snowflake

Excel

Copilot Studio

Claude

Tableau

Alteryx

Job description

Job Description

The Senior Business Analyst will support Cetera by aggregating data from disparate enterprise sources, build advanced financial models, and deliver insights that spearhead growth initiatives, advanced analytics, and operational efficiencies in support of the Head of Growth Operations and the broader Growth Organization. This analyst will sit at the intersection of business strategy and modern data/AI tooling - leveraging financial modeling, data analytics, agentic development on Snowflake, Claude, and Microsoft Copilot Studio to scale how leaders consume and act on data.

This is a highly visible role in a collaborative team that often operates at the forefront of firm-wide initiatives. The ideal candidate is comfortable working in ambiguous environments, having problems with no clear line of sight, and driving projects from ideation through executive presentation.

What You Will Do

• Identify, collect, and analyze data from across the firm to produce advanced analytics, business insights, and data stories for senior leaders and team members.
• Build conversational and workflow agents in Claude and Microsoft Copilot Studio, integrated with Snowflake and Salesforce, to automate recurring reporting, advisor profiling, and ad-hoc data requests.
• Build and maintain advanced financial models in Excel (forecasting, scenario/sensitivity analysis, advisor economics, growth ROI) to support strategic decisions.
• Serve as a trusted data resource across the team on projects varied in scope and complexity, partnering with stakeholders to translate business outcomes into data and reporting requirements.
• Develop presentations, dashboards, and reporting (Tableau, Snowflake's Streamlit) that visualize results, recommendations, and forecasts for business group leaders and department heads.
• Automate data collection, reporting, and distribution wherever possible using Snowflake Tasks/Streams, Alteryx, and AI-driven orchestration.
• Support special projects and firm-wide initiatives as needed, often acting as the analytical lead from ideation through executive delivery.

What You Need to Have

• Bachelor's degree in finance, economics, computer science, data analytics, or a related field - or equivalent experience.
• Minimum 5 years of experience in data analytics, including the ability to write intermediate-to-advanced SQL for aggregating and automating custom datasets and analytics.
• Minimum 5 years of experience building financial models in Excel, including advanced functions, dynamic arrays, Power Query, and scenario modeling.
• Experience building or prototyping agentic AI solutions - for example, Snowflake Cortex Agents, Claude-based assistants, or Microsoft Copilot Studio agents - including prompt design, tool/skill orchestration, and grounding agents on governed data.
• Experience with visualization and reporting tools such as Tableau and Snowflake's Streamlit
• Comfort learning new tooling such as Airtable and emerging AI platforms.
• Demonstrated ability to take a data- and insight-driven approach to large datasets and ambiguous business questions.

What We Would Like You to Have

• Knowledge or experience in the wealth management industry.
• Familiarity with Snowflake Cortex (Analyst, Search, Agents, AISQL) and verified query patterns.
• Strong attention to detail and problem-solving skills.
• Proactive, curious, self-starter mindset; adaptable to change in a fast-paced, dynamic environment.
• Excellent organizational skills and the ability to manage and prioritize a wide range of tasks under tight deadlines.
• Ability to work both independently and collaboratively in a virtual, multi-location team.
• Strong & concise communication skills with the ability to engage multiple internal stakeholder groups, from analysts to executives.
• Advanced-to-expert acumen in MS Excel.

Compensation

The base annual salary range for this role is $75,000-105,000, plus a competitive performance-based bonus. Base annual salary depends on a wide array of factors, including but not limited to skill set, years and depth of experience, certifications, and location. Base annual salary may also differ significantly due to geography and cost of labor considerations.

#LI-Hybrid