Teams at The Scion Group

The Investment Senior Analyst will prepare financial models, conduct analyses on investment opportunities, support portfolio management, and generate reports while collaborating with the Investments team.

Build and maintain end-to-end ELT pipelines into Snowflake, design layered dbt models, implement CDC and data quality checks, monitor production pipelines, and partner with analytics/BI teams to deliver reliable, production-ready data assets and Looker support.

Execute complex data analysis and reporting, design and maintain interactive dashboards (Looker, Excel), write SQL and build data models, perform trend and statistical analysis, deliver actionable recommendations, support ad-hoc analyses, and partner with Data Science, Data Engineering, and business units.