Lead SQL BI Developer

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

Headquartered in California, U.S.A., GSPANN is a leading provider of consulting and IT services to global clients. We specialize in helping clients transform their IT capabilities, optimize business practices, and drive operational efficiency across industries such as retail, high-technology, and manufacturing. With five global delivery centers and over 2500 employees, we combine the personalized approach of a boutique consultancy with the extensive capabilities of a large IT services firm.

Location- San Ramon CA (Remote PST Hours/Travel Involved)

Job Type-Long Term Contract

Key Skills:

SQL Server, SSIS, SSAS Tabular Models, DAX, Power BI, Financial Data Warehouse Architecture, Data Integration, Financial Reporting.

Deep SQL Server data warehousing, and SQL Server Analysis Services (SSAS) Tabular Models with Oracle Fusion ERP data structures, Oracle EPM data model as a huge plus. The successful candidate will architect data pipelines, develop enterprise semantic models, design reporting databases, and deliver scalable reporting solutions supporting Accounting, Finance, FP&A, and Executive Leadership.

SQL Server Data Warehouse Development

• Architect and maintain enterprise reporting databases within Microsoft SQL Server.
• Design star schemas, fact tables, and dimensional models optimized for analytics.
• Develop complex T-SQL procedures, functions, views, and ETL processes.
• Implement data quality validation, reconciliation, and audit controls.
• Optimize database performance and scalability for large financial datasets.
• Design, develop, and optimize SQL Server Analysis Services (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.
• Optimize model performance and query response times.

Data Extraction & Integration

• Design and implement data extraction solutions from Oracle Fusion ERP and Oracle EPM.
• Develop and support integrations utilizing:
• BICC (Business Intelligence Cloud Connector)
• OTBI
• BI Publisher
• REST APIs
• SOAP APIs
• FBDI extracts
• Smart View data integrations
• Build automated data pipelines moving ERP and EPM data into SQL Server reporting environments.
• Design incremental load strategies and near-real-time reporting architectures where appropriate.
• Ensure completeness and accuracy of data transferred between Oracle applications and downstream reporting solutions.

Experience

• 10+ years of data architecture, business intelligence, and enterprise reporting experience.
• 8+ years of Microsoft SQL Server experience.
• 8+ years designing and implementing SSAS Tabular Models and SSIS.
• Working with Oracle ERP financial systems, Oracle EPM and supporting Oracle Fusion Cloud ERP is a huge plus.

Working at GSPANN

GSPANN is a diverse, prosperous, and rewarding place to work. We provide competitive benefits, educational assistance, and career growth opportunities to our employees. Every employee is valued for their talent and contribution. Working with us will give you an opportunity to work globally with some of the best brands in the industry.The company does and will take affirmative action to employ and advance in the employment of individuals with disabilities and protected veterans and to treat qualified individuals without discrimination based on their physical or mental disability status. GSPANN is an equal opportunity employer for minorities/females/veterans/disabled.