Lead SQL BI Developer

About GSPANN:

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

Note:

Client Moving from SAP to Oracle ERP. Move data (ETL) from Oracle Financials into an already established Data tables using SSIS. Should have understanding of Oracle Financials, able to develop STM from Oracle Financial tables into SQL Server for incremental changes using SSIS and SSAS Tabular Models.

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.

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.

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.