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.
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.
Never miss an opportunity! Create an alert based on the job you applied for.
