Haystack
← Back to Jobs
Technology
PR

1099 - 10+ SQL Developer - Bay Area, CA

ProhiresSan Francisco, CA🇺🇸United StatesPosted 18 Aug 2026

Why This Role Stands Out

This long-term contract offers a significant opportunity to shape data infrastructure during a major ERP transition, developing your expertise in SQL Server, SSIS, and SSAS Tabular Models with Oracle Financials data. You will thrive if you are a mid-senior SQL Developer with a strong background in data warehousing and ETL, eager to build scalable reporting solutions that impact financial decision-making. Apply now to contribute to a critical project and advance your skills in a dynamic environment.

Quick Overview

Work Type
On Site
Level
Mid Senior

Job Description

SQL Server Data Warehouse Developer
Location- Bay Area, CA (Remote PST Hours/Travel Involved/ Locals who can be Onsite/1-2 Days Hybrid will be given First Preference)
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 SS Should have understanding of Oracle Financials, able to develop STM from Oracle Financial tablesIS. 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.

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

Skills

Oracle
SOAP
SQL
SQL Server
T-SQL
ETL
Power BI
REST

Similar jobs

Browse related jobs

Apply now