Database Developer

Our client, a well-established multinational D2C e-commerce company operating in the USA is seeking a skilled and motivated Database Developer to join our team and take charge of integrating our dynamic e-commerce inventory data from Google Sheets into a cloud SQL database. In this role, you will work closely with the business directly, collaborating on data requirements and designing an efficient solution to automate the data upload process. You will be responsible for building and maintaining the database structure, ensuring data integrity, and optimizing performance.
Join a dynamic team in the fast-paced e-commerce industry and play a vital role in transforming our manual inventory process into an automated and efficient data integration system!‍

Responsibilities:

1. Collaborate with the business to understand data requirements and translate them into an effective database design.
2. Develop and implement a solution to extract data from Google Sheets and upload it into the cloud SQL database.
3. Design and maintain a robust database schema that organizes the inventory data for efficient querying and analysis.
4. Utilize Google Scripts to automate the extraction, transformation, and loading (ETL) process, reducing manual effort and increasing efficiency.
5. Perform data cleansing and transformation tasks to ensure data accuracy and consistency during the upload process.
6. Implement appropriate data quality checks and error handling mechanisms to detect and resolve any issues during the data upload process.
7. Optimize database performance by creating indexes, partitioning strategies, and query optimizations.
8. Collaborate with the business to ensure data security and integrity, implementing access controls and backup strategies.
9. Monitor and troubleshoot data integration issues, resolving them in a timely manner.‍

Requirements:

1. Proven experience as a Database Developer, Data Engineer, or similar role, with a focus on data integration and database management.
2. Proficiency in SQL and experience working with cloud-based databases
3. Strong knowledge of Google Sheets integration and Google Scripts for automation.
4. Experience with Amazon Seller Central reports and Amazon Selling Partner API (SP-API) will be a plus
5. Solid understanding of database design principles, including normalization, indexing, and partitioning.
6. Strong analytical and problem-solving skills, with the ability to identify and resolve data-related issues.
7. Experience with ETL processes and tools, such as Python, scripting languages, or database-specific utilities for automating data integration tasks.
8. Familiarity with data governance and security best practices, including access controls, data encryption, and backup strategies.
9. Excellent communication and interpersonal skills, with the ability to collaborate effectively with business stakeholders.
10. Detail-oriented mindset with a focus on data accuracy and quality.

Preferred Qualifications:

1. Experience working directly with business users, understanding their needs and translating them into technical solutions.
2. Familiarity with DigitalOcean Managed Databases 
3. Knowledge of scripting languages (e.g., Python) for data analysis and manipulation.
4. Understanding of data warehousing concepts and techniques.
5. Familiarity with version control systems (e.g., Git) for code management.