Information Technology_USA - USA_Technical Architect

2 Candidate Submittal Slots, New High Level PolicyBill Rate - MSP Owner: Rob FintonLocation: Miami, FL - Can be Hybrid, Associate will support EST Hours with their scheduleDuration: 6 monthsGBaMS ReqID: 10870214Competencies: 15+ years experienceOracle OBIEE Application DevelopmentOracle eBS R12 FinancialsDigital : Talend Open StudioDigital : Microsoft Power PlatformPL/SQLMust-Have • Strong knowledge in OBI development.• Strong experience in ETL architecture and development.• BIAPPS - Oracle Pre-Built analytic experience in Finance Modules AP, AR, GL and PO• Experience in Oracle EBS as a data source for reporting.• Hands on in PLSQLGood-to-Have • Power BI• Knowledge on Data Visualizer• Experience with Oracle Database performance tuning.Background • Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related fieldKey Competencies • Solution Architecture• Enterprise Reporting & Analytics• Oracle EBS Finance• OBIEE• Power BI• ETL & Data Warehousing• SQL & PL/SQL• Stakeholder Management• Business Analysis• Architecture GovernanceOthers • Strong understanding of Oracle EBS Finance business processes.• Ability to work directly with Finance and Accounting stakeholders.• Experience translating business requirements into technical solutions.• Solution architecture and design leadership.• Customer-facing communication and presentation skills.• Stakeholder management and executive communication.• Team mentoring and technical leadership.Responsibility of / Expectations from the Role Solution Architecture• Define end-to-end architecture for reporting, analytics, and data integration solutions.• Assess existing Oracle BI landscapes and recommend modernization strategies.• Design scalable and secure reporting architectures leveraging Oracle and Microsoft technologies.• Drive technology roadmap discussions and architecture governance.Oracle Analytics & Reporting• Lead design, development, and optimization of OBIEE reports, dashboards, and semantic models.• Analyze and optimize OBIEE RPD models and reporting frameworks.• Define reporting standards, data governance, and best practices.Data Integration & ETL• Design and oversee ETL processes for data movement and transformation.• Work with source systems, staging environments, and data warehouses.• Ensure data quality, reconciliation, and performance optimization across data pipelines.Oracle EBS Finance• Partner with Finance stakeholders to understand reporting requirements.• Translate Oracle EBS business processes into analytical and reporting solutions.• Support reporting across: • General Ledger (GL)• Accounts Payable (AP)• Accounts Receivable (AR)• Fixed Assets (FA)• Cash Management (CM)• Purchasing (PO)Database & PL/SQL Development• Design and optimize complex SQL and PL/SQL solutions.• Perform database performance tuning and query optimization.• Develop packages, procedures, functions, materialized views, and data extraction frameworks.Power BI Modernization• Design and develop Power BI dashboards and executive reporting solutions.• Define data models, measures, KPIs, and visualization standards.• Support migration and coexistence strategies between OBIEE and Power BI.• Implement Row-Level Security (RLS) and Power BI governance practices.Stakeholder Management• Engage with business and executive stakeholders to gather requirements and present solutions.• Lead solution workshops and architecture discussions.• Provide technical leadership and mentorship to project teams.