Role Overview :
- We are seeking an experienced Spotfire Architect with strong data modeling skills to lead and support the migration of complex Spotfire reports to Power BI.
- The role requires deep technical expertise in Spotfire's visual and scripting frameworks, alongside the ability to reverse-engineer, redesign, and optimize data models for scalable, high-performance reporting in Power BI.
- This role is critical to navigating functional parity, data transformation, and performance alignment between platforms, working closely with business users, report owners, and Power BI engineers
Required Skills & Experience
- Developed 20+ reports/dashboards in Spotfire
- 8+ years of experience in BI & analytics with at least 5 years in Spotfire (including architecture, scripting, and advanced configurations).
- Strong experience with data modeling for BI platforms dimensional modeling, fact/dimension tables, normalization/denormalization.
- Hands-on expertise with IronPython, custom expressions, data functions (TERR/Python/R), and Spotfire APIs.
- Working knowledge of Power BI report development and differences between Spotfire and Power BI capabilities.
- Proficient in SQL, data integration (flat files, APIs, databases), and ETL logic interpretation.
- Understanding of functional and visual parity considerations between BI tools.
- Strong analytical, debugging, and communication
Key Responsibilities
- Act as the technical lead for Spotfire-to-Power BI migration, focusing on architecting and simplifying complex Spotfire dashboards.
- Reverse engineer Spotfire DXP files including data tables, custom expressions, R/TERR scripts, Iron Python automation, and document properties.
- Conduct detailed analysis of Spotfire markings, filters, and visual structures to produce functional specification documents for migration.
- Define and redesign semantic data models (star/snowflake schemas) suitable for Power BI.
- Collaborate with data engineers and Power BI developers to align source data, dataflows, and model transformations.
- Work with business stakeholders to define functional parity, consolidate multiple versions, and recommend optimizations.
- Provide guidance on performance engineering approaches in Power BI, including model size reduction, incremental refresh, composite models, and DirectQuery/Import trade-offs.
- Support UAT by validating that migrated Power BI reports meet original Spotfire intent and business KPIs.
