LEAD SQL BI DEVELOPER

GSPANN Technologies; San Ramon (CA); Hybrid; USD 150,000 - 190,000; Full time

Job summary

GSPANN Technologies seeks an experienced Technical Data Architect & Reporting Analyst Contractor to support a large Oracle Fusion ERP and Oracle EPM implementation. This senior role leads data architecture, reporting architecture, and enterprise semantic modeling across ERP and EPM platforms.

Responsibilities include designing data pipelines, developing semantic models, and delivering scalable reporting solutions for Accounting, Finance, FP&A, and executives, leveraging SSAS and Power BI to

Qualifications

• 10 years of data architecture, BI, and enterprise reporting experience.
• 7 years working with Oracle ERP financial systems.
• 5 years supporting Oracle Fusion Cloud ERP.
• 5 years working with Oracle EPM (Planning, FCCS, Financial Reporting, Smart View).
• 8 years of Microsoft SQL Server experience.
• 5 years designing and implementing SSAS Tabular Models.

Responsibilities

• Lead design and implementation of enterprise reporting architecture for Oracle ERP, EPM, and internal platforms.
• Architect data pipelines and enterprise semantic models.
• Design reporting databases and scalable reporting solutions.
• Collaborate with Accounting, Finance, FP&A, and Executive Leadership.

Skills

Oracle Fusion ERP

Oracle EPM

SSAS Tabular Models

Power BI

Data Warehousing

SQL Server

DAX

BICC/OTBI/BI Publisher

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Finance, Accounting, or related field

Tools

SSAS

SQL Server

Job description

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 (LOCAL TO CA/ HYBRID)
Job Type-Long Term Contract
15 -25 Years Experience Candidates

We are seeking an experienced Technical Data Architect & Reporting Analyst Contractor to support a large-scale Oracle Fusion ERP and Oracle EPM implementation. Senior-level Technical Data Architect & Reporting Analyst with deep Oracle Fusion ERP data structures, Oracle EPM data models, SQL Server data warehousing, and SQL Server Analysis Services (SSAS) Tabular Models. This role will lead the design and implementation of enterprise reporting architecture supporting Oracle ERP, EPM, and internal reporting platforms. 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.

Key Skills:

• Oracle Fusion ERP, Oracle EPM, BICC, OTBI, BI Publisher, SQL Server, SSAS Tabular Models, DAX, Power BI, Financial Data Warehouse Architecture, Data Integration, Financial Reporting.

Education

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Finance, Accounting, or related field.

Experience

• 10 years of data architecture, business intelligence, and enterprise reporting experience.
• 7 years working with Oracle ERP financial systems.
• 5 years specifically supporting Oracle Fusion Cloud ERP.
• 5 years working with Oracle EPM, including:
  • Planning
  • FCCS
  • Financial Reporting
  • Smart View
• 8 years of Microsoft SQL Server experience.
• 5 years designing and implementing SSAS Tabular Models.

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 based on their physical or mental disability status. GSPANN is an equal opportunity employer for minorities/females/veterans/disability.