Data Analyst Lead

  • Bengaluru
  • Voya India
About the job About Voya India: Voya India is a wholly owned subsidiary of U.S. financial services company Voya Financial who is a leading health, wealth, and investment company. We deliver innovative solutions to Voyas Retirement, Employee Benefits, and Investment Management businesses.

Role : Data Analyst Lead

Years of experience : 7 years as Data analyst and previous relevant experience as data or application developer or equivalent. Role explanation In a large enterprise eco system, with data flowing from multiple data sources like heterogenous databases, ODS, Datawarehouse, mainframe record keeping systems etc., understanding the business and technical background of any data field is critical for application developers. This person is responsible of helping the application developers and testers to understand the data flowing from the source system, explain the importance and business background of the data flowing to the application, validating the quality of the data and creating respective documentation. This person would be analyzing and understanding the entire flow of data from the origination system, multiple ETL phases it goes through, until the data is consumed to the concerned application and articulate and document the details, and making sure the quality and type of data is appropriate to consume and integrate with application.

Job Duties Understanding of Sourcing requirements of different source systems data. Prepare the ETL mapping Specification document by understanding the transformation rule. Perform Data analysis and discuss with SMEs for more clarification. Actively participate in meetings with Technical and Business SMEs to provide solutions. Help the team with technical challenges and make them understand the functional requirement. Understanding and working with data quality team to define data quality rules for them.

Experience & Skillset 8 to 12 years of overall experience 5 years as a Data Analyst in a complex eco-system Should have data development experience in any RDBMS like Oracle, SQL with Query, Stored Procedures experience. Should have good experience in any ETL development with any tool like SSIS, Informatica, Oracle Data Integrator etc., Excellent knowledge around Data quality, Data Types, Data Integration, Enterprise data management, Data warehouse concepts, ODS concepts, Data Architecture etc.,