Technical Data Assistant

Description

Job Summary: The Data Assistant will support the Business Intelligence team by assisting in data collection, organization, and validation to ensure information quality. Key Highlights: 1. Essential support for the Business Intelligence team 2. Focus on data quality and consistency 3. Opportunity to structure and model databases We are seeking a Data Assistant to support our Business Intelligence team. If you have an affinity for data and enjoy structuring databases, this is a great opportunity. The primary focus of this role will be to assist in data collection, organization, and validation, ensuring the quality of information used in our analyses. You will play a critical role in ensuring our team has access to consistent and well\-modeled data, feeding our reports and dashboards. **Responsibilities and Duties** Extracting and updating data for modeling teams and dashboards. Implementing queries in Excel reports to meet internal department requirements. Maintaining BI-related database tables to ensure organization and adherence to best practices. Ongoing validation between data sources and reports to identify discrepancies. Creating monitors to detect and alert on data inconsistencies. Optimizing queries and automating recurring processes for data extraction, updating, validation, and loading. Mapping and documenting queries while maintaining a history of scripts and queries. **Requirements and Qualifications** **Requirements and Qualifications:** Intermediate SQL \- advanced queries, CTEs, aggregations, subqueries, performance optimization. Experience with relational databases SQL Server and MySQL; Practical experience with ETL/ELT processes and data modeling; Intermediate Excel and Power BI skills, with emphasis on database integration, Power Query, and macros; Strong organizational skills and attention to detail. **Preferred Qualifications** **:** Ability to understand business rules and interpret commercial metrics. Investigative, analytical, and curious profile. Aptitude and interest in solving logical problems; Python for automation of data extraction and analysis; Knowledge of API integration; Knowledge of PHP for internal system integration; **Work Location:** Alto de Pinheiros (near Parque Vila Lobos); **Working Hours:** Monday to Friday, 8:30 AM to 6:00 PM (100% on-site); Contract Model: CLT **Additional Information** Benefits: **Health Insurance:** Bradesco (ward plan with co-payment), fully covered by the company for employee enrollment after 4 months. If the employee wishes to include dependents (children up to 18 years old), the monthly fee will be R$ 358.65, payable entirely by the employee. Important: spouses cannot be included; **Dental Insurance:** Bradesco (standard Doc I plan), fully covered by the company for employee enrollment. If the employee wishes to include dependents (children up to 18 years old), the monthly fee will be R$ 13.20 per dependent, payable entirely by the employee. Important: spouses cannot be included; **Transportation Benefit:** Provided based on route and need, with a 6% deduction from the employee’s salary. **Meal Allowance:** R$ 38.00/day (e.g., 22 working days totals R$ 836.00\); **Food Allowance:** R$ 200.00 **Bonus:** For purchasing sunglasses or prescription eyewear from our own brands (after 3 months); **Discount:** 30% off sunglasses and prescription eyewear from national brands (after 3 months); **Scholarship Program:** For technical courses, undergraduate or postgraduate studies (after 2 years, subject to internal policy terms and conditions); **Birthday Day Off:** One day off on the employee’s birthday (after 1 year); **Zen Klub**: Nutritional guidance platform; We have been operating in the optical sector for **over 20 years**, and are recognized as **one of Brazil’s largest eyewear manufacturers**. We are a Brazilian company with 100% domestic capital, dedicated to designing, producing, and distributing eyewear that represents design, technology, and quality in Brazil and worldwide. We have **more than 400 employees**, distributed across our Central Office located in the Alto de Pinheiros neighborhood of São Paulo/SP, and our Manufacturing Plant in Palmas/TO. We represent inspiring brands including Ana Hickmann, Evoke, Bulget, Atitude, Speedo, Hickmann, Ferrati, Jean Marcel, Anima, Jolie, and Mykita. We believe that seeing the world differently is what drives us. Working at GO Eyewear means being part of a team passionate about people, trends, and results.