Senior Data Engineer, Data & AI Engineering

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

Job summary

Pretium Enterprise Services, India is seeking an experienced data engineer to develop data products and BI solutions for the organization.

The role requires 3-7 years in data engineering, hands-on Snowflake/ETL work, SQL, Python and cloud technologies, with experience in data migration to Snowflake.

Preference is for candidates residing in Bengaluru; the standard shift is 12 noon to 9 pm with flexibility based on business needs.

Qualifications

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

Responsibilities

• Develop data products and BI solutions as an individual contributor.
• Collaborate with Agile teams to design, test, and implement data solutions.
• Work with Snowflake, Redshift, and cloud data warehouses.
• Write complex SQL stored procedures and perform performance tuning.
• Migrate data from RDBMS and S3 to Snowflake.
• Design, install, configure, and support data solutions with security and privacy.
• Leverage Python, PySpark, SQL Server, PostgreSQL, MongoDB, and AWS services.
• Familiarity with UNIX/Linux environments and BI tools.

Skills

SQL

Snowflake

ETL

BI development

Python

Pyspark

UNIX/Linux

Cloud data warehousing

Data modelling

Performance tuning

Education

Bachelor’s Degree in Engineering

Tools

dbt SQL

Informatica

Fivetran

PowerBI

Looker

Hyperion

Snowflake SQL

Job description

ROLE AND RESPONSIBILITIES:

• Would be an individual contributor responsible for developing data products & solutions for the organization.
• 3+ years of overall in IT with experience in Data warehouse, ETL, BI projects is desired.
• Would collaborate within Agile teams to design, develop, test, 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 a BI Tools (PowerBI, Looker, Hyperion) would be preferred.

QUALIFICATIONS AND TECHNICAL SKILLSETS:

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

NOTES:

• Prefer candidates already residing in Bangalore
• Standard Shift Timing is 12noon to 9pm, however this may vary depending on the business requirements