UltraCon Consultoria

Data Engineer

• Develop and maintain data ingestion, transformation and loading pipelines (ETL/ELT) from multiple sources (APIs, relational databases, files, legacy systems and cloud)
• Work on data modeling (Data Lake, Data Warehouse and Data Marts), ensuring performance, scalability and governance
• Process large volumes of data using Spark (PySpark or Scala) and Big Data frameworks
• Develop scripts and automations in Python for data extraction, integration and processing
• Create and optimize advanced SQL queries (procedures, views, functions, jobs), with a focus on performance
• Work in cloud environments (GCP, Oracle Cloud, Azure or similar), participating in data migration and modernization projects
• Integrate data across different platforms and systems (e.g., CRM, marketing, surveys, corporate systems)
• Support the development of dashboards and reports in Power BI, ensuring reliable data for analysis and decision-making
• Collaborate with business, analytics and technology teams to understand requirements and translate them into data solutions
• Document processes, models and data pipelines, following engineering and governance best practices

Data & Analytics Engineer