Data Analyst (Hybrid - SP)

Description

Job Summary: Koode Tecnologia is seeking an experienced Data Analyst to manage SQL Server databases, optimize performance, and process integrated data within a continuously innovative environment. Key Highlights: 1. SQL Server Database Administration and Optimization 2. Process Orchestration and Integrated Data Processing 3. Opportunity in a world of constant transformation and innovation An opportunity has arisen at **Koode Tecnologia** for a **Data Analyst (Hybrid \-SP)**. As a Koode professional, in a world undergoing constant transformation and innovation, we understand the importance of delivering the best action strategies so our clients achieve optimal results. To this end, we seek a professional with experience in the field and the ability to understand requirements, define solutions, and execute them. If you enjoy challenges and identify with us, apply now! **Responsibilities and Duties** **Responsibilities:** * SQL Server Database Administration; * Query refactoring aimed at overall performance improvement (Tuning); * Development of Queries (T\-SQL); * Continuous improvement of database processes such as Triggers, Jobs, and Functions; * Process Orchestration and Integrated Data Processing. **Requirements and Qualifications** **The main requirements, knowledge, and skills expected from the professional are:** * Interpersonal Skills; * Analytical mindset and ability to interpret results; * Completed Bachelor's degree; * Microsoft Office Suite; * Knowledge of Always\-On; * Ability to implement indexes; * Knowledge of data purging and shrink operations; * Knowledge of SQL backup plans; * Knowledge of data restoration; * Best practices for writing T\-SQL code; * Best practices for database disaster recovery and failover; * Knowledge of database load balancing and replication; * Knowledge of on-premises and cloud servers. **Preferred Qualifications:** * Experience in retail and financial markets * SQL programming language; * Knowledge of Big Data; * Knowledge of DataFactory; * Knowledge of Python for automation and ETL; * Knowledge of consolidated data processes (BI, Datamart, Datawarehouse, etc); * Microsoft certification. **Behavioral Competencies:** * Autonomy: capable of performing tasks without constant supervision; * Collaboration: works well in teams and supports team development; * Adaptability: able to learn new technologies and adapt to changes in projects or work environments. **Additional Information*** Employment type: PJ (individual entrepreneur); * Work model: Hybrid (1 day per week onsite); * Free Choice Program (can be used for health, education, technology, etc). **YOU DEMAND WE CODE** We love "coding"—hence our name, Koode! We believe innovation through technology is a lifestyle, and that’s how we move forward.