Business Intelligence Architect

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Business Intelligence Architect based in United States. As a Business Intelligence Architect, you will lead a major data warehouse and reporting transformation for a financial institution, bridging a legacy Microsoft-based environment with a modern cloud data platform. You’ll maintain and enhance existing SQL Server, SSIS, and SSRS solutions while designing and executing the migration to Snowflake and Sigma. The role combines hands-on data architecture, modeling, ETL development, reporting, and technical leadership. You’ll translate existing data structures and reporting logic into modern, scalable solutions while ensuring accuracy and continuity throughout the transition. Working directly with technical teams and client stakeholders, you’ll manage migration risks, dependencies, documentation, and validation. This is a remote-first opportunity for a technically strong professional who enjoys solving complex data challenges in a regulated financial environment.