Database Developer

This is a fully remote position, open to applicants in Brazil.

📋 Description

• Analyze comprehensive technical specifications, documented requirements, and business rules to identify suitable data solutions.

• Create and maintain robust logical and physical data models that cater to enterprise analytics, reporting, and operational data requirements.

• Develop and oversee intricate database objects such as tables, views, stored procedures, and functions.

• Design, implement, and maintain efficient ETL pipelines to acquire, transform, and load data from various source systems.

• Ensure the accuracy and consistency of data across systems by validating transformations and outputs against established requirements.

• Offer technical expertise related to database development, data modeling, and ETL design.

• Facilitate the transition of database and ETL modifications through development, testing, and production environments.

⛳️ Requirements

• A minimum of 3 years of experience in a database development position (e.g., SQL Server, PostgreSQL, Oracle)

• Proficient in SQL development, including complex joins, window functions, subqueries, and query optimization.

• Strong background in designing logical and physical data models to support enterprise reporting and analytics.

• Extensive experience in designing and managing ETL pipelines and data transformation processes.

• Excellent analytical and problem-solving skills with the capability to interpret complex data relationships and business logic.

• Ability to analyze system behavior, pinpoint root causes of data issues, and implement effective technical solutions.

• Experience enhancing database and ETL performance through indexing strategies, query optimization, and efficient data structures.

• Capability to thoroughly document data models, ETL processes, technical logic, and system dependencies.

🏝️ Benefits

• Flexible work arrangements

• Professional development