Remote Senior SQL BI Architect — Finance Data Warehouse

GSPANN Technologies, Inc; San Ramon (CA); On-site; USD 130,000 - 180,000; Full time

Benefits offered by this job

Competitive benefits

Educational assistance

Career growth opportunities

Equal opportunity employer

Job summary

GSPANN Technologies, Inc. is seeking a senior Data Warehouse/BI Architect to lead enterprise reporting ecosystems. The role focuses on SQL Server-based data warehouses, SSAS tabular modeling, ETL development, and robust data governance for Finance, FP&A, and executive reporting.

Ideal candidates bring 10+ years in BI/data architecture, 8+ years with SQL Server, and deep experience in SSAS/SSIS. The job may involve remote PST-hours and travel as needed within the U.S.

Qualifications

• 10+ years of data architecture, BI, and enterprise reporting experience.
• 8+ years of Microsoft SQL Server experience.
• 8+ years designing SSAS Tabular Models and SSIS.

Responsibilities

• Architect and maintain enterprise reporting databases in Microsoft SQL Server.
• Design star schemas, fact tables, and dimensional models for analytics.
• Develop complex T-SQL procedures, functions, views, and ETL processes.
• Implement data quality validation, reconciliation, and audit controls.
• Optimize performance and scalability for large financial datasets.
• Design, develop, and optimize SSAS Tabular Models.
• Create enterprise semantic models supporting self-service and executive reporting.
• Develop advanced DAX calculations, KPIs, measures, hierarchies, and business logic.
• Implement row-level security and financial data access controls.
• Build data extraction solutions from Oracle Fusion ERP and Oracle EPM.
• Develop data integrations using BICC, OTBI, BI Publisher, REST/SOAP APIs, FBDI, Smart View.
• Build automated data pipelines moving ERP and EPM data into SQL Server reporting environments.
• Design incremental load strategies and near-real-time reporting architectures.
• Ensure completeness and accuracy of data transfers between Oracle apps and reporting solutions.

Skills

SQL Server

SSIS

SSAS Tabular Models

DAX

Power BI

Financial Data Warehouse Architecture

Data Integration

Financial Reporting

Tools

Oracle Fusion ERP

Oracle EPM

BICC

OTBI

BI Publisher

Job description

GSPANN Technologies, Inc. is seeking a senior Data Warehouse/BI Architect to lead enterprise reporting ecosystems. The role focuses on SQL Server-based data warehouses, SSAS tabular modeling, ETL development, and robust data governance for Finance, FP&A, and executive reporting.

Ideal candidates bring 10+ years in BI/data architecture, 8+ years with SQL Server, and deep experience in SSAS/SSIS. The job may involve remote PST-hours and travel as needed within the U.S.