Data Modeler

3 months ago

Gurugram, 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+ 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 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

    1 month ago

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

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

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

    2 months ago

    gurugram, 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 months ago

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

    4 months ago

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

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

    4 months ago

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

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

    6 months ago

    Gurugram, Haryana, India Coforge Ltd. Full time

    **Title - Data Modeler** **Duration: Full Time** **Location: Gurugram/Gurgaon (WFO)** - Responsibilities - Data analysis to understand the data and relationship in source systems - Updating and optimizing local and metadata models - Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data...

  • Data Modeler

    6 months ago

    Gurugram, Haryana, India CALLISTOFUSION Full time

    Hi, We have a 6-month contract (with the possibility of extension) for the **Data Modeler** for location **Gurugram Haryana (On-site)**. Please find below the job description for the same: **Job Title: Data Modeler** **Location: Gurugram Haryana (On-site)** **Duration: 6-month contract (with the possibility of extension)** **Annual Salary Expectation:...

  • Statusneo - Data Modeller

    3 weeks ago

    Gurugram, India Nexthire Full time

    Role -Data Modeller Experience - 6+ Yrs Location- Gurgaon,Chennai,Bangalore,Pune Job Description We're looking for candidates with strong technology and data understanding in data modelling space, having proven delivery capability. This is a fantastic opportunity to be part of a leading firm as well as...

  • Data Modeler

    6 months ago

    Gurugram, Haryana, India S&P Global Full time

    **About the Role**: **Grade Level (for internal use)**: 10 **Location**: Gurgaon, India **What You’ll Do**: We are seeking a talented and experienced Data Modeler to join our Data Management team and play a critical role in shaping our data infrastructure and strategy. As a Data Modeler, you will be responsible for designing, building, and maintaining our...

  • Fractal | Data Modeler | gurugram

    1 month ago

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

  • Fractal | Data Modeler | gurugram

    1 month ago

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

    2 months ago

    Gurugram, India BLJ Tech Geeks Full time

    Job Title : Data Modeler Job Summary :We are seeking an experienced Data Modeler to join our dynamic team. The ideal candidate will be responsible for developing and maintaining robust data models that meet our business requirements and enhance our data infrastructure. You will work closely with stakeholders to ensure that data models are scalable,...

  • Associate, Data Modeling

    6 months ago

    Gurugram, Haryana, India BlackRock Full time

    Description About this role As a data modeler, you will be working closely with SME’s. data architects, data analysts and data/software engineers to design/implement data modeling solutions for domains with respect to financial services. To ensure success as a data modeler, you should have in-depth knowledge of data warehousing, as well as expert...

  • Principal Consultant

    5 months ago

    Gurugram, India Genpact Full time

    Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. Powered by our purpose – the relentless pursuit of a world that works better for people –...

  • Data Modeler

    2 months ago

    Gurugram, India Acme Services Full time

    Job Description :- Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms.- Implement business and IT data requirements through new data strategies and designs across all data platforms (relational & dimensional - MUST...

  • Data Modeler

    4 weeks ago

    Gurgaon / Gurugram, Hyderabad / Secunderabad, Telangana, India Zeonova Software Technologies LLP Full time

    #Hirinh-Data Modeler##Skills- Data modeling, AQUA data studio, Python, Py spark, Documentation, SQL, Data Analysis, AWS tech stack, Aws-Redshift, ETL#Exp- 8 Years to 12 Years#Location-Pune, Hyderabad, Gurgram, Hybrid#NP- Immediate to 30 days# Please do share your cv #[HIDDEN TEXT] with details below-CTCECTCNP- Current location / Prefer Location.