People Analytics Specialist

What success looks like in this role: Job Title:  Data and Analytics Specialist Location: RGA Tech Park, Bengaluru, India Who we are: Unisys is a global information technology company that builds high-performance, security-centric solutions for the most digitally demanding businesses and governments on Earth. Unisys’ offerings include security software and services; digital transformation and workplace services; industry applications and services; and innovative software operating environments for high-intensity enterprise computing. Unisys builds better outcomes securely for its clients across the Government, Financial Services and Commercial markets. For more information, visit www.unisys.com. Our Vision: Enhancing people’s lives through secure, reliable advanced technology. Our Core Beliefs: Curiosity: We embrace the unknown and continuous learning. Creativity: We look past routine ways of doing things. Client-Centricity: Our clients’ success is our success. Integrity: We act ethically and honestly. Position Overview: We are seeking a highly skilled and experienced Data and Analytics Specialist to join our team. As a Data and Analytics Specialist, you will play a pivotal role in our organization, utilizing your 4-6 years of experience in data analysis and reporting to drive insights and inform strategic decision-making. Your expertise in Visier, Workday Reporting, Advanced Excel, Power BI, SQL, Power Query, Power Pivot, and complex formulas will be essential in handling complex datasets, creating advanced data models, and delivering actionable reports and visualizations. Responsibilities: Data Analysis and Interpretation: Analyze large and complex datasets using advanced Excel functions, Power Query, and SQL queries to identify patterns, trends, and insights. Utilize complex formulas in Excel to manipulate and transform data as needed. Interpret the data to provide actionable recommendations to stakeholders. Reporting and Visualization: Develop interactive dashboards and reports using Power BI, Visier, incorporating Power Query and Power Pivot, to present data-driven insights in a clear and compelling manner. Collaborate with stakeholders to understand their requirements and create customized visualizations that effectively communicate key metrics and KPIs. Data Modeling and Manipulation: Design and implement advanced data models using Power Pivot to support reporting and analytics requirements. Utilize Power Query to extract, transform, and load (ETL) data from various sources into a centralized data repository. Transform and cleanse data using complex formulas to ensure accuracy and consistency. Performance Monitoring: Develop and implement monitoring mechanisms to track the performance and effectiveness of data analytics initiatives. Utilize Power Pivot to create advanced calculations and measures. Identify areas for improvement and proactively suggest solutions to enhance efficiency and accuracy.