Home
Jobs
Saved
Resumes
PL/SQL Developer, PL at Spread Tecnologia | JobVerse
JobVerse
Home
Jobs
Recruiters
Companies
Pricing
Blog
Jobs
/
PL/SQL Developer, PL
Spread Tecnologia
Remote
Website
LinkedIn
PL/SQL Developer, PL
Brazil
Full Time
4 hours ago
No Sponsorship
Apply Now
Key skills
ETL
MS SQL Server
SQL
BI
Business Intelligence
Snowflake
SQL Server
Communication
Remote Work
About this role
Role Overview
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.
Requirements
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.
Tech Stack
ETL
MS SQL Server
SQL
Benefits
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
Apply Now
Home
Jobs
Saved
Resumes