Data Scientist II (Power BI & VBA)

FIS; Pune District, Chennai District; Hybrid; INR 800,000 - 1,200,000; Full time

Job summary

FIS in Pune seeks a data reporting specialist to compile and present complex data from multiple sources, ensuring accuracy and integrity of supporting database information. You will design processes to retrieve data and create efficient queries and reports.

The role requires strong Advanced Excel and VBA skills, collaboration to improve controls, and the ability to produce SOPs and resolve process issues while meeting SLA targets.

Qualifications

• Minimum 5-year experience required in Advanced Excel skill and VBA with professional level proficiency.
• Working closely with the team to identify process needs and opportunities for improving controls in processes.
• Responsible for review of multiple processes and creating and maintaining SOP documents.
• Raise any process related issues on time and collaborate with relevant teams to resolve them.
• Meet or exceed SLA targets for TAT, productivity, and quality.

Responsibilities

• Research, compiles, analyzes, and reports operational data from multiple sources.
• Meets with report users to determine requirements and designs data retrieval processes.
• Creates queries and reports using reporting tools to improve departmental efficiency.
• Extracts information from databases in formats such as CSV, Excel, XML, and others.
• Converts data into back-end databases like SQL and MS Access.

Skills

Advanced Excel

VBA

Data analysis

SQL

MS Access

Communication

Tools

SQL

MS Access

Job description

Are you curious, motivated, and forward-thinking? At FIS youll have the opportunity to work on some of the most challenging and relevant issues in financial services and technology. Our talented people empower us, and we believe in being part of a team that is open, collaborative, entrepreneurial, passionate and above all fun.

Job Description Summary

Report complex data from multiple sources. Maintain accuracy and integrity of supporting database information.

What you will be doing:

• Research, compiles, analyzes, and reports various operational data from multiple sources including unit production, productivity and/or quality statistics.
• Meets with report users, determines report requirements, understands where data is located and designs processes to retrieve data.
• Creates queries and reports through use of reporting tools to create efficiencies within the department.
• Extracts information from databases in a variety of different formats such as DBIV, csv, txt, .xls, XML, FW, SAS, .RTF etc.
• Converts and stores data from sources into back-end databases such as SQL and Access.
  

What you bring:

• Minimum 5-year experience required in Advanced Excel skill and VBA is required with professional level profeciency.
• Working closely with the team to identify process needs and opportunities for improving controls in processes.
• Candidate will be responsible for review of multiple processes and will also be responsible for creating and maintaining process level documents like SOP.
• Candidate will be responsible to raise any process related issues on time and work with relevant team to get it resolved.
• Consistently meet or exceed target goals for SLA parameters of TAT, productivity, quality, etc.
• Consistently meet or exceed target goals for SLA parameters of TAT, productivity, quality, etc.
• Communicate and follow-up with internal/ external customers via phone or email for specific assignments
• Review, research and provide feedback on discrepancies for assigned processes

What we offer you:

• A multifaceted job with a high degree of responsibility and a broad spectrum of opportunities
• A broad range of professional education and personal development possibilities - FIS is your final career step!
• A competitive salary and benefits
• A variety of career development tools, resources and opportunities

With a 50-year history rooted in the financial services industry, FIS is the world's largest global provider dedicated to financial technology solutions. We champion clients from banking to capital markets, retail to corporate and everything touched by financial services. Headquartered in Jacksonville, Florida, our 53,000 worldwide employees help serve more than 20,000 clients in over 130 countries. Our technology powers billions of transactions annually that move over $9 trillion around the globe. FIS is a Fortune 500 company and is a member of Standard & Poor’s 500 Index. FIS is committed to protecting the privacy and security of all personal information that we process in order to provide services to our clients. For specific information on how FIS protects personal information online, please see the FIS Online Privacy Notice