What are the responsibilities and job description for the Senior Business Analyst position at Sanctuary Wealth?
Description
Position: Senior Business Analyst
Reports To: Michael Gordon | Director, Business Intelligence
Location: Indianapolis, IN | Miami, FL | Omaha, NE | San Antonio, TX
Details: On-Site, Mon-Thurs
Summary - We are seeking an experienced Senior Business Analyst to lead data transformation, analysis, and business intelligence development across a variety of internal and external data sources. This role focuses on taking raw data and transforming it into clean, analysis-ready datasets, compelling visualizations, and actionable insights for stakeholders across the business.
While Domo experience is a major advantage, strong BI and data transformation skills on any modern platform are welcome.
Essential Duties And Responsibilities
Data Transformation & ETL
Knowledge, Skills, and Abilities
$110,000-130,000
Position: Senior Business Analyst
Reports To: Michael Gordon | Director, Business Intelligence
Location: Indianapolis, IN | Miami, FL | Omaha, NE | San Antonio, TX
Details: On-Site, Mon-Thurs
Summary - We are seeking an experienced Senior Business Analyst to lead data transformation, analysis, and business intelligence development across a variety of internal and external data sources. This role focuses on taking raw data and transforming it into clean, analysis-ready datasets, compelling visualizations, and actionable insights for stakeholders across the business.
While Domo experience is a major advantage, strong BI and data transformation skills on any modern platform are welcome.
Essential Duties And Responsibilities
Data Transformation & ETL
- Intake data from multiple sources and apply structured transformation processes to make it clean, consistent, and analysis-ready.
- Apply ETL tools and transformation logic to clean, reshape, join, and enrich datasets in ways that go beyond standard SQL queries.
- Shape and standardize structured and unstructured datasets for downstream reporting and visualization.
- Validate data quality, identify gaps or inconsistencies in source data, and implement corrective transformations.
- Dig deep into transformed datasets to surface meaningful trends, anomalies, and business opportunities that are not immediately visible.
- Translate business questions into analytical approaches and actionable outputs.
- Build automated reports, dashboards, and visualizations for stakeholders.
- Statistical methods or modeling experience is helpful but not required.
- Build polished, insight-driven dashboards and reports that clearly communicate findings to business stakeholders at all levels.
- Ensure high-quality, scalable, user-friendly BI solutions.
- Collaborate with business partners to align requirements and solutions.
- Navigate and query AWS data environments, specifically Redshift.
- Write complex, efficient SQL for analysis and data preparation.
- Act as a subject-matter expert on data tools, analysis methods, and best practices.
- Partner across technical and business teams to improve data quality, processes, and insights
Knowledge, Skills, and Abilities
- 5–7 years of experience in data analysis, BI, or related technical roles.
- Strong expertise in SQL and working with relational data systems (AWS/Redshift preferred).
- Hands-on experience with ETL tools and data transformation processes; ability to reshape and enrich data outside of SQL. Domo experience strongly preferred.
- Strong analytical and problem-solving skills.
- Excellent communication skills, with the ability to simplify complex topics.
- Experience in financial services or financial data environments preferred
- Experience collaborating with off-shore or distributed teams is a plus
- Python and/or R experience is a plus.
- Bachelor’s degree in Data Science, Computer Science, Mathematics, Economics, Statistics, or related field.
- $110 - $135k | Depending on experience and location
$110,000-130,000
Salary : $110,000 - $130,000