DATA ENGINEER - BI

Description

Job Summary: Analyze, develop, implement, and support data solutions on Oracle Cloud Infrastructure (OCI), ensuring information reliability and integrity for decision-making. Key Highlights: 1. Development and implementation of BI and data solutions on OCI. 2. Advanced SQL and Python usage for automation. 3. Participation in the construction and evolution of Data Lake/Warehouse. Job Objective: Analyze, develop, implement, and support data solutions across the Oracle Cloud Infrastructure (OCI) ecosystem, using SQL and Python for data integration, transformation, automation, and analytics. Participate in functional testing, data quality validation, and performance testing to ensure data reliability, integrity, and availability to support business operations and decision-making. * Bachelor's degree in Systems Engineering, Software Engineering, or related field. * 3–4 years of experience in developing and implementing **Business Intelligence and data solutions**, and in developing data solutions on **Oracle Cloud Infrastructure (OCI)**. **Technical Skills:** * **OCI:** Oracle Cloud Infrastructure (OCI), OCI Data Integration, OCI Object Storage, OCI Autonomous Database, OCI Data Flow, OCI Functions, OCI IAM (Identity and Access Management), monitoring and management of OCI resources. Experience with agile methodologies (Scrum, Kanban). * **SQL:** Oracle Database, advanced SQL, query optimization, data modeling, creation of stored procedures, views, and PL/SQL packages. * **Python:** Script development for automation, data processing and transformation, use of libraries such as Pandas, NumPy, SQLAlchemy, cx\_Oracle / oracledb, integration with APIs and cloud services. * **Integration and Analytics:** ETL / ELT, Data Warehouse, Data Lake, dimensional modeling, data quality and governance. **Responsibilities:** * Analyze business requirements and translate them into data integration and analytics solutions. * Design, develop, and maintain ETL/ELT processes for extracting, transforming, and loading data from diverse information sources. * Participate in building and evolving the corporate Data Lake \- Data Warehouse, ensuring proper data integration, storage, and availability. * Develop and optimize SQL queries, stored procedures, and data transformation processes to ensure efficient processing. * Create and maintain automated processes using Python for integration, validation, processing, and monitoring of information. * Execute functional tests, integration tests, and quality validations on implemented developments. Work Location: On-site employment