Senior Data Engineer

Pretium Enterprise Services, India; Bengaluru; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Pretium Enterprise Operations India Private Limited (PES India), based in Bangalore, is integral to the growth of Pretium’s global operations. This role is an individual contributor developing data products and BI solutions with 3–7 years in IT, focusing on Snowflake, ETL and cloud data warehousing.

You will collaborate in Agile teams to design, test, and implement data, BI and analytics solutions, leveraging SQL, Python, Pyspark and cloud technologies. Knowledge of ML/AI is a plus.

Qualifications

• 3+ years of IT experience with Data warehouse, ETL and BI projects.
• Collaborate in Agile teams to design, develop, test and implement BI solutions.
• Experience with Cloud Data Warehouses (Snowflake, Redshift) and SQL stored procedures.
• Expertise in Snowflake modelling, ELT with dbt, and data migration to Snowflake.

Responsibilities

• Develop data products & solutions for the organization as an individual contributor.
• Design, implement and optimize data pipelines and BI data models.
• Maintain data security and privacy while building data solutions.
• Work with Python, SQL, and cloud technologies to enable analytics.
• Collaborate with teams across data, analytics and cloud platforms.

Skills

Data Engineering

SQL

Python

Pyspark

Cloud AWS

Snowflake

ETL

BI Tools

Looker

PowerBI

Tools

Snowflake

Redshift

Informatica

Fivetran

dbt

AWS

Unix/Linux

SQL Server

PostgreSQL

MongoDB

Job description

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.

• 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:

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

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