Freelance Opportunity : Bi Migration Engineer

Company Description

ThreatXIntel is a startup cyber security company dedicated to safeguarding businesses and organizations from ever-evolving cyber threats. Specializing in personalized and cost-effective services, ThreatXIntel provides expertise in cloud security, web and mobile security testing, cloud security assessment, and DevSecOps. With a proactive approach, the team continuously monitors and assesses digital environments to identify and address vulnerabilities before they are exploited. ThreatXIntel is committed to empowering businesses of all sizes with high-quality cyber security services to protect their digital assets and support growth.

Role Description

We are looking for an experienced BI Migration Engineer with strong expertise in migrating legacy OBIEE reports into modern Tableau dashboards , using Databricks Medallion Architecture and AWS Cloud as the new data platform. The consultant will work across data modeling, ETL / ELT transformation, semantic layer redesign, and dashboard re-engineering to ensure a smooth migration from Oracle-based reporting systems to a scalable cloud BI environment.

This role requires deep hands-on experience with OBIEE RPD / report logic, Tableau dashboard development, Databricks pipelines, and AWS data services.

Responsibilities

• Analyze legacy OBIEE reports, RPD models, subject areas, metrics, and calculations .
• Reverse-engineer OBIEE data flows and convert logic into modern data models.
• Build Bronze, Silver, Gold layers using Databricks Medallion Architecture .
• Develop ETL / ELT pipelines on Databricks using PySpark / Spark SQL.
• Recreate reports and dashboards in Tableau , ensuring functional and visual parity.
• Optimize performance using Tableau best practices (LOD, extracts, data blending, joins).
• Work with AWS services (S3, Glue, Lambda, Redshift / Athena) for data ingestion and storage.
• Validate migrated reports and ensure data accuracy, metric consistency, and business logic alignment.
• Partner with business users to gather requirements and refine dashboards.
• Document data flows, mapping rules, transformations, and dashboard logic.
• Support UAT, cutover, and final deployment to production environments.

Required Skills

Preferred Qualifications

Nice to Have