BI Data Engineer, Pleno

This is a fully remote position, open to applicants in Panama.

📋 Description

• Design, build, and maintain data integration processes (ETL/ELT)

• Model information for business analysis

• Automate data flows

• Develop solutions for data-driven decision-making

• Create scripts for data processing

• Design and construct data pipelines

• Develop ETL/ELT processes

• Extract data from databases, APIs, flat files, and cloud services

• Implement data validation and quality control measures

• Develop and maintain DAGs

• Schedule processes

• Manage dependencies and monitor loads

• Build Data Marts

• Design KPIs and business indicators

⛳️ Requirements

• Advanced SQL

• Oracle Database

• Query optimization and tuning

• Design of relational and dimensional models

• Proficient in stored procedures, views, and functions

• Advanced Python

• Development of scripts for data processing

• Pandas

• NumPy

• SQLAlchemy

• API consumption and integration

• Apache Airflow

• Development and maintenance of DAGs

• Process scheduling

• Management of dependencies and load monitoring

• Dimensional modeling (Star Schema and Snowflake)

• Data Warehousing

• Construction of Data Marts

• Design of KPIs and business indicators

🏝️ Benefits

• Inclusion of individuals with disabilities (the position is also open to persons with disabilities)

• Remote work