Work Location: Iselin, NJ (Hybrid) (Seeking LOCAL or Nearby ONLY)
Position Type- Contract
Â
Visa – H1B, H4-EAD, GC-EAD, L2 EAD, TN EAD, USC only
GC on W2 only
Â
Â
Job Description :
Â
 Â
Role:
- Technical Strategic Role.
- 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
Â
Skill Matrix
|
Skills |
Years of Experience |
Candidate Self Rating (Scale of 1 to 5) |
|
Power BI |
 |
 |
|
GIT |
 |
 |
|
Bitbucket |
 |
 |
|
Microstrategy |
 |
 |
|
ETL/ELT |
 |
 |
|
SQL |
 |
 |
|
RLS |
 |
 |
|
DAX |
 |
 |
Â
Â
Thanks & Regards
Vivek Verma | Executive Recruitment
TekIntegral Inc | 555 Republic Drive, Suite 240 Plano, TX USA 75074