Business Intelligence Architect
Core
Lead a major data warehouse and reporting transformation for a financial institution, bridging a legacy Microsoft-based environment with a modern cloud data platform.
Role type
Senior Business Intelligence Architect
Builds
Modern cloud data platforms (Snowflake, Sigma) and scalable reporting solutions
Domain
Financial services / Data Engineering & Architecture
Required skills
SQL Server, SSIS, SSRS, Snowflake, Sigma, Data Modeling, ETL Development, T-SQL, PowerShell, C#, Visual Studio, API Integration
Preferred skills
Experience with Sparx, Oxygen, Erwin, Tableau, Power BI, Banking concepts
Technologies
Snowflake, Sigma, SQL Server, SSIS, SSRS, T-SQL, PowerShell, C#, Visual Studio, Erwin, Tableau, Power BI
Responsibilities
Design and implement data models for Snowflake and legacy SQL Server; Re-engineer legacy SSIS workflows into modern pipelines; Rebuild SSRS reports as Sigma workbooks; Plan and coordinate migration phases and cutovers; Identify data inconsistencies and performance issues; Communicate technical decisions and risks to stakeholders.
Seniority
Senior, hands-on IC
