Data Engineer – Bangalore, India

About BNI®:

Established in 1985, BNI is the world’s largest business referral network. With over 325,000 small-to medium-size business Members in over 11,000 Chapters across 77 Countries, we are a global company with local footprints. Our proven approach provides Members with a structured, positive, and professional referral program that enables them to sharpen their business skills, develop meaningful, long-term relationships, and experience business growth.

Visit to learn how BNI has impacted the lives of our Members and how it can help you achieve your business goals.

Position Summary

The Database Developer will be a part of BNI’s Global Information Technology Team and will primarily have responsibilities over the creation, development, maintenance, and enhancements for our databases, queries, routines and processes.  The Database Developer will work closely with the Database Administrator, data team, software developers, QA engineers and DevOps Engineers located within the BNI office in Bangalore, as well as all levels of BNI Management and Leadership teams.   This is an unparalleled opportunity to become part of a growing team and a growing global organization.  High performers will have significant growth opportunities available to them.
The candidate should be able to be an expert in both database and query design and should be able to write queries on the fly on demand, he/she should posses good hands on experience on data engineering and should be well versed with tools mentioned in the technical table below

The person should be able to own the assignments and should be independent in terms of the development of queries and other aspects in data engineering.
Roles and Responsibilities

• Design stable, reliable and effective databases
• Create, optimize and maintain queries, used in our software applications, as well as data extracts and ETL processes
• Modify and maintain databases, routines, queries in order to ensure accuracy, maintainability, scalability, and high performance of all our data systems
• Solve database usage issues and malfunctions
• Liaise with developers to improve applications and establish best practices
• Provide data management support for our users/clients
• Research, analyze and recommend upgrades to our data systems
• Prepare documentation and specifications for all deployed queries/routines/processes
• Profile, optimize and tweak queries and routines for optimal performance
• Support the Development and Quality Assurance teams with their needs for database development and access
• Be a team player and strong problem-solver to work with a diverse team

Qualifications

Required:

• Bachelor’s Degree or equivalent work experience
• Fluent in English, with excellent oral and written communication skills
• 5+ years of experience with Linux-based MySQL/MariaDB database development and maintenance
• 2+ years of experience with Database Design/Development/Scripting
• Proficient in writing and optimizing SQL Statements
• Strong proficiency in MySQL/MariaDB scripting, including functions, routines and complex data queries.
• Understanding of MySQL/MariaDB’s underlying storage engines, such as InnoDB and MyISAM
• Knowledge of standards and best practices in MySQL/MariaDB
• Knowledge of MySQL/MariaDB features, such as its event scheduler
• (Desired) Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, Redis
• Experience with Amazon Web Services’ RDS offering
• Experience with Data Lakes and Big Data is a must
• Experience in Python is a must
• Experience with tools like Airflow/DBT/Data pipelines
• Experience with Apache Superset
• Knowledgeable with AWS services from Data Engineering point of view
• (Desired) Proficient Understanding of git/GitHub as a source control system
• Familiarity with working on an Agile/Iterative development framework
• Self-starter with positive attitude with the ability to collaborate with product managers and developers
• Strong SQL Experience and ability to write queries on demand.

Primary Technologies:

• Database Stored Procedure
• SQL Optimization
• Database Management
• Airflow/DBT/
• Data Warehousing with RedShift/Snowflake (Mandatory).
• Python/Linux/
• Data Pipelines

Physical Demands and Working Conditions

Sedentary work. Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects. Repetitive motion. Substantial movements (motions) of the wrists, hands, and/or fingers. The worker is required to have close visual acuity to perform an activity such as: preparing and analyzing data and figures; transcribing; viewing a computer terminal; extensive reading.

External Posting Language

This is a full-time position. This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Learn more at BNI.com

An equal opportunity employer.