Software Engineer Data Warehouse

hace 4 días

San José, Costa Rica Dtodo Tech Innovations SRL A tiempo completo

Requirements:

- English Level C1+ or B2+
- Be able to rotative schedule
- Bachelor of Systems Engineering, Computer Science or Related
- Minimum 5+ years’ experience with star schemas, dimensional modeling, and extract transform load (ETL) design and development.
- Minimum 3+ year experience on Microsoft SSIS.
- Minimum 2+ year experience on Pentaho Data Integration.
- Expert in Data Warehouse life cycle methodologies and BI best practices.
- Expert tuning SQLqueries.
- Experience developing PL/SQL packages, procedures, views and triggers.
- Database Administration. Expertise working with various databases (Oracle, SQL Server)
- Expertise in designing and troubleshooting Pentaho data integration (kettle) jobs, transformations, steps and hadoop-hdfs-hive based data transformations.
- Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
- SSIS Advanced component experience required (transformation objects in data flow).
- Implementing ETL Packages using Data Transformation Services (DTS) and SSIS
- Writing complex Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs), Table Variables and Views.
- The individual must have full technical knowledge for all phases of a software development lifecycle and must be able to analyze and solve complex problems in a dynamic environment.
- This individual must have good oral and written communication skills.
- This individual must have development experience with ETL tools.
- Nice to have: Python, Azure Data factory, AWS RDW, API and S3 buckets

**Responsibilities**:

- Work with Business Analysts to correlate business requirements to domain entities and data elements
- Design, develop and maintain an information architecture and conceptual models for industry specific domain area.
- Lead/key contributor for development using ETL solutions like Pentaho PDI, SSIS.
- Work independently in determining impacts to code as per the requirements updates and fixes required for fixing defects
- Develops data and metadata policies and procedures for cross-functional software development teams to build, maintain and leverage the data model, ensuring integration with customer and industry data standards.
- Work with Developers to design, implement and maintain scalable software solutions that use database structures designed and maintained by the Data Architect
- Review and evaluate database performance, risk and financial analysis feasibility studies
- Provides complete assessments of the technical characteristics of proposals and alternatives considered to optimize database performance.
- Reviews and assesses technical proposals requesting changes or upgrades to the existing databases.
- Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.
- Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for the development work.

**Salary**: ₡1,500,000.00 - ₡2,000,000.00 per month

**Education**:

- Bachelor's (required)
**Experience**:

- Minimum experience in Data Warehouse design: 5 years (required)

**Language**:

- English Level C1+ or B2+ (required)

  • Data Warehouse Engineer

    hace 2 días

    San José, Costa Rica Credito Real USA Finance LLC A tiempo completo

    *** We are one of the United State’s top automobile loan providers and we are searching for a* Microsoft** **Database Engineer *in Costa Rica (remote) to be responsible the designing, building and maintaining our data warehouse. You will help to analyze our current capabilities while designing the next generation solution that will be core to the data...

  • Data Warehouse Engineer

    hace 1 semana

    San José, Costa Rica AME IT Solutions A tiempo completo

    **Position: Data Warehouse Engineer** Location: San Jose, CR (Onsite) **JOB DUTIES**: - Gather business requirements and create and document designs for Business Intelligence solutions. - Develop new and support existing ETL processes utilizing Azure data factory, logic apps, etc. - Document mappings of data points, describing various sources and targets,...

  • Data Warehouse

    hace 4 días

    San Francisco, Heredia, Costa Rica First Factory A tiempo completo

    We are seeking a Data Warehouse (DW) Data Engineer to design, build, and optimize a modern enterprise analytics platform. This individual will play a critical role in building, enhancing, and optimizing the enterprise data and analytics ecosystem. The role focuses on designing and developing ETL/ELT pipelines, Lakehouse/Warehouse models, and curated datasets...

  • Sr Data Engineer

    hace 4 días

    San José, Costa Rica Emerson A tiempo completo

    **Description**To support Business Intelligence using the Azure suite of Analytics & Data platforms The focus of the role is on the technical aspects and implementation of data gathering, integration and model design, with some report and dashboard creation. Working with Azure DevOps, Azure Synapse Analytics, and Power BI to support creation of data models...

  • Software Engineer Ii

    hace 2 semanas

    San José, Costa Rica Dtodo Tech Innovations SRL A tiempo completo

    The Software Engineer is responsible for designing and creating the data warehouse and all related extraction, transformation and load of data functions in the company. The developer will provide oversight and planning of data models, database structural design and development and works closely with the Data Architect. Duties include working in a...

  • Software Architect

    hace 4 horas

    San José Province, San José, Costa Rica Software Mind A tiempo completo

    Company Description We are Software Mind, an awesome team of engineers who are ready to ramp up any top-notch company's projects Our aim? To always be one step ahead. Become part of a multicultural company in constant growth with an excellent work environment certified by Great Place To Work Job Description OverviewSoftware Mind is seeking qualified...

  • Data Engineer

    hace 4 días

    San José, Costa Rica Emerson A tiempo completo

    **Description ***Software Development**: - Develops code and solutions that transfers/transforms data across various systems - Maintains deep technical knowledge of various tools in the data warehouse, data hub, - and analytical tools. - Ensures data is transformed and stored in efficient methods for retrieval and use. - Maintains data systems to ensure...

  • Data Engineer

    hace 2 días

    San José, San José, Costa Rica Equifax A tiempo completo

    Equifax is seeking a skilled and motivated Data Engineer to support our Product Management data initiatives. This role focuses on building, maintaining, and extending robust data pipelines to ensure critical business data is captured efficiently from platforms such as Aha and AODocs. You will work primarily within a Google Cloud Platform (GCP) environment,...

  • Data Engineer

    hace 2 días

    Pavas, San Jose, Costa Rica Euromobilia A tiempo completo

    Euromobilia busca un Data Engineer para construir las bases de nuestro ecosistema de datos: integraciones, ETLs, conexiones entre ERP–CRM–logística–instalaciones y preparación de datos para futuros modelos de IA.Buscamos alguien con fuerte dominio técnico y enfoque práctico.Si te apasiona armar sistemas de datos desde cero y participar en un...

  • Data Engineer

    hace 2 días

    San José, Costa Rica DXC Technology A tiempo completo

    **Responsibilities**: - Work as part of a team to develop Cloud Data and Analytics solutions - Participate in development of cloud data warehouses, data as a service, business intelligence solutions - Ability to provide solutions that are forward-thinking in data and analytics - Deliver a quality product - Coding complex Spark (Python), T-SQL - Developing...