ETL Developer

Description

Job Summary: Safe Consig is seeking an ETL Developer to join its technology team, responsible for developing routines, creating transformations, executing SQL scripts, and collaborating with data teams. Key Highlights: 1. Develop ETL routines using Pentaho, Python, and SQL (MySQL) 2. Collaborate with data analysts and business teams 3. Document implemented processes clearly and reusably **Safe Consig** is seeking **an ETL Developer** to join our technology team. **Responsibilities** * Develop basic ETL routines using tools such as Pentaho, Python, and SQL (MySQL). * Create simple transformations and perform data loading across different environments. * Execute SQL scripts for data querying and transformation under guidance. * Support identification of failures or inconsistencies during the data integration process. * Collaborate with data analysts and business teams to understand integration requirements. * Document implemented processes clearly and reusably. * Perform functional and data validation tests after transformations. **Requirements** * Bachelor's degree in Computer Science, Information Systems, or related fields (completed or in progress). * Intermediate SQL (queries, joins, simple transformations). * Basic knowledge of ETL tools (e.g., Pentaho Data Integration, Apache Hop). * Experience with file formatting and manipulation (CSV, TXT, XLSX). * Knowledge of Python for data manipulation (e.g., Pandas). **Preferred Qualifications** * Experience with academic or practical data migration or integration projects. * Knowledge or experience with Payroll Software. * Knowledge of API integrations or task automation. **Benefits** * Caju meal/food allowance (**R$1\.000**) * Mobility allowance * Nationwide Bradesco Health Plan (no co-payment or payroll deduction) * Dental Plan (no payroll deduction) * Birthday Day Off **Job Details** * Employment type: Permanent (CLT) * Work mode: Hybrid \- Florianópolis/SC Job Type: Permanent CLT Benefits: * Medical assistance * Dental assistance * Fuel allowance * Corporate agreements and commercial discounts * Food allowance * Meal allowance Relocation/moving possibility: * Florianópolis, SC: Relocate or move to the job location before starting work (Mandatory) Selection Question(s): * What is your expected salary? * Are you available to work in a hybrid model? (2 days remote and 3 days onsite at Estreito \- Florianópolis/SC)? Education: * Technical education currently enrolled or interrupted (Mandatory) Experience: * Python for data manipulation (e.g., Pandas) (Mandatory) * Data file transformation (CSV, TXT, or Excel) (Mandatory) * Intermediate SQL, query creation, and JOIN usage (Mandatory) * ETL (e.g., Pentaho Data Integration, Apache Hop ...) (Mandatory) Work Location: Remote-hybrid for Florianópolis, SC