Data Modeler

Empower Global Business Services India Private Limited; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Empower Global Business Services India Private Limited seeks a data architect to lead architecture, data modeling, and warehouse initiatives in Bengaluru. You will analyze data requirements, design logical and physical models, and optimize performance across diverse systems.

The role involves building data warehouses, managing migrations, and guiding junior staff while collaborating with cross-functional teams. Remote and hybrid work options are available as part of a flexible work environment.

Qualifications

• Bachelor’s degree in Business or Information systems.
• Advanced education preferred.
• 3 years data modeling experience across multiple RDBS.
• 3 years experience modeling data lineage and translations between systems with different data schemas.
• Experience with AWS Database technologies like Postgres, Redshift or Athena.
• Experience with physical / logical data modeling software like Idera Team Studio.

Responsibilities

• Gathers and analyzes data requirements and data flows to other systems.
• Transforming database requirements into logical data models.
• Developing physical data models to define the database structure.
• Optimizing database performance through efficient indexing and table relationships.
• Developing and enhancing the data warehouse and back-end data processing.
• Creating data architectures and logical/physical data models for databases and data warehouses.
• Designing, developing, implementing, and maintaining a data warehouse to integrate data from various sources.
• Developing strategies for data acquisition, archive recovery, and database implementation.
• Managing data migrations/conversions and troubleshooting data processing issues.
• Apply advanced data management knowledge.
• Manage projects independently with limited supervision.
• Coaching and reviewing the work of lower-level professionals.

Skills

Data modeling

Data analysis

Data architecture

Data requirements gathering

Independent work

Education

Bachelor’s degree in Business or Information systems

Advanced education preferred

Tools

AWS Postgres

AWS Redshift

AWS Athena

Idera Team Studio

Job description

Our vision for the future is based on the idea that transforming financial lives starts by giving our people the freedom to transform their own. We have a flexible work environment, and fluid career paths. We not only encourage but celebrate internal mobility. We also recognize the importance of purpose, well-being, and work-life balance. Within Empower and our communities, we work hard to create a welcoming and inclusive environment, and our associates dedicate thousands of hours to volunteering for causes that matter most to them. Chart your own path and grow your career while helping more customers achieve financial freedom. Empower Yourself. Responsible for the development and execution of architectures, policies, practices and procedures in order to manage the information lifecycle needs of an organization in an effective manner and examining organization's data with the purpose of drawing conclusions about that information.

ESSENTIAL FUNCTIONS

• Gathers and analyzes data requirements and data flows to other systems.
• Transforming database requirements into logical data models.
• Developing physical data models to define the database structure.
• Optimizing database performance through efficient indexing and table relationships.
• Spotting trends; writing reports and recommendations for internal or external clients; data modeling Creating data architectures; developing and enhancing the data warehouse; back-end transaction/data processing; and market research professional services.
• Creating data architectures and logical/physical data models for databases and data warehouses.
• Designing, developing, implementing, and maintaining a data warehouse to integrate data from various sources/systems within an organization.
• Developing strategies for data acquisition, archive recovery, and database implementation.
• Managing data migrations/conversions and troubleshooting data processing issues.
• Applies advanced knowledge of job area typically obtained through advanced education and work experience.
• Managing projects / processes Working independently with limited supervision.
• Coaching and reviewing the work of lower-level professionals.

QUALIFICATIONS

• Bachelor’s degree in Business or Information systems
• Advanced education preferred
• 3 years data modeling experience across multiple RDBS
• 3 years experience modeling data lineage and translations between systems with different data schemas
• Experience with AWS Database technologies like Postgres, Redshift or Athena
• Experience with physical / logical data modeling software like Idera Team Studio

This job description is not intended to be an exhaustive list of all duties, responsibilities and qualifications of the job. The employer has the right to revise this job description at any time. You will be evaluated in part based on your performance of the responsibilities and/or tasks listed in this job description. You may be required perform other duties that are not included on this job description. The job description is not a contract for employment, and either you or the employer may terminate employment at any time, for any reason.

We are an equal opportunity employer with a commitment to diversity.

All individuals, regardless of personal characteristics, are encouraged to apply.

All qualified applicants will receive consideration for employment without regard to age, race, color, national origin, ancestry, sex, sexual orientation, gender, gender identity, gender expression, marital status, pregnancy, religion, physical or mental disability, military or veteran status, genetic information, or any other status protected by applicable state or local law.

Remote and Hybrid Positions For remote and hybrid positions you will be required to provide reliable high-speed internet with a wired connection as well as a place in your home to work with limited disruption. You must have reliable connectivity from an internet service provider that is fiber, cable or DSL internet. Other necessary computer equipment will be provided. You may be required to work in the office if you do not have an adequate homework environment and the required internet connection.

Follow Empower Facebook, LinkedIn, X, Instagram, & Glassdoor