Data modeler

2 days 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 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.
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 / Mathematics
- 5 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, Postgre SQL or MS SQL Server.
- Ability to write complex SQL for data transformations and data profiling in source and target systems
- Possess 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 problem
- Solid experience with Data Warehouse and BI systems
- Extensive 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 domain
- Acts as a bridge between development and business team to support the successful delivery of the development and testing phases of Agile development cycle
- Effectively 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

    5 months ago

    Gurgaon, India Luxoft Full time

    **Project** Description**: A large Australian financial institution has engaged us to provide resources for their Financial Crime Data and Intelligence Platforms. We are seeking a motivated Senior Data Modeling Engineer to join the Financial Crime Data and Intelligence Platforms team. As a Senior Data Engineer, you will be working in a cross-functional...

  • Data Modeler

    5 months ago

    Gurgaon, India NR Consulting - India Full time

    Role - Data Modeler (Data Modeler + Data Engineer) Experience: 4.5+ Years Location : Remote Notice Period: Immediate (10 Days Max) Job description: **Data Modeller skills as below**: - Responsible for designing, deploying, and maintaining Data models for DWL Layer. - Responsible for creating STM and Data Models (ER Model) for every single Entity. -...

  • Data modeler

    3 weeks ago

    Gurgaon, India Talent Toppers Full time

    Data Modeler will design data model solutions and ensure alignment between business and IT strategies, operating models, guiding principles, and software development with a focus on the information layer. Key Responsibilities • Perform gap analysis between current data structures and target data structures. • Enhance and maintain the Enterprise...

  • Data Modeler

    3 weeks ago

    Gurgaon, Haryana, India Talent Toppers Full time

    Data Modeler Job DescriptionTalent Toppers is seeking a skilled Data Modeler to join our team. As a Data Modeler, you will play a crucial role in designing data model solutions and ensuring alignment between business and IT strategies.Key Responsibilities:Perform gap analysis between current data structures and target data structures.Enhance and maintain the...

  • Data Modeller

    2 weeks ago

    Gurgaon, Haryana, India HuQuo Consulting Pvt. Ltd. Full time

    About the RoleHuQuo Consulting Pvt. Ltd. is seeking a highly experienced Data Modeller to join our team. The ideal candidate will have a strong background in data modelling, data architecture, and data warehousing.Key ResponsibilitiesThe successful candidate will be responsible for:Designing and implementing data models for complex business...

  • Data Modeler

    3 weeks 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

    3 weeks 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

    3 days 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

    3 days 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 day 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...

  • Senior Data Modeller

    1 week ago

    Gurgaon, Haryana, India Unifocus Full time

    Data Engineer (ETL and Data Modelling) RoleAbout UnifocusAt Unifocus, we are a cutting-edge workforce management software platform that aims to revolutionize the hospitality market with our innovative solutions. We are seeking a highly skilled Data Engineer to join our team and contribute to our mission of leveraging data to drive meaningful insights and...

  • Data Model Architect

    1 week ago

    Gurgaon, Haryana, India Canara HSBC Life Insurance Full time

    Cloud Data Model Development:As a Senior Data Model Architect at Canara HSBC Life Insurance, you will lead the design and development of data pipelines using PySpark, collaborating with data engineers and analysts to integrate data from various sources. Your expertise will be instrumental in implementing data transformations, aggregations, and enrichment...

  • Data Modeler Lead

    3 weeks ago

    Gurgaon, Haryana, India Canara HSBC Life Insurance Full time

    Data Modeler & Data Pipeline DevelopmentAs a Data Modeler & Data Pipeline Development professional at Canara HSBC Life Insurance, you will play a key role in designing and implementing data processing pipelines using PySpark. You will collaborate with data engineers and analysts to integrate data from various sources, implement data transformations,...

  • Data Modeler Lead

    3 weeks ago

    Gurgaon, Haryana, India Canara HSBC Life Insurance Full time

    Data Modeler & Data Pipeline DevelopmentAt Canara HSBC Life Insurance, we're seeking a highly skilled Data Modeler to join our team. As a Data Modeler, you will be responsible for designing and developing data models in Google Cloud Platform (GCP) and adhering to enterprise standards.Key Responsibilities:Design and develop data models in GCP, ensuring data...

  • Data Modeler Specialist

    3 weeks ago

    Gurgaon, Haryana, India Talent Toppers Full time

    Data Modeler Job DescriptionTalent Toppers is seeking a skilled Data Modeler to join our team.Key Responsibilities:Perform gap analysis between current data structures and target data structures.Enhance and maintain the Enterprise Information Model.Work with service architects and application architects to assist with the creation of proper data access and...

  • Data Modeler Lead

    3 weeks ago

    Gurgaon, Haryana, India Canara HSBC Life Insurance Full time

    Data Model Development and Pipeline EngineeringWe are seeking a highly skilled Data Modeler to lead the development of our data pipelines and models in Google Cloud. The ideal candidate will have a strong understanding of distributed computing principles and experience with data modeling, ETL processes, and data warehousing.Key Responsibilities:Design and...

  • Data Modeler

    2 days ago

    gurgaon, India Tekgence Inc Full time

    1 of our MNC client is hiring Erwin Data Modelers on an urgent basis. Kindly find below the details for your reference. Role: Erwin Data Modeler Experience: 6+ Years Notice Period: Immediate - 30 days Budget: 28 - 30 LPA max No. of positions: 2 Mandate Skill:- Data Modeling experience with Erwin tool. Note: Candidates whose experience matches the above...

  • Data modeler

    3 days ago

    Gurgaon, India Tekgence Inc Full time

    1 of our MNC client is hiring Erwin Data Modelers on an urgent basis. Kindly find below the details for your reference.Role: Erwin Data ModelerExperience: 6+ YearsNotice Period: Immediate - 30 daysBudget: 28 - 30 LPA maxNo. of positions: 2Mandate Skill:-Data Modeling experience with Erwin tool.Note: Candidates whose experience matches the above skill only to...

  • Data Modeler

    6 days ago

    Gurgaon, India Tekgence Inc Full time

    1 of our MNC client is hiring Erwin Data Modelers on an urgent basis. Kindly find below the details for your reference.Role: Erwin Data ModelerExperience: 6+ YearsNotice Period: Immediate - 30 daysBudget: 28 - 30 LPA maxNo. of positions: 2Mandate Skill:-Data Modeling experience with Erwin tool.Note: Candidates whose experience matches the above skill only to...

  • Data Engineer

    3 weeks ago

    Gurgaon, Haryana, India Unifocus Full time

    About UnifocusUnifocus is an integrated workforce management software platform offering intelligent automation for daily work orders management, housekeeping activities, facility maintenance, survey solutions, scheduling & labour management, and time & attendance built for the hospitality market and other dynamic scheduling environments.Job DescriptionWe are...