Metrics and Reporting Analyst

The Reporting Analyst is responsible for creating, maintaining, and continuously improving reporting systems that provide critical business insights. The ideal candidate will have a strong foundation in data analysis, proficiency in reporting tools, and the ability to communicate findings clearly to stakeholders across the organization.

Requirements

• Proven experience in a reporting or data analysis role.
• Experience in design, develop and deployment of rich Graphic visualizations with Drill Down and Drop up options using Power BI
• Experience in creating Power BI Reports using multiple sources
• Experience with all types of transformations that are available in Power BI query editor
• Experience with Scheduled Automatic refresh and scheduling refresh in power bi service along with using Power BI gateway
• Strong End to end experience in designing and deploying data visualizations using Power BI
• Experience in using Python and R scripts in Power BI dashboards
• Experience with Advanced Reporting and Dashboards in Power BI
• Strong proficiency in MS SQL Server and prior experience in MS SQL Server performance tuning- Advanced knowledge of T-SQL, including transactions, error handling, CTEs, Row_Number/Over, hierarchical data sets.
• Excellent understanding of indexes, locks, execution plans and file stats-
• Should have a working knowledge about load balancing- Adhere to coding standards and produce high quality code.
• Experienced as MS SQL Server Database developer - Programming stored procedures, views and functions. - SQL server performance tuning. - Designing & developing database tables.- Creating & tweaking indexes.
• Ensure smooth ETL and data flows execution, data assembly, cleansing, validation, data modelling and documentation
• Strong analytic mindset and logical thinking capability, strong QC mindset
• ServiceNow Reporting with solid understanding of ServiceNow data model will be plus.

Benefits

• Competitive salary
• Continuous learning: You’ll develop the mindset and skills to navigate whatever comes next.
• Success as defined by you: We’ll provide the tools and flexibility, so you can make a meaningful impact, your way.
• Transformative leadership: We’ll give you the insights, coaching and confidence to be the leader the world needs.
• Diverse and inclusive culture: You’ll be embraced for who you are and empowered to use your voice to help others find theirs.