Senior Data Engineer

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