Data Integrator

Description

Job Summary: We are seeking a Data Integrator to integrate, transform, and model data, ensuring reliable information for business analysis. Key Highlights: 1. Key role in building data infrastructure for analytics 2. Responsible for ETL pipelines and database modeling 3. Development and optimization of data integration solutions We are looking for a **Data Integrator** responsible for **integrating, transforming, and modeling data** from diverse sources, ensuring the availability of reliable information for KPI generation and business analysis for our **client ON EMPRESAS.** This role is critical for building the data infrastructure supporting organizational analytics: ETL pipelines, database modeling, and process automation. ***Key Responsibilities*** * Gather requirements and identify business indicators, metrics, and dimensions. * Analyze and document various information sources. * Develop **ETL** processes for data integration and loading using **SSIS**. * Program data integration solutions using **Python**. * Develop and optimize procedures, functions, and jobs in **SQL Server**. * Create data dictionaries. * Design **multidimensional data models** and database structures. * Develop dashboards and reports in **Power BI** (desirable). * Administer and develop solutions with **SSIS, SSAS, and SSRS**. * Perform database tuning and optimization (non-exclusive). ***Requirements*** * University graduate in Systems Engineering, Computer Engineering, or related fields. * Minimum of **2 years** of experience in similar positions. * Advanced knowledge of: * SQL Server (2012 and later). * Transact\-SQL (stored procedures, functions, and jobs). * SSIS, SSAS, and SSRS. * Power BI (Power Query and DAX). * Python for ETL processes. * Advanced Excel. ***Position Details*** * **Work Mode:** On-site * **Location:** Av. Gálvez Barrenechea – San Isidro * **Working Hours:** Monday to Friday, 9:00 a.m. to 6:00 p.m. * Formal employment contract with all statutory benefits * Partially covered EPS health insurance * Corporate equipment Salary: S/.4,000\.00 \- S/.6,000\.00 per hour Expected hours: 48\.0 per week Application Questions: * What is your earliest possible start date? * 1\. How many years of experience do you have developing ETL processes with SSIS (SQL Server Integration Services)? * Have you designed multidimensional data models (star or snowflake schema) in a professional, not just academic, setting? * 3\. Do you have experience writing stored procedures, functions, and jobs in Transact\-SQL (SQL Server)? * What is your salary expectation on formal employment contract? Workplace: On-site employment