What are the responsibilities and job description for the Power BI Developer position at Rivago infotech inc?
Role: Power BI Developer
Location: Iselin, NJ (Hybrid)
Role:
· Technical Strategic Role.
· SPOC at customer site, leading technical delivery for BI transformation initiative - MSTR to PowerBI
· Collaborate and assist the customer in defining the strategy for report framework architecture.
· Analyze existing MicroStrategy Reports and suggest and implement migration plan to Power BI
· Develop and maintain Power BI dashboards, reports and datasets.
· 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
Salary : $60 - $62