Data Modeler

Empower; Bengaluru; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Empower in Bengaluru, India seeks a Data Architect to design and manage data architectures and data warehouses, enabling accurate insights across the organization.

The role focuses on data modeling, data lineage, and integration across systems using AWS database technologies such as Postgres, Redshift, and Athena. You will work with cross-functional teams, enforce standards, and mentor junior staff to ensure scalable data solutions.

Qualifications

• Bachelor’s degree in Business or Information Systems.
• 3 years data modeling experience across multiple RDBMS.
• 3 years experience modeling data lineage and translations between systems with different data schemas.
• Experience with AWS database technologies (Postgres, Redshift, 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.
• 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.

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.