What are the responsibilities and job description for the Power BI Developer position at Rivago infotech inc?
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
Salary : $60 - $63