Senior Data Engineer

Pretium Enterprise Services, India · India

Company Overview

Pretium is a specialized investment manager with ~$62B in assets under management (AUM) focused on real estate, mortgage finance, and corporate debt. Pretium manages more than 1,75,000 single-family rentals (SFRs) and multi-family rentals in the United States and has a global employee base of ~7,000.

Pretium Enterprise Operations India Private Limited (PES India), based in Bangalore, is integral to the growth, innovation, and transformation of Pretium’s global operating companies. With 700+ employees, PES India delivers with excellence, ownership, and a relentless focus on scalable growth.

Roles & Responsibilities:

• Would be an individual contributor responsible for developing data products & solutions for the organization.
• 3+ years of overall experience in IT with experience in Data warehouse, ETL, BI projects is desired.
• Would collaborate within Agile teams to design, develop, test, and implement Data, BI & Analytics solutions.
• Must have experience with development & implementation of Cloud Data Warehouse like Snowflake, Redshift etc.
• Must have experience writing complex SQL stored procedures and conducting performance tuning/optimization.
• Expertise in Snowflake Data Modelling, ELT using dbt SQL / Snowflake SQL, Informatica, Fivetran.
• Experience in Data Migration from RDBMS, S3 to Snowflake cloud data warehouse is needed.
• Designing, building, installing, configuring, and supporting data solutions maintaining security and data privacy.
• Experience in cloud technologies like AWS would be preferred.
• Knowledge in Python, Pyspark, SQL Server, PostgreSQL, MongoDB, and AWS S3 would be preferred.
• Experience working in UNIX/Linux environment.
• Experience with ML/AI technologies would be preferred.
• Experience with BI Tools (PowerBI, Looker, Hyperion) would be preferred.

What we are looking for:

• Bachelor’s degree in engineering
• 3-7 years of experience in Data Engineering and Data & BI solution development
• Snowflake Certified Professional would be preferred.

Perks & Benefits:

We believe great people deserve to be taken care of – here’s what working at PES India looks like beyond the job:

• Competitive Compensation
• Shift & Weekend Allowances
• Insurance Coverage
• Hybrid Flexibility
• Career Growth