Mid-level SQL Developer

Job not on LinkedIn

🕒 June 3

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Vetta

WebsiteLinkedInAll Job Openings

201 - 500 employees

Founded 2001

⚡ Energy

☁️ SaaS

🤖 Artificial Intelligence

Energy • SaaS • Artificial Intelligence

Vetta é um centro de excelência em digitalização industrial, especializado na oferta de soluções para otimização de energia e sustentabilidade. A empresa, parte do grupo alemão SMS group, utiliza tecnologias de software e expertise em processos para aprimorar a eficiência operacional das indústrias. Vetta oferece serviços que reduzem a pegada de carbono de seus clientes, melhoram a gestão de energia e promovem a automação e digitalização de operações industriais.

📋 Description

• 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 management dashboards. • Implement and maintain ETL processes and data load routines. • Collaborate with BI and business teams to understand requirements and make data available for decision-making, analyzing scenarios and proposing technical solutions. • Analyze and resolve issues related to query and database process performance. • Ensure the quality, integrity, and consistency of data provided in analytical environments. • Support activities related to evolution, maintenance, incident resolution, and continuous improvement of database routines tied to 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 developing, maintaining, and optimizing stored procedures, scalar 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 with data extraction, transformation, and loading processes, ensuring data integrity, performance, and reliability. • Data and File Handling: Experience importing, exporting, and processing files in CSV, XLS, TXT and other formats 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 knowledge of BI architecture, dashboards, and analytical processes. • Versioning and Best Practices: Experience with technical documentation, code standardization, and SQL development best practices.

🏖️ Benefits

• Meal and Food Card of R$32.00/day, to be used at various food and dining establishments according to your needs. • Home office allowance of R$100.00/month, plus flexible working hours. • If you work at Vetta’s office in Belo Horizonte, we provide commuter allowance. • Health plan and dental plan with the possibility to include dependents. • Total Pass and Vittude to support your overall health, including access to fitness activities and professionals from various health areas. • Online Discount Club – Swile Shop, offering discounts across multiple product and service networks. • Extended maternity and paternity leave so parents can experience this phase with peace of mind. • Profit sharing (PLR) – according to the union table. • Birthday day off. • No dress code. Dress in what makes you comfortable! • Continuous Training and Development Incentive Program to help you keep learning and sharing experiences. • Employee Referral Program.