LEAD SQL BI DEVELOPER

About GSPANN
Headquartered in Milpitas, California (U.S.A.), GSPANN provides consulting and IT services to global clients, ranging from mid-size to Fortune 500 companies. With our experience in retail, high-technology, and manufacturing, we help our clients to transform and deliver business value by optimizing their IT capabilities, practices, and operations. Counting on our ten offices, including four global delivery centers, and approximately 1400 employees globally, we offer the intimacy of a boutique consultancy with capabilities of a large IT services firm

Location- San Ramon CA (1-2 Days Hybrid)
Job Type-Long Term Contract

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

Technical Data Architect & Reporting Analyst

Senior-level Technical Data Architect & Reporting Analyst with 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.

SSAS Tabular Model Development

• 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.

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 an 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/disability.