Description
Job Summary:
The Plenary Data Analyst will be responsible for developing, maintaining, and enhancing data pipelines, participating in data migration projects, and organizing the Data Warehouse.
Key Highlights:
1. Develop and enhance efficient and scalable data pipelines
2. Strategically participate in data migration projects
3. Organize and structure the Data Warehouse for data consumption
**Welcome to the Bringel Group — innovation and boldness are in our DNA.**
Innyx is a technology-mediated education company specializing in developing technological solutions for basic and corporate education, with presence across multiple Brazilian states. We have a multidisciplinary team aligned with technology and possessing solid experience in education. We deliver the best learning experiences and modern teaching methodologies, maximizing outcomes through:
Distance learning platforms, educational system development, publishing and studio services, educational management platforms, and corporate education, among others.
As a **Plenary Data Analyst**, you will be responsible for:
* Developing, maintaining, and enhancing efficient, secure, and scalable data pipelines;
* Strategically participating in data migration projects, ensuring data consistency, quality, and reliability;
* Organizing and structuring the Data Warehouse to facilitate data consumption by business areas;
* Identifying performance bottlenecks in Oracle and PostgreSQL environments and proposing technical and performance improvements;
* Creating and maintaining up-to-date documentation, including data lineage and data dictionaries.
What You Need:
* Bachelor's degree in Computer Science, Data Science, or related fields;
* Proven experience with relational databases, especially Oracle (PL/SQL) and PostgreSQL;
* Advanced SQL skills, with solid experience handling large data volumes and query optimization;
* Experience with Google BigQuery;
* Solid knowledge of Data Warehousing, dimensional modeling (Star Schema and Snowflake), and ETL/ELT processes;
* Demonstrated experience in data migration projects, whether between relational databases or in on\-premise to cloud transition scenarios.