Desenvolvedor SQL Sênior

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

📋 Description

• Develop, maintain, and optimize stored procedures used in analytical processes and data integration for BI systems.

• Create high-performance SQL queries to support reports, metrics, and management dashboards.

• Participate in the implementation and maintenance of ETL processes and data loading routines.

• Collaborate with BI teams and business stakeholders to understand requirements and provide data for decision-making, analyzing scenarios and proposing technical solutions.

• Conduct analysis and troubleshoot issues related to query performance and database processes.

• Ensure the quality, integrity, and consistency of information available in analytical environments.

• Support activities related to the evolution, maintenance, problem resolution, and continuous improvement of database routines associated with the BI environment.

⛳️ Requirements

• SQL Server: Strong experience in administration and development on the Microsoft SQL Server platform and use of SQL Server Management Studio (SSMS).

• Advanced T-SQL: Proficiency in developing and optimizing complex queries, including data manipulation with SELECT, INSERT, UPDATE, and DELETE.

• Stored Procedures and Functions: Experience in developing, maintaining, and optimizing stored procedures, scalar functions, and table-valued functions aimed at analytical processes and data integration.

• Data Modeling: Knowledge of dimensional modeling for BI and Data Warehouse environments, including Star Schema and Snowflake Schema.

• ETL (Extract, Transform, Load): Experience in data extraction, transformation, and loading processes, ensuring data integrity, performance, and reliability.

• Data Manipulation and Files: Experience with importing, exporting, and processing CSV, XLS, TXT files, and other formats used in data integrations.

• Performance and Tuning: Knowledge in database performance optimization, including execution plan analysis, index creation, partitioning, and query tuning.

• Business Intelligence (BI): Conceptual understanding of the architecture and operation of BI solutions, dashboards, and analytical processes.

• Version Control and Best Practices: Experience with technical documentation, code standardization, and best practices in SQL development.

🏝️ Benefits

• Meal and Food Voucher of R$32.00/day

• Home office allowance of R$100.00/month

• Transportation voucher (if working at Vetta's office in Belo Horizonte)

• Health and dental insurance, including dependents

• Total Pass and Vittude for physical activities and health

• Online Discounts Club – Swile Shop

• Extended maternity and paternity leave

• Profit-sharing according to union table

• Birthday Day-Off

• No Dress Code

• Continuous Education and Training Incentive Program

• Talent Referral Program