Job Description

:
Job Role: ?
As a Senior Database Engineer, you will be responsible for expanding and optimizing our data architecture and data pipelines. ? The ideal candidate is an experienced data engineer and data wrangler who enjoys optimizing data systems and building them from the ground up. ? The Database Engineer must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. ? The right candidate will be excited by the prospect of data process automation and optimizing or even re-designing our company's data architecture to support our next generation of products and data initiatives. ?
Job Title: Senior Database Engineer ?
Job Location: Hyderabad/ Gurgaon / Noida ?
Start Date: As soon as possible
Key Responsibilities:
Build the data pipeline for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and cloud database technologies. ?
Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data needs. ?
Work with data and analytics experts to strive for greater functionality in our data systems. ?
Assemble large, complex data sets that meet functional/ non-functional business requirements. ?
Ability to quickly analyze existing SQL code and make improvements to enhance performance, take advantage of new SQL features, close security gaps, and increase robustness and maintainability of the code. ?
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery for greater scalability, etc. ?
Unit Test databases and perform bug fixes. ?
Develop best practices for database design and development activities. ?
Take on technical leadership responsibilities of database projects across various scrum teams. ?
Manage exploratory data analysis to support dashboard development (desirable). ?
Key Requirements:
Experience: 8-12 years would be preferable. ?
Required Skills:
Strong experience in SQL with expertise in relational database (PostgreSQL preferrable cloud hosted in AWS/Azure/GCP). ?
Strong experience in cloud based Data Warehouse like Snowflake (preferrable) or any similar ones like Azure Synapse. ?
Competence in data preparation and/or ETL/ELT tools like IBM StreamSets, Snap Logic, DBT, etc. ? (preferably strong working experience in one or more) to build and maintain complex data pipelines and flows to handle large volume of data. ?
Understanding of data modelling techniques and working knowledge with OLAP systems. ?

- Deep knowledge of databases, data marts, data warehouse enterprise systems and handling of large data sets.
- In-depth knowledge of ingestion techniques, data cleaning, de-dupe, etc.
- Ability to fine tune report generating queries.
- Understanding of index design and performance-tuning techniques
- Familiarity with SQL security techniques such as data encryption at the column level, Transparent Data Encryption (TDE), signed stored procedures, and assignment of user permissions
- Experience in understanding the source data from various platforms and mapping them into Entity Relationship Models (ER) for data integration and reporting (desirable).
- Adhere to standards for all database e.g., Data Models, Data Architecture and Naming Conventions
- Exposure to Source control like GIT, Azure DevOps
- Understanding of Agile methodologies (Scrum, Kanban)
- Experience with NoSQL database to migrate data into other type of databases with real time replication (desirable).
- Experience with CI/CD automation tools (desirable)
- Programming language experience in Golang, Python, any programming language, Visualization tools (Power BI/Tableau) (desirable).
Personal Attributes:
- Very good communication skills.
- Ability to easily fit into a distributed development team.
- Ability to manage timelines of multiple initiatives.
- Ability to articulate insights from the data and help business teams make decisions
- Able to work with ambiguous requirements, to seek clarity around uncertainty and to manage risks
- Ability to communicate complex concepts to non-data audiences

Skills Required