Role overview

The objective of the role is to contribute towards the setup of a newly centralised Reporting and Business Intelligence (BI) team withing Retirement solutions (SS) Share Services. The role is required to work collaboratively with the RS stakeholders to develop new more automated and insightful reporting processes, using tools such as SQL, Power BI and Fabric.

• Gather business requirements in BI context and design BI solutions, and data models to transform complex raw data into meaningful interactive insights.
• Develop and maintain dashboards and interactive visual reports using Power BI, including performing DAX queries, Power Query and functions in Power BI App and Service.
• Work directly with stakeholders team members in the UK and India and built strong trusting relationships to ensure requirements are understood and collaborative solution delivery is achieved.
• Develop new data access processes, ETL and Storage processes including cloud based, with connection to Power BI.
• Writing and developing SQL scripts from scratch and working with complex SQL databases.
• Develop new Microsoft Fabric solution to drive data and reporting.
• Work with complex excel tools, spreadsheets and functions.
• Analyse and cleanse source system data to ensure it s accurate, consistent and reportable.
• Work on multiple complex projects simultaneously, ensuring all work is planned, documented and delivered to high standard on time.
• Design detailed project/develop plans and capture in core tools such as Jira day to day.
• Document process, models, designs, and solutions.
• Drive business and client decision marking through standardisation and optimisation of all internal and client reports.

Skill requirement

Hard skills include strong knowledge and experience with:

• Strong communication skills in English at fluent business level is essential.
• Extensive experience designing, building and maintaining Power BI dashboards (Desktop App Service), including DAX and Power Query.
• Strong experience SQL script writing and database management.
• Strong Microsoft Excel Experience.
• Experience with Microsoft Fabric advantageous.
• Good knowledge of testing approaches/methods, and experience of devising and running testing procedures

We are committed to equality of opportunity for all staff and applications from individuals are encouraged regardless of age, disability, sex, gender reassignment, sexual orientation, pregnancy and maternity, race, religion or belief and marriage and civil partnerships. Please note any offer of employment is subject to satisfactory pre-employment screening checks.

Role: Analytics Consultant

Industry Type: Financial Services

Department: Data Science & Analytics

Employment Type: Full Time, Permanent

Role Category: Business Intelligence & Analytics

Education

UG: Any Graduate

PG: Any Postgraduate

About the company

EQ India team provides BPO, IT development & testing and other operational support such as marketing, HR & Payroll and learning & development to various EQ Group companies and clients of EQ.

EQ India is a Centre of Excellence and we showcase integrity and openness in our dealings with our clients. A key element of culture and business practices of the EQ India is that it incorporates similar DNA and values. Our team in India manages a number of activities across various services, completing numerous transactions yearly.

A structured and robust transition plans are designed every time a new project is offshored to the business. During implementation of the project plan, a road map is adopted to complete the transition and track every milestone achieved. Once the initial transition is complete our team in Chennai work in partnership with our UK team to ensure the best customer service is maintained. Transition of any new work is formally documented. With due diligence at the heart of the transition, all new work is formally signed off through a rigorous Go- Live process.