RESPONSIBILITIES:

• Be both a project lead and a technical executor, who makes decisions to develop and manage new structures and data integrations.
• Participate in the maintenance and development of the data warehouse design.
• Drive projects to create and optimize ETL processes using Microsoft Stack and Azure Cloud technologies.
• Investigate and implement the mapping between different data sources.
• Maintain, build, and improve SQL queries and stored procedures in the data warehouse to prepare and analyze data.
• Develop control structures to ensure data quality and integrity.
• Create technical documentation for BI tools.
• Contribute to improve the data delivery to data models and reports.
• Support the team with day-to-day tasks and troubleshooting processes.

The day-to-day work will be a balance between meet-ups with different teams to set business requirements and translate them into technical ones; having focus time to integrate those requirements and maintain the data source, our data warehouse, and reporting structures; and dedicating time to discuss, learn and share knowledge with colleagues about other projects, experiences, and optimization ideas. During the focus time, your most common tasks will include:

• Develop and optimize data pipelines (ETL tools).
• Develop, maintain and design data architecture.
• Perform SQL queries.
• Map different data sources.
• Write technical documentation.
• Analyze system performance.
• Troubleshoot any issues that may arise