Description
Join a company that loves transforming through technology and embraces diversity in all its forms!
**Responsibilities and Assignments**
Required Technical Experience
SQL Server: Solid 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 for 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 and File Handling: Experience with importing, exporting, and processing CSV, XLS, TXT, and other file formats commonly used in data integrations.
Performance and Tuning: Knowledge of database performance optimization, including execution plan analysis, index creation, partitioning, and query tuning.
Business Intelligence (BI): Conceptual understanding of BI architecture and operation, dashboards, and analytical processes.
Version Control and Best Practices: Experience with technical documentation, SQL code standardization, and SQL development best practices.
Business and BI Interface: Collaborate with end users and BI teams to gather requirements, understand analytical needs, and deliver data to support decision-making.
Communication and Solution Proposals: Strong interpersonal communication skills, ease of interaction with users, and ability to analyze scenarios and propose technically sound solutions aligned with business needs.
Consultative and Analytical Profile: Proactively identify improvements in processes, data structures, and BI routines, ensuring data quality and efficiency.
Scope of Activities
Develop, maintain, and optimize stored procedures used in analytical processes and data integrations for BI systems.
Create high-performance SQL queries to support reports, KPIs, and managerial dashboards.
Implement and maintain ETL processes and data loading routines.
Collaborate with BI and business teams to understand requirements and deliver data for decision-making, analyzing scenarios and proposing technical solutions.
Perform analysis and resolution of database query and process performance issues.
Ensure data quality, integrity, and consistency across analytical environments.
Support evolution, maintenance, issue resolution, and continuous improvement of BI-related database routines.
**Requirements and Qualifications** **Mandatory:**
HIGHER EDUCATION \- COMPLETED
**Additional Information** **Desirable:**
Want to learn more about us and join the team building the future?
**\#VemSerSpreader**
**Transforming the world with technology**
We are nearly 2,500 Spreaders, distributed across 22 Brazilian states via Spread Anywhere, enabling us to work **100% remotely**, depending on the employment model. We are digital, hyperconnected, and practice one of our core cultural values—\#collaboration—every day, no matter where we are.
**Innovation to shape the future**
Spread is an innovation company with 41 years of history, delivering comprehensive solutions in technology and digital business. Today, we offer a robust portfolio of services, including application development, Quality Assurance, IT Outsourcing, Talent on Demand, Artificial Intelligence solutions, and SAP and S/4HANA consulting and implementation. We adopt a customer-centric approach, prioritizing customer experience to guide our actions and strategies. This commitment is reflected in our NPS score of 75—placing us in the quality zone and demonstrating our clients’ trust and satisfaction.
**Diversity, Equity & Inclusion**
Here, diversity and inclusion are not just words—they are genuine commitments. We strive to ensure every Spreader feels **valued, respected, and empowered** to reach their full potential. We recognize that true diversity goes beyond superficial traits and encompasses a broad range of characteristics, including gender, ethnicity, sexual orientation, age, and abilities.