Senior Data Engineer

Role: Senior Senior Data Engineer

Experience Level: 4+ Years

Work location: Mumbai/Bangalore/Trivandrum

Role & responsibilities

• Strong proficiency in SQL, Python, DBT, AWS services, data modelling, Snowflake, building and maintaining data pipelines, and robust troubleshooting capabilities.
• In addition, exposure to asset management, alternative investments, or broader financial domain knowledge is highly valuable.
• Experience in establishing a golden source of
• truth using Snowflake as the data warehousing tool, with current data sources coming from external sources via SFTP and SEI via a Snowflake share; the data engineer's role involves pushing data to the golden layer using Snowflake tools like streams and stored procedures, requiring strong SQL stored procedure and Python skills, as well as a good understanding of data modeling concepts like star schema
• AWS resources on the Data side needed and not on the infra side & same for Snowflake.
• Exposure to orchestration tool on Data engineering side, so that they can setup date pipeline etc
• Seeking a hands-on engineer with five to six years of experience and knowledge of basic AWS services like Redshift and S3.
• Data Ingestion, Frequency, and Orchestration The team is currently unsure of the exact frequency of files from JPMC but expects them to be on a daily or monthly basis, with transaction files potentially having a daily frequency
• Orchestrating third-party feeds, they plan to use Snowflake workflows and jobs.
• Tools: Snowflake Share, snowflake architecture (micro partition) , snowflake best practices, Snowflake SQLs, snowflake procedures, UDF, Task
• Other Tools: Python is definitely a required skill, and basic knowledge of Unix and Linux is good to have for using tools like Git. Data streams are used for change tracking purposes within Snowflake.