Modernizing data architecture to unlock business insights for a financial services firm

Modern architecture and automation for seamless data management

OneSix implemented a comprehensive solution leveraging modern data architecture principles and cutting-edge technologies—including Snowflake, dbt Core, Fivetran, Matillion, and Sigma—to address the client’s data management challenges.

Modern architecture and automation for seamless data management

‍

The project unfolded in three distinct phases:

Phase 1: Data Ingestion

• Conducted discovery and strategy sessions to assess requirements and define the architecture.
• Designed a secure and scalable data platform architecture using Snowflake.
• Built a data lake to support ingestion from over 50 data sources.
• Implemented dbt Core with Matillion for automated ETL pipelines and robust data quality tests.

Phase 2: Portal Build

• Selected and implemented advanced ETL tools for efficient data transformation.
• Developed a data warehouse for AUM (Assets Under Management) reporting and analytics.
• Created an internal portal to provide teams with real-time insights into ETF performance through consolidated dashboards.

Phase 3: Additional Reporting

• Automated 13F filings for compliance with SEC reporting rules, reducing manual effort and improving accuracy.
• Built automated reporting for fund administration, legal registration statements, and board reports.
• Integrated the data lake with external systems to facilitate seamless data sharing with third parties.

Results

Improved efficiency, compliance, and operational visibility

The implementation of the scalable data platform delivered measurable impact across key areas of the business:

• Streamlined Operations: Ingested data from over 53 sources into a centralized data lake and warehouse, supporting consistent daily reporting.
• Increased Efficiency: Automated AUM reporting and SEC filings, significantly reducing manual effort and ensuring regulatory compliance.
• Improved Data Quality: Applied rigorous data validation using dbt Core and Matillion to maintain accuracy and consistency.
• Real-Time Insights: Deployed internal portals and dashboards for up-to-date visibility into ETF performance.
• Time & Cost Savings: Automated 13F filings, reducing errors and freeing up team resources.
• Expanded Capabilities: Integrated with external systems to enable secure, scalable data sharing.

With a modern, automated data foundation in place, the client now benefits from faster decision-making, improved compliance, and a platform built to support ongoing innovation and growth.

‍