Senior Analyst - Data Analytics

Darwinbox Digital Solutions Pvt. Ltd.; Chennai District; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Apex Group Ltd. seeks an experienced Data Modeler to design and maintain robust data models that support analytics, reporting, and AI initiatives across the data platform.

You will work with data engineers and stakeholders to translate requirements into logical/physical models, ensure governance, and optimize performance.

Key focus areas include Snowflake integration, semantic models for Power BI, and data vault and dimensional methods; experience with DBT and ERwin is a plus.

Qualifications

• Minimum 5 years in data modelling, data architecture, or data engineering.
• Strong SQL skills and hands-on Cloud data platforms experience.
• Experience designing semantic models for BI tools like Power BI.
• Familiarity with data governance, ETL/ELT, and data lineage.

Responsibilities

• Design conceptual, logical, and physical data models for analytics use cases.
• Collaborate with stakeholders to translate requirements into robust data models.
• Define and maintain modeling standards, naming conventions, and best practices.
• Implement data models with Snowflake and other platforms with data engineers.
• Develop semantic models to support self-service analytics in Power BI.
• Review, optimize, and document data models for performance and governance.
• Ensure model integrity and compatibility with data governance policies.

Skills

SQL

Dimensional modelling

Data vault

Power BI

DBT

Data modeling

Communication

Education

Bachelor's degree in Computer Science/Information Systems

Tools

Snowflake

ERwin

Power BI

DBT

Job description

Designation :Senior Analyst - Data Analytics

Level : L2

Experience : 5 to 7 Years

Job Description

Role: Data Modeler

Department: Data Office

About Apex

Apex Group Ltd., established in Bermuda in 2003, is a global financial services provider. With over 80 offices in 70 countries worldwide and more than 12,000 employees, Apex Group delivers an expansive range of services to asset managers, financial institutions, private clients and family offices. The Group has continually improved and evolved its capabilities to offer a single-source solution through establishing the broadest range of services in the industry; including fund services, digital onboarding and bank accounts, depositary, custody, super ManCo services, corporate services including HR and Payroll and a pioneering ESG Ratings and Advisory solution. Apex Group’s purpose is to be more than just a financial services provider and is committed to driving positive change to address three core areas; the Environment and Climate Change, Women’s Empowerment and Economic Independence, Education and Social Mobility.

Life at Apex isn't just about the work you do, it's about embracing the culture and loving what you do. Every employee plays a part in making Apex who we are today and the more that we grow, the more important that becomes. Whatever your career path or specialism Apex ensures it rewards loyal and dedicated employees. The international nature of our business and global network of offices means that there are opportunities to broaden your life experiences and take both short-term or permanent relocation options.

Job Specification

We are seeking an experienced Data Modeler to design and maintain robust, scalable data models that support Apex Group's analytics, reporting, and AI initiatives. As the Data Modeler, you will work closely with data engineers, analysts, and business stakeholders to translate business requirements into logical and physical data models that ensure consistency, performance, and ease of use across the data platform.

Responsibilities:

• Design conceptual, logical, and physical data models to support enterprise data products and analytics use cases.
• Collaborate with business stakeholders to gather and translate requirements into well-structured data models.
• Define and maintain data modelling standards, naming conventions, and best practices across the organization.
• Work closely with data engineers to implement data models within Snowflake and other data platforms.
• Develop and maintain semantic models to support self-service analytics and reporting in Power BI.
• Review and optimize existing data models for performance, scalability, and maintainability.
• Ensure data models align with data governance policies and support data lineage and traceability.
• Document data models, including entity relationship diagrams, data dictionaries, and metadata.
• Partner with the Data Quality and Data Governance teams to ensure model integrity and consistency.
• Support the evolution of data models to accommodate new business requirements and data sources.
• Provide guidance and review support to data engineers implementing model changes.
• Stay current with modern data modelling techniques, including dimensional modelling and data vault methodologies.

Requirements:

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 5+ years of experience in data modelling, data architecture, or data engineering roles.
• Strong expertise in dimensional modelling, normalization, and data vault methodologies.
• Advanced SQL skills, with hands‑on experience in cloud data platforms such as Snowflake.
• Experience designing semantic models for BI tools such as Power BI.
• Familiarity with data transformation tools such as DBT.
• Solid understanding of data warehousing concepts, ETL/ELT processes, and data governance principles.
• Strong analytical and problem‑solving skills, with the ability to balance business needs and technical constraints.
• Excellent documentation skills, including data dictionaries and entity relationship diagrams.
• Strong communication skills, with the ability to explain complex modelling concepts to non‑technical stakeholders.
• Proven ability to manage multiple modelling projects simultaneously.
• Experience collaborating with cross‑functional teams to align data models with evolving business needs.
• Strong understanding of the trade‑offs between normalized and denormalized model designs.

Preferred Qualifications:

• Experience with data modelling tools such as ERwin, ER/Studio, or similar.
• Familiarity with AI/ML use cases and how data models support feature engineering.
• Experience working in financial services or a similarly regulated industry.
• Knowledge of data cataloguing and metadata management tools.
• Relevant certifications in data modelling or data architecture.

What you will get in return:

A genuinely unique opportunity to be part of an expanding large global business. Joining Apex Group will provide you with a platform for professional and personal success and an environment where you can truly make an impact.

Our people are our greatest asset and we believe learning is central to developing talent, nurturing strong leaders, fostering a supportive company culture and ultimately drives our success.

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status.