Responsibilities

  • Convert SAP BW cubes and queries into SQL views to support migration activities from SAP BO to Power BI.
  • Write, debug, and optimize SQL queries, views, and stored procedures for accurate and efficient reporting.
  • Design and maintain data models (fact/dimension tables, star and snowflake schemas) to support analytics.
  • Collaborate with business, IT, and data teams to migrate SAP BO reports and dashboards to Power BI while keeping data accurate.
  • Utilize modern BI practices and data migration strategies to build and publish accurate, user-friendly Power BI reports for business users.
  • Validate migrated data and monitor database performance, optimizing queries and structures as needed.
  • Document SQL code, data models, and migration processes while guiding team members.
  • Manage data integration using ETL tools on Microsoft Fabric and similar cloud platforms