Data Modeler

1 month ago

gurgaon, India Sun Life Full time
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 insuranceInvestments.
Mutual funds, segregated funds, annuities, and guaranteed investment productsAdvice.
Financial planning and retirement planning servicesAsset management.
Pooled funds, institutional portfolios, and pension funds.
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.
Qualification
A University degree/ Post Graduation in Computer Science / Mathematics5 to 10 years Years of experience in data modeling, designing Operational data store and 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.Knowledge of relational database like Oracle, PostgreSQL or MS SQL Server.Ability to write complex SQL for data transformations and data profiling in source and target systemsPossess a combination of solid business knowledge and technical expertise with strong communication skill.Demonstrate excellent analytical and logical thinking.Strong problem-solving capabilities; ability to come up with solutions for complex business problemSolid experience with Data Warehouse and BI systemsExtensive experience for collecting business requirements from customers, and transform the requirements into DB data processes and database schema.
Roles and Responsibility
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 to 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.Knowledge on IFRS standard for insurance domainActs as a bridge between development and business team to support the successful delivery of the development and testing phases of Agile development cycleEffectively elicits, analyzes, verifies, and communicates requirements including business, functional, and nonfunctional requirements.Analyzing insurance IT systems or databases to find the story within the data and then communicating results to senior stakeholders

  • Data Modeler

    1 month ago

    gurgaon, India Fractal Full time

    Role: Data Modeler Location: Delhi NCR / Bangalore / Hyderabad / Pune / Chennai / Coimbatore Key Skills: SQL Data Modeler, ETL, Erwin, Dimensional Data Modelling, DWH Experience Range: 6-13 years We are on a Look out for a Data Modeler with strong knowledge of Data Warehousing, Dimensional Modeling, Star and Snowflake Schema, ETL etc. Key...

  • Data modeler

    1 month ago

    Gurgaon, India Fractal Full time

    Role: Data ModelerLocation: Delhi NCR / Bangalore / Hyderabad / Pune / Chennai / CoimbatoreKey Skills: SQL Data Modeler, ETL, Erwin, Dimensional Data Modelling, DWHExperience Range: 6-13 yearsWe are on a Look out for a Data Modeler with strong knowledge of Data Warehousing, Dimensional Modeling, Star and Snowflake Schema, ETL etc.Key...

  • Data Modeler

    1 month ago

    gurgaon, India Fractal Full time

    Role: Data ModelerLocation: Delhi NCR / Bangalore / Hyderabad / Pune / Chennai / CoimbatoreKey Skills: SQL Data Modeler, ETL, Erwin, Dimensional Data Modelling, DWHExperience Range: 6-13 yearsWe are on a Look out for a Data Modeler with strong knowledge of Data Warehousing, Dimensional Modeling, Star and Snowflake Schema, ETL etc.Key...

  • Data Modeler

    1 month ago

    gurgaon, India Fractal Full time

    Role:Data ModelerLocation:Delhi NCR / Bangalore / Hyderabad / Pune / Chennai / CoimbatoreKey Skills:SQL Data Modeler, ETL, Erwin, Dimensional Data Modelling, DWHExperience Range:6-13 yearsWe are on a Look out for a Data Modeler with strong knowledge of Data Warehousing, Dimensional Modeling, Star and Snowflake Schema, ETL etc.Key Responsibilities:Responsible...

  • Data Modeler

    1 month ago

    Gurgaon, India Fractal Full time

    Role:Data ModelerLocation:Delhi NCR / Bangalore / Hyderabad / Pune / Chennai / CoimbatoreKey Skills:SQL Data Modeler, ETL, Erwin, Dimensional Data Modelling, DWHExperience Range:6-13 yearsWe are on a Look out for a Data Modeler with strong knowledge of Data Warehousing, Dimensional Modeling, Star and Snowflake Schema, ETL etc.Key Responsibilities:Responsible...

  • Data Modeler

    1 month ago

    Gurgaon, India Fractal Full time

    Role: Data Modeler Location: Delhi NCR / Bangalore / Hyderabad / Pune / Chennai / Coimbatore Key Skills: SQL Data Modeler, ETL, Erwin, Dimensional Data Modelling, DWH Experience Range: 6-13 years We are on a Look out for a Data Modeler with strong knowledge of Data Warehousing, Dimensional Modeling, Star and Snowflake Schema, ETL etc. ...

  • Data Modeler

    1 month ago

    gurgaon, India Sun Life Full time

    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,...

  • Data modeler

    2 months ago

    Gurgaon, India Sun Life Full time

    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....

  • Data Modeler

    2 months ago

    Gurgaon, India Sun Life Full time

    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,...

  • Data Modeler

    1 month ago

    Gurgaon, India Sun Life Full time

    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,...

  • Data Modeler

    1 month ago

    gurgaon, India Sun Life Full time

    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,...

  • Data Modeler

    1 month ago

    Gurgaon, India Sun Life Full time

    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,...

  • Data modeler

    1 month ago

    Gurgaon, India Sun Life Full time

    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,...

  • Data Modeller Specialist

    5 days ago

    Gurgaon, Haryana, India Talent21 Management and Shared Service Pvt Ltd Full time

    Job Title: Data Modeller SpecialistWe are seeking a highly skilled Data Modeller Specialist to join our team at Talent21 Management and Shared Service Pvt Ltd. The ideal candidate will have extensive experience in designing Operational data store & data warehouse, with a strong understanding of ETL and data warehouse concepts processes and best practices.Key...

  • Data Modeling Specialist

    3 weeks ago

    Gurgaon, Haryana, India Sun Life Full time

    Are you a data modeling expert looking for a new challenge?About UsSun 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,...

  • Data Modeling Expert

    5 days ago

    Gurgaon, Haryana, India Vintronics Consulting Full time

    Job Title:The Finance Industry has Neglected Billions of Eligible IndividualsAbout UsWe are a mission-driven team of finance, analytics, and technology professionals dedicated to promoting financial inclusion for underserved populations.Role OverviewThis role is responsible for developing, monitoring, and enhancing best-in-class models/algorithms to assess...

  • Senior Data Modeler

    5 days ago

    Gurgaon, Haryana, India SIERA IT SERVICES PRIVATE LIMITED Full time

    Job Description:The Senior Data Modeler will play a key role in designing and implementing data models for analytics and business intelligence solutions at SIERA IT SERVICES PRIVATE LIMITED. This position requires strong technical skills in data modeling, ETL processes, and database management, as well as excellent communication and collaboration...

  • Enterprise Data Modeler

    5 days ago

    Gurgaon, Haryana, India Talent21 Management and Shared Service Pvt Ltd Full time

    Job OverviewTalent21 Management and Shared Service Pvt Ltd is seeking a talented Enterprise Data Modeler to join our team. As an Enterprise Data Modeler, you will be responsible for designing and implementing new data structures to support project teams delivering on ETL, data warehouse design, managing the enterprise data model, the maintenance of the data,...

  • Data Modelling Analyst

    4 weeks ago

    Gurgaon, Haryana, India IGT Solutions Full time

    About IGT Solutions: A dynamic and innovative company, we are committed to delivering exceptional solutions that meet our clients' needs. We are currently seeking a skilled Data Modelling Analyst to join our team.Estimated Salary Range: $120,000 - $180,000 per annum, depending on experience and location.Job Description: We are looking for a highly skilled...

  • Data Modeler and ETL Specialist

    6 days ago

    Gurgaon, Haryana, India Unifocus Full time

    About the RoleWe are seeking a highly skilled Data Modeler and ETL Specialist to join our team at Unifocus, an integrated workforce management software platform.Job DescriptionThe ideal candidate will have a strong background in data modeling and ETL processes, with expertise in SQL and proficiency in data modeling techniques. They will be responsible for...