Lead I - Data Engineerings
- Mumbai, Maharashtra Bangalore, Karnataka
- Permanent
- Full-time
As a Data Engineer, you will be a member of the Data Governance and Technology Development team within the Non-Financial Risk Technology team. You will focus on developing robust data solutions by building workflows, pipelines, views, and stored procedures, while also performing data analysis, query optimization, and data load monitoring. This role requires close collaboration with data providers, scientists, developers, and analytics teams to implement client-specific business requirements.Key ResponsibilitiesDesign, implement, and maintain RDBMS databases with strong performance, scalability, and data integrity.Develop automation scripts in Python/Shell for data extraction, transformation, loading (ETL), monitoring, and maintenance.Monitor and optimize database performance; troubleshoot bottlenecks and apply tuning techniques.Write and optimize complex SQL queries for analysis, reporting, and downstream consumption.Implement/enforce data security and access controls in line with compliance and industry standards.Conduct database capacity planning and implement scaling strategies.Collaborate with development and operations teams to troubleshoot database-related issues.Stay updated on advancements in RDBMS, Postgres DB, Python/Shell scripting, and modern data engineering tools.Additional Comments:Job Description – Data Engineer As a Data Engineer, you will be a member of the Data Governance and Technology development team within the Non-Financial Risk Technology team, with specific focus in developing data solutions. In this role you will be primarily responsible for the development of data workflows, pipelines, views, and stored procedures, in addition to performing data analysis, and monitoring and tuning queries and data loads. You will be working closely with data providers, data scientists, data developers, and data analytics teams to facilitate the implementation of client-specific business requirements and requests. Your Key Responsibilities Design, implement, and maintain RDBMS databases, ensuring optimal performance, scalability, and data integrity. Utilize Python/Shell scripting to automate database tasks, such as data extraction, transformation, loading, monitoring, and maintenance. Monitor and optimize database performance, identifying and resolving bottlenecks, and implementing performance tuning techniques. Write complex SQL queries to analyse data and create views for reporting purposes for downstream consumers. Implement and enforce data security and access controls, ensuring compliance with industry standards and regulations. Conduct database capacity planning, forecasting future requirements, and implementing necessary scaling strategies. Troubleshoot and resolve complex database-related issues, collaborating closely with development and operations teams. Stay up to date with the latest advancements in RDBMS systems, Postgres DB, scripting languages (Python/Shell), as well as other data engineering tools and evaluate their potential application within our organization. Skills / Qualifications Required: Bachelor’s degree in Computer Science, Software Engineering, Information Technology, or related field required. At least 5-7 years of experience in data development and solutions in highly complex data environments with large data volumes At least 5+ years of SQL experience with the ability to write ad-hoc and complex SQL queries. At least 5+ years of Python experience with ability to write good python code. Strong analytical skills, including a thorough understanding of how to interpret customer business requirements and translate them into technical designs and solutions. Strong communication skills both verbal and written. Capable of collaborating effectively across a variety of IT and Business groups, across regions, roles and able to interact effectively with all levels. Self-starter. Proven ability to manage multiple, concurrent projects with minimal supervision. Can manage a complex ever changing priority list and resolve conflicts to competing priorities. Strong problem-solving skills. Ability to identify where focus is needed and bring clarity to business objectives, requirements, and priorities. Good to have: Experience on any ETL tool is added advantage. Knowledge and Experience on Graph DB (Star dog DB) is an added advantage, including ontology modelling, data integration, semantic graph querying, and reasoning capabilities. Knowledge of using GIT and Jenkins/CI_CD pipeline for automated code deployment. Experience with Agile development methodologies. Experience with Reporting tool like Tableau is a plus.Skills:SQL,Python,RDBMS/PostgresAbout Company:UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact—touching billions of lives in the process.