Key Responsibilities :

Data Engineering & BI Modernization :

- Design and build ETL/ELT pipelines to migrate legacy BI systems (SSRS, Cognos, legacy SSAS/OLAP cubes) to modern cloud data platforms (Snowflake, Databricks, Azure Synapse, BigQuery, or similar).
- Re-architect and optimize data models (star/snowflake schemas, semantic layers) to support contemporary self-service BI tools (Power BI, Tableau, Looker).
- Modernize legacy reporting and dashboarding assets, ensuring performance, governance, and cost-efficiency in the target platform.
- Build and maintain orchestration workflows using tools such as Airflow, dbt, ADF, or equivalent.
- Implement data quality, lineage, and governance practices as part of modernization initiatives.
- Collaborate with architects and client stakeholders to define migration roadmaps and target-state architectures.

Sales Enablement & Client-Facing Support :

- Partner with the sales and pre-sales team to scope BI modernization opportunities, including effort estimation and solution design for proposals/RFPs.




- Build and deliver technical demos and proof-of-concepts that showcase modernization outcomes to prospective clients.
- Translate complex technical migration plans into clear, business-friendly narratives for client presentations.
- Support the creation of case studies, technical collateral, and reusable accelerators that strengthen the firm's BI modernization pitch.
- Participate in client workshops and discovery sessions to assess current-state BI landscapes and identify modernization opportunities.

Required Skills &

Experience :

- 59 years of experience in data engineering, with at least 23 years specifically on BI/data warehouse modernization projects.
- Strong SQL skills and hands-on experience with at least one cloud data platform (Snowflake, Databricks, Azure Synapse, Redshift, or BigQuery).
- Experience migrating legacy BI tools/reports (SSRS, Cognos, OBIEE, legacy SSAS) to up-to-date BI platforms (Power BI, Tableau, Looker).

Total Experience : 12-18 years

📌 Data Engineering & BI Modernization Architect (India)
🏢 KPI Partners
📍 India