Sr Data Modeler

You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.

Job Description:

Senior Data Modeler

Are you ready to shine?

At Sun Life, we empower you to be your most brilliant self.

Who we are?

Sun Life is a leading financial services company with 157 years of history that helps our clients achieve lifetime financial security and live healthier lives.

We serve millions in Canada, the U.S., Asia, the U.K., and other parts of the world. We have a network of Sun Life advisors, third-party partners, and other distributors. Through them, we’re helping set our clients free to live their lives their way, from now through retirement. We’re working hard to support their wellness and health management goals, too. That way, they can enjoy what matters most to them. And that’s anything from running a marathon to helping their grandchildren learn to ride a bike.

To do this, we offer a broad range of protection and wealth products and services to individuals, businesses, and institutions, including:

• Insurance. Life, health, wellness, disability, critical illness, stop-loss, and long-term care insurance
• Investments. Mutual funds, segregated funds, annuities, and guaranteed investment products
• Advice. Financial planning and retirement planning services
• Asset management. Pooled funds, institutional portfolios, and pension funds

With innovative technology, a strong distribution network and long-standing relationships with some of the world’s largest employers, we are today providing financial security to millions of people globally.

Sun Life is a leading financial services company that helps our clients achieve lifetime financial security and live healthier lives, with strong insurance, asset management, investments, and financial advice portfolios. At Sun Life, our asset management business draws on the talent and experience of professionals from around the globe.

Sun Life Global Solutions (SLGS)

With 32 years of operations in the Philippines and 17 years in India, Sun Life Global Solutions, (formerly Asia Service Centres), a microcosm of Sun Life, is poised to harness the regions’ potential in a significant way - from India and the Philippines to the world. We are architecting and executing a BOLDER vision: being a Digital and Innovation Hub, shaping the Business, driving Transformation and superior Client experience by providing expert Technology, Business and Knowledge Services and advanced Solutions. We help our clients achieve lifetime financial security and live healthier lives – our core purpose and mission. Drawing on our collaborative and inclusive culture, we are reckoned as a ‘Great Place to Work’, ‘Top 100 Best Places to Work for Women’ and stand among the ‘Top 11 Global Business Services Companies’ across India and the Philippines.

The technology function at Sun Life Global Solutions is geared towards growing our existing business, deepening our client understanding, managing new age technology systems, and demonstrating thought leadership. We are committed to building greater domain expertise and engineering ability, delivering end to end solutions for our clients, and taking a lead in intelligent automation. Tech services at Sun Life Global Solutions have evolved in areas such as application development and management, Support, Testing, Digital, Data Engineering and Analytics, Infrastructure Services and Project Management.

We are constantly expanding our strength in Information technology and are looking for fresh talents who can bring ideas and values aligning with our Digital strategy.

Our Client Impact strategy is motivated by the need to create an inclusive culture, empowered by highly engaged people. We are entering a new world that focuses on doing purpose driven work. The kind that fills your day with excitement and determination, because when you love what you do, it never feels like work. We want to create an environment where you feel empowered to act and are surrounded by people who challenge you, support you and inspire you to become the best version of yourself. As an employer, we not only want to attract top talent, but we want you to have the best Sun Life Experience.

We strive to Shine Together, Make Life Brighter & Shape the Future!

What will you do?

The Data Modeler will work towards design and implementation of new data structures to support the project teams delivering on ETL, Data warehouse design, managing the enterprise data model, the maintenance of the data, and enterprise data integration approaches.

Our engineering career framework helps our engineers to understand the scope, collaborative reach, and levers for impact at every job role and defines the key behaviors and deliverables specific to one’s role and team and plan their career with Sun Life.

Your scope of work / key responsibilities:

• Build and maintain out of standards data models to report disparate data sets in a reliable, consistent and interpretable manner.
• Gather, distil and harmonize data requirements and to design coherent Conceptual, logical and physical data models and associated physical feed formats to support these data flows.
• Articulate business requirements and build source-to-target mappings having complex ETL transformation.
• Write complex SQL statements and profile source data to validate data transformations.
• Contribute to requirement analysis and database design - Transactional and Dimensional data modelling. Normalize/ De-normalize data structures, introduce hierarchies and inheritance wherever required in existing/ new data models.
• Develop and implement data warehouse projects independently.
• Work with data consumers and data suppliers to understand detailed requirements, and to propose standardized data models.
• Contribute to improving the Data Management data models.
• Be an influencer to present and facilitate discussions to understand business requirements and develop dimension data models based on these capabilities and industry best practices.
• Understanding of Insurance Domain
• Basic understanding of AWS cloud
• Good understanding of Master Data Management, Data Quality and Data Governance.
• Basic understanding of data visualization tools like SAS VA, Tableau
• Good understanding of implementing & architecting data solutions using the informatica, SQL server/Oracle

Key Qualifications and experience:

• Extensive practical experience in Information Technology and software development projects of with at least 8+ years of experience in designing Operational data store & data warehouse.
• Extensive experience in any of Data Modelling tools – Erwin/ SAP power designer.
• Strong understanding of ETL and data warehouse concepts processes and best practices.
• Proficient in Data Modelling including conceptual, logical and physical data modelling for both OLTP and OLAP.
• Ability to write complex SQL for data transformations and data profiling in source and target systems
• Basic understanding of SQL vs NoSQL databases.
• Possess a combination of solid business knowledge and technical expertise with strong communication skills. Demonstrate excellent analytical and logical thinking.
• Good verbal & written communication skills and Ability to work independently as well as in a team environment providing structure in ambiguous situation.

Primary Location: Gurugram

Job Category:

Posting End Date: