Data Modeler and Business Analyst

1 week ago


Gurgaon, Haryana, India Sun Life Full time
Job Description
Sun Life, a leading financial services company with 157 years of history, is seeking an experienced Data Modeler and Business Analyst. This role plays a critical part in our company's mission to help clients achieve lifetime financial security and live healthier lives.

The successful candidate will have a strong understanding of data modeling, designing Operational data stores, and data warehouses. Proficiency in tools like Erwin/SAP Power Designer is essential. Strong communication skills and the ability to articulate complex business requirements are also required.

Key Responsibilities:
• Build and maintain standardized data models to report disparate data sets in a reliable, consistent, and interpretable manner.
• Gather, distil, and harmonize data requirements to design coherent Conceptual, logical, and physical data models and associated physical feed formats.
• 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.

About Sun Life
Sun Life is a multinational financial services company that offers a broad range of protection and wealth products and services to individuals, businesses, and institutions. Our company has operations in Canada, the U.S., Asia, the U.K., and other parts of the world. We strive to deliver exceptional client experiences and support their wellness and health management goals.

Requirements
• University degree or Post Graduation in Computer Science/Mathematics.
• 5-10 years of experience in data modeling, designing Operational data stores, and data warehouses.
• Extensive experience in Data Modeling 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 databases 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.

What We Offer
$120,000 - $150,000 per annum, depending on experience.

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


  • Gurgaon, Haryana, India Prudent Technologies and Consulting, Inc. Full time

    About Prudent Technologies and Consulting, Inc.We are a dynamic technology consulting firm seeking an experienced Data Analyst and Business Intelligence developer to join our team. The ideal candidate will have a strong background in data analysis, business intelligence, and software development.Estimated Salary: $120,000 - $180,000 per yearJob...


  • Gurgaon, Haryana, India EXL Full time

    Job OverviewData Scientists play a pivotal role in driving business growth through data-driven insights. As a Lead Data Analyst and Model Developer at EXL, you will be responsible for overseeing client deliverables, analyzing complex data sets, and developing solution design architectures for ML use cases.About the RoleThis is an exciting opportunity to join...


  • Gurgaon, Haryana, India WNS Global Services Full time

    Job DescriptionAt WNS Global Services, we're seeking a skilled Data Analyst to lead our catastrophe modelling efforts. This role is ideal for individuals with a strong background in data analysis and a passion for risk management.About the RoleWe're looking for someone who can perform complex data analyses, identify trends, and develop insights that inform...

  • Data Analyst

    2 weeks ago


    Gurgaon, Haryana, India WNS Global Services Full time

    At WNS Global Services, we're seeking a skilled Data Analyst - Catastrophe Modelling to join our team. As a key member of our Accumulation Management department, you'll work closely with the Technical Solutions team to develop customized tools and databases that streamline processes and organize data efficiently.This is a technical role with significant...


  • Gurgaon, Haryana, India The Economist Full time

    Senior Data Analyst Position OverviewThe Economist Intelligence Unit is a world leader in global business intelligence, helping businesses, the financial sector, and governments understand how the world is changing and creating opportunities to be seized and risks to be managed.We are seeking an experienced Senior Data Analyst to join our international team...


  • Gurgaon, Haryana, India Fractal Full time

    Job Title: Data Architect and ModelerAbout the Role:We are seeking an experienced Data Architect and Modeler to join our team at Fractal.Key Responsibilities:Design and manage data architecture for enterprise analytics ecosystems.Create conceptual, logical, and physical data models.Develop scalable and efficient data models.Maintain data...


  • Gurgaon, Haryana, India StashFin Full time

    Job Overview">This role will work within the Model Development function at StashFin and focus on developing, calibrating, implementing and monitoring risk models across business functions. The successful candidate will bring domain/quantitative best practices to build and implement risk models.Responsibilities:">Develop and implement risk models for lending...


  • Gurgaon, Haryana, India Aditya Consulting Full time

    Data Modeling ExpertiseWe are seeking a highly skilled Senior Data Modeling Expert to join our team at Aditya Consulting. As a key member of our data science team, you will be responsible for designing and implementing advanced data models and algorithms to address consumer problems. This will involve collaborating with cross-functional teams to integrate...


  • Gurgaon, Haryana, India exl Full time

    About the RoleWe are seeking an experienced Data Analyst and Business Development Specialist to join our team. In this role, you will be responsible for gathering business requirements from various stakeholders, creating process flow diagrams, and translating client needs into data product user stories.ResponsibilitiesGather business requirements and...


  • Gurgaon, Haryana, India United Airlines Full time

    Job DescriptionWe are seeking a highly skilled Business Intelligence Analyst to join our team in United Airlines. As a Business Intelligence Analyst, you will play a critical role in driving business growth by providing data-driven insights and recommendations.Responsibilities:Develop and maintain complex SQL queries to extract large datasets from various...


  • Gurgaon, Haryana, India Acuity Knowledge Partners Full time

    Job Description">A Data Analyst and Business Insights Specialist at Acuity Knowledge Partners will be responsible for delivering high-quality data analysis and insights to support business decisions. With a strong focus on financial modeling, data visualization, and stakeholder communication, this role is ideal for individuals who excel in extracting...


  • Gurgaon, Haryana, India American Express Full time

    At American Express, we're committed to providing the world's best customer experience every day. As a Field Tools, Analytics & Insights Sr. Analyst on our Sales Enablement, Pricing & Transformation team, you'll play a critical role in helping us achieve this goal.We're seeking a highly motivated and detail-oriented individual to join our team. As a Business...


  • Gurgaon, Haryana, India Absolutdata Full time

    Transform your career with a Senior Business Analyst role at Absolutdata.We are seeking an experienced Senior Business Analyst to join our team, specializing in marketing analytics and MMM. This is an exciting opportunity to leverage your skills in data analysis, statistical modeling, and business acumen to drive business growth and customer engagement.About...

  • Data Analyst

    4 weeks ago


    Gurgaon, Haryana, India Egon Zehnder Full time

    About Egon ZehnderEgon Zehnder is a leading Executive Search firm, trusted advisor to many of the world's most respected organizations. With over 400 consultants and 69 offices in 41 countries, we operate at the Board and senior management level, serving clients across various industries.We are committed to creating an inclusive environment, where everyone...

  • Business Analyst

    3 weeks ago


    Gurgaon, Haryana, India RSM Full time

    RSM, the leading provider of professional services to the middle market globally, is seeking a talented Business Analyst to join its Deal Analytics team within Transaction Advisory Services. Our purpose is to empower clients and people to realize their full potential by instilling confidence in a world of change.As a Business Analyst, you will play a crucial...


  • Gurgaon, Haryana, India Connexions Full time

    Job Title : Senior Analyst, Risk & Portfolio ManagementCompany : ConnexionsOverview :At Connexions, we are seeking a highly skilled Senior Analyst to support our risk management and portfolio strategy initiatives. As a key member of our team, you will play a critical role in driving business growth while ensuring the highest level of risk performance.Key...


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


  • Gurgaon, Haryana, India Real Time Data Services Full time

    Job SummaryWe are seeking a highly skilled Senior Business Intelligence Analyst to join our team at Real Time Data Services. As a key member of our marketing department, you will be responsible for delivering actionable insights and data-driven recommendations to drive business growth.About the Role:Coordinate with the Business Intelligence team to create...


  • Gurgaon, Haryana, India Jivo Full time

    About Jivo: A health-tech platform that brings together international doctors and Indian healthcare excellence for transformed cross-border delivery. Founded by IIT Delhi and MAMC alumni, Jivo solves big problems with real global impact.**Job Overview:** We are seeking a detail-oriented data-driven Business MIS Analyst to play a critical role in designing,...