> Markdown version of [/jobs/ext/2032785-technical-data-architect-reporting-analyst](https://www.wearedevelopers.com/jobs/ext/2032785-technical-data-architect-reporting-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Technical Data Architect & Reporting Analyst - **Company:** Redrouthu's Inc - **Location:** United States (Remote available) - **Experience:** Expert - **Contract:** Temporary contract - **Skills:** Business Logic, Cloud Computing, Information Systems, Databases, Data Architecture, Data Governance, Data Integration, Extract Transform Load (ETL), Data Mining, Data Structures, Data Warehousing, Database Storage Structures, Dimensional Modeling, Executive Information Systems, Microsoft SQL Server, Oracle (Applications), Power BI, SAP (Applications), SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Oracle Fusion Middleware, Systems Integration, Technical Data Management Systems, Transact-SQL, Oracle Hyperion, Azure Data Factory, Bi Publisher, SOAPAPI, Netsuite Erp, Database Performance, Data Layers, Information Technology, Data Analytics, Integration Frameworks, Data Management, Tools for Reporting, Restful APIs, Oracle Erp, Oracle Cloud Infrastructure, Data Pipelines, Ssas Tabular, Custom Reports - **Published:** August 12, 2026 - **Apply:** https://www.dice.com/job-detail/eb0676bd-8308-4ba7-aedc-1678024eba18 ## About the Role 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., 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. Oracle Fusion Expertise Deep understanding of Oracle Fusion database structures and business processes for, Must possess strong knowledge of: Oracle Fusion subject areas Transactional and reporting tables Oracle Financial reporting framework Security and role-based access model Technical Skills Required expertise in: Oracle Fusion ERP Oracle EPM (Planning and FCCS) BICC OTBI BI Publisher REST APIs SOAP APIs SQL Server T-SQL SSIS SSAS Tabular Models DAX Power BI Data Warehousing Dimensional Modeling Data Governance Master Data Management Preferred Qualifications Experience supporting large Oracle ERP transformation programs. Experience migrating reporting solutions from SAP, legacy ERP systems, or custom reporting environments into Oracle Cloud. Experience designing enterprise reporting databases supporting Finance and Executive Reporting. Familiarity with Azure Data Services and cloud analytics platforms. Oracle Cloud certifications. Microsoft Power BI certification. Microsoft SQL Server certification. Education Bachelor's degree in Computer Science, Information Systems, Data Analytics, Finance, Accounting, or related field. ## Description 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., Oracle ERP & EPM Data Architecture Design and maintain enterprise reporting and analytics architecture spanning Oracle Fusion ERP, Oracle EPM, and SQL Server. Develop a comprehensive understanding of Oracle Fusion Financials data structures and relationships across: General Ledger (GL) Accounts Payable (AP) Accounts Receivable (AR) Cash Management (CM) Fixed Assets (FA) Project Accounting (PPM) Budgeting & Planning Financial Consolidation and Close (FCCS) Define enterprise data models supporting operational, financial, statutory, management, and executive reporting. Establish data governance standards, reconciliation processes, and reporting controls. 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. 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. Reporting & Analytics Partner with Accounting, FP&A, Treasury, Project Accounting, and Executive Leadership teams to define reporting requirements. Develop reporting datasets and semantic layers supporting: Financial Statements Board Reporting Budget vs. Actual Analysis Cash Forecasting Project Financial Analysis AR/AP Operational Metrics Consolidation Reporting Executive Dashboards Support reporting tools including Power BI and other enterprise analytics platforms. Data Reconciliation & Controls Create reconciliation frameworks between: Oracle ERP subledgers and GL Oracle EPM and ERP actuals SQL Server Reporting Database and source systems Support audit and SOX compliance requirements. Develop controls for validating accuracy and completeness of financial data. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)