Develop, maintain, and optimize stored procedures used in analytical processes and data integrations for BI environments.
Create high-performance SQL queries to support reports, metrics, and management dashboards.
Implement and maintain ETL processes and data load routines.
Collaborate with BI teams and business stakeholders to gather requirements, analyze scenarios, and define technical solutions.
Analyze, diagnose, and resolve issues related to query and database process performance.
Ensure the quality, integrity, and consistency of data provided in analytical environments.
Support maintenance, evolution, incident resolution, and continuous improvement of database processes.
Contribute to optimizing data structures and improving the organization’s analytical routines.

Solid experience with Microsoft SQL Server and SQL Server Management Studio (SSMS).
Advanced knowledge of T-SQL for development, maintenance, and optimization of complex queries.
Experience manipulating data with SELECT, INSERT, UPDATE, and DELETE statements.
Development and maintenance of stored procedures, functions (scalar and table-valued), and database objects for analytical processes and integrations.
Knowledge of data modeling for Business Intelligence (BI) and Data Warehouse environments, including Star Schema and Snowflake Schema.
Experience with ETL processes (Extract, Transform, Load), ensuring data quality, integrity, and reliability.
Experience with importing, exporting, and processing CSV, XLS, TXT files and other formats used in data integrations.
Knowledge of performance analysis and database tuning, including execution plans, index creation, partitioning, and query optimization.
Understanding of Business Intelligence architecture, metrics, reports, and analytical dashboards.
Experience with technical documentation, code standardization, and application of development best practices.
Ability to work alongside business areas and BI teams to gather requirements and provide strategic data.
Analytical, consultative, and proactive profile, with the ability to identify improvements and propose solutions aligned with business needs.
Strong interpersonal communication and ease interacting with users and multidisciplinary teams.

100% remote work, depending on the contract model
Support, evolution, incident resolution, and continuous improvement of database processes
Technical documentation, code standardization, and application of development best practices
Database performance analysis and tuning

PL/SQL Developer, PL

Key skills