SPOC at customer site, leading technical delivery for BI transformation initiative - MSTR to PowerBI
Collaborate and assist customer in defining strategy for report framework architecture and strategy.
Analyze existing MicroStrategy Reports and suggest and implement migration plan to Power BI
Develop and maintain PowerBI dashboards, reports and dataset.
Design and own end-to-end BI and analytics architecture using Power BI and SQL Server
Define data models, semantic layers, and reporting frameworks aligned with business needs
Establish standards, best practices, security models, and governance for BI solutions
Change agent between offshore and onshore team
Design and optimize SQL Server databases for analytical workloads
Write and tune complex T-SQL queries, views, stored procedures, and functions
Perform performance tuning using indexing strategies and execution plan analysis
Conduct requirement-gathering sessions, technical discussions, and solution walkthroughs for migration from exiting MicroStrategy reporting suite to Power BI
Translate business requirements into scalable technical solutions
Manage client expectations and handle change requests effectively
Skills Required:
Power BI (Hands-on)
5+ years of experience in Data, BI, and Analytics
4+ years of strong hands-on Power BI experience
Develop and maintain Power BI dashboards, reports, and datasets
Strong hands-on experience with:
DAX (advanced measures and calculations)
Power Query (M language), data transformations, and modeling
Performance tuning, aggregations, and incremental refresh
Row-Level Security (RLS), workspace management, and deployment pipelines
Expert proficiency in SQL Server (T-SQL, optimization, performance tuning)
Strong understanding and application of Data Warehousing concepts, including:
Star and Snowflake schema
Fact and Dimension modeling
Slowly Changing Dimensions (SCD)
ETL/ELT design principles
Hands-on experience with Git, Bitbucket, or similar version control tools
Experience on MicroStrategy to Power BI migration
Knowledge and hands-on experience in MicroStrategy
Proven experience in client-facing roles with excellent communication and presentation skills
Numbers & Facts
Location
Santa Clara, CA
Skills
Analysis Skillsunmatched
Best Practicesunmatched
Business Intelligenceunmatched
Change Requests/Ordersunmatched
Communication Skillsunmatched
Customer Relationsunmatched
Customer Support/Serviceunmatched
Data Modelingunmatched
Data Setsunmatched
Data Warehousing Applicationsunmatched
Database Analysisunmatched
Database Extract Transform and Load (ETL)unmatched