Job Description
As a Senior Database Engineer, you will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. The Database Engineer will support our software developers, database architects, application reporting team and will ensure optimal data delivery architecture is consistent throughout ongoing projects. They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products.
Job Title: Senior Database Engineer
Job Location: Hyderabad
Start Date: As soon as possible
Key Responsibilities
Create and maintain optimal data pipeline architecture.
Assemble large, complex data sets that meet functional / non-functional business requirements.
Build the pipelines required 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 infrastructure needs.
Keep our data separated and secure across national boundaries through multiple data centers and regions.
Work with data and analytics experts to strive for greater functionality in our data systems.
Manage exploratory data analysis to support database and dashboard development
Key Requirements
Experience: 8-12 years would be preferable.
Required Skills
Expert knowledge in Database like PostgreSQL (preferably cloud hosted in any one or more cloud offerings like AWS, Azure, GCP), Snowflake Data Warehouse with strong programming experience in SQL, DBT
Competence in data preparation and/or ETL tools to build and maintain data pipelines and flows
Deep knowledge of databases, stored procedures, optimizations of huge data
In-depth knowledge of ingestion techniques, data cleaning, de-dupe, Master data management.
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
Exposure to Source control like GIT, Azure DevOps
Understanding of Agile methodologies (Scrum, Kanban)
Experience with automated testing and coverage tools
Experience with CI/CD automation tools (desirable)
Programming language experience in Golang (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
