Serve as the primary data reference for the squad, ensuring the quality, organization and availability of the inputs required for decision-making and the development of data-driven solutions.
Act as the focal point and technical data reference for the squad.
Design, structure and maintain database tables, views and objects following best practices in modeling and governance.
Perform data cleansing, transformation, enrichment and processing.
Develop and optimize SQL queries with a focus on performance, scalability and maintainability.
Extract metrics, counts and datasets to support the squad's demands and partner areas.
Build and maintain data integration and load processes (ETL/ELT).
Ensure the quality, consistency and integrity of data provided for consumption.
Work with high-volume data environments, processing datasets containing billions of records.
Identify opportunities for continuous improvement in processes, structures and data flows.
Support the definition and dissemination of best practices for data development and handling.
Requirements
Solid experience with SQL Server.
Experience developing and maintaining processes using SSIS.
Advanced knowledge of data modeling and data structuring.
Experience in query optimization and performance tuning.
Experience handling and processing large volumes of data (billions of rows).
Knowledge of Python for automation, transformation and data analysis.
Experience with SAS Guide.
Desired: knowledge of data architecture and data pipelines.
Experience with agile methodologies.
Knowledge of data governance and data quality practices.
Experience in high-criticality, large-scale corporate environments.
Tech Stack
ETL
Python
SQL
SSIS
Benefits
Educational assistance (English, Spanish, undergraduate and postgraduate courses)
Exclusive AI platform + in-house AI training academy (Marketdata Academy) with monthly trainings available to employees
Partnerships with various educational institutions
Profit sharing (PLR) and Happy Day (day off on your birthday)
Medical and dental coverage
Home office allowance*
Internal counseling program offering psychological, financial and legal guidance
TotalPass and workplace exercise classes
Meal and/or food allowance (including during vacation month)
Transportation voucher (optional)
Life insurance and time bank (Banco de Horas)
Extended maternity/paternity leave and childcare assistance