The Data Engineer at PineBridge Investments will design and implement data pipelines, backfill processes, and testing strategies for the Snowflake data warehouse. The role includes providing documentation and training for users while improving data management processes.
PineBridge Investments is a private, global asset manager focused on active, high-conviction investing. We draw on the collective power of our experts in each discipline, market, and region of the world through an open culture of collaboration designed to identify the best ideas. Our mission is to exceed clients’ expectations on every level, every day. As of 31 December 2020, the firm managed US$126.3.7 billion across global asset classes for sophisticated investors around the world.
Responsibilities:
- Design and implement efficient data & CICD pipelines (ETLs) in order to integrate data from a variety of sources into Snowflake warehouse.
- Design and implement data model changes that align with warehouse standards.
- Design and implement backfill or other warehouse data management processes.
- Develop and execute testing strategies to ensure high quality warehouse data.
- Provide documentation, training, and consulting for data warehouse users.
- Have a strong data and BI mindset to handle multiple priorities.
- Provide input and feedback to support continuous improvement in processes.
Skills:
- Extensive experience (4+ years) in designing and implementing a fully operational solution on Snowflake Data Warehouse.
- Strong hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, SnowFlake data share, Streams, tasks, Snowflake stored procedures etc.
- Extensive experience (4 + years) in SQL is a must.
- Extensive experience (4 + years) in building frameworks using python.
- Strong experience in building data pipeline using AWS technology stack. S3, Lambda, Ec2, Steps functions, cloud formation.
- Strong experience with programming scripting and data science languages such as PowerShell, R, SQL, Javascript etc.
- Experience in building data models, including conceptual, logical, and physical for enterprise Relational, and dimensional Databases.
- Strong understanding of Data warehouse and BI concepts.
- Working knowledge of Big Data concepts in organizing both structured and unstructured data is a big plus.
- Bachelor’s degree or higher in a technology related field (e.g. Engineering, Computer Science, etc.) required, Master’s degree a plus
Must Have:
- AWS – S3, Lambda, Step Functions, Cloud formation, AWS Glue, AWS EC2 etc.
- Cloud Databases- Snowflake, AWS aurora, AWS RDS
- Data Integration/Programming languages - Python, Java, C#, SQL, Stored procedures
- ETL/ELT Tools – Fivetran / Matillion and/or Informatica
- Orchestration -- Apache Airflow, Autosys, Tidal
Good to Have:
- Additional AWS services
- Data management – Experience working with data governance, data operations
- BI – Power BI, Tableau, Python plotly, AWS Quicksight
- CICD
- Asset management industry experience
PineBridge Investments Mumbai, Maharashtra, IND Office
Unit No.1101, Tower "B" Peninsula Business Park, Ganpatrao Kadam Marg, Lower Parel, Mumbai, Maharashtra, India, 400 013
Similar Jobs
Healthtech • Logistics • Pharmaceutical
As an Azure Cloud Data Engineer, you will maintain data infrastructure, build pipelines, analyze data, and collaborate with teams, enhancing data quality and modeling.
Top Skills:
Azure AiAzure Analysis ServicesAzure Data FactoryAzure Logic AppsAzure SqlAzure Synapse AnalyticsData Blob StorageData Lake StorageETLMachine Learning ServicesMs Sql ServerPower BIPower Bi Premium
Financial Services
The role involves designing, analyzing, and delivering data for credit stress models, creating data pipelines, writing requirements, and collaborating with various stakeholders.
Top Skills:
JIRAExcelPythonSQL
Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
Lead a technical team to deliver technology solutions for clients, manage project phases, and ensure quality and design meet expectations, while mentoring and collaborating with various stakeholders.
Top Skills:
AthenaAWSAws NeptuneAzureEc2EmrGCPGlueGlue EtlLakeformationManaged AirflowPythonRdsRedshiftS3Sagemaker StudioScala
What you need to know about the Mumbai Tech Scene
From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.
