Software Engineer Data Warehouse
hace 6 días
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 1 día
San José, Costa Rica Credito Real Usa Finance Llc A tiempo completo***We are one of the nation's top automobile loan providers and we are searching for a* Microsoft** **Database Engineer *in Costa Rica.This individual will be responsible with 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 6 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 día
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 Architect
hace 2 días
San José, San José, Costa Rica Credito Real Usa Finance Llc A tiempo completoCompany Overview">Credito Real Usa Finance Llc is a leading automobile loan provider seeking a highly skilled Data Warehouse Engineer to join our team in Costa Rica. Our company prides itself on providing excellent customer service and innovative solutions for our clients.">Job Description">We are looking for an experienced data warehouse engineer to design,...
-
Data Warehouse Engineer
hace 1 día
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, error...
-
Software Data Engineer Ii
hace 21 horas
San José, Costa Rica Imprivata A tiempo completoCome join a winning team! Here at Imprivata, you’ll see a dedicated group of professionals who care about improving healthcare. Our team thrives on collaboration and sharing ideas, whether in a cross-functional meeting or at one of our virtual team-building events. While we're diverse in our backgrounds and skills, we have much in common. A passion for...
-
Data Analytics Engineer
hace 1 semana
San José, San José, Costa Rica Encora A tiempo completoWe are seeking a talented Data Analytics Engineer to join our team in Latam.About UsEncora is a global company that provides innovation services and software engineering solutions. With over 27 years of experience in the market, we have established ourselves as a leading provider of nearshore services for companies of all sizes.Job DescriptionAs a Data...
-
Sr Data Engineer
hace 6 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 1 día
San José, Costa Rica Dtodo Tech Innovations Srl A tiempo completoThe 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...
-
Senior Data Engineer
hace 1 día
San José, Costa Rica Encora A tiempo completoWe're looking for a Senir Data Engineer to join our team.**What do we expect from you?**- PowerBI Modeling, PBI reports and PBI paginated reports- Python (PySpark, NumPy, pandas concentration)- Data vault and Star schema design methodology- Azure (especially anyone with Synapse Dedicated / Serverless pools or Parallel Data Warehouse, or DataBricks)**Laboral...
-
Data Engineer
hace 1 día
San José, Costa Rica Tmf Group A tiempo completo**Job no**: 565972**Work type**: Full time**Location**: Bogota, Colombia, San Jose, Costa Rica, Toronto, Canada**Categories**: Information Technology**Office Location**: Canada - Toronto**About TMF Group**TMF Group is a leading provider of critical administrative services, helping clients invest and operate safely around the world.We provide legal, financial...
-
Data Engineer Leader
hace 2 días
San Francisco, Heredia, Costa Rica Ntt Data A tiempo completoWe are seeking a talented Data Engineer to lead our team in Heredia, Costa Rica. The estimated salary for this role is $60,000 - $90,000 per year, based on industry standards and the candidate's experience.Job DescriptionThe Data Engineer will design, build, and operate high-performance data-centric solutions using big data capabilities for our data platform...
-
Data Engineer
hace 1 día
San José, Costa Rica 360Training A tiempo completo**Data Engineer****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, error handling, logging, etc.- Provide support to the...
-
Integration Engineer
hace 3 días
San José, Costa Rica OfficeSpace Software A tiempo completo**Create A Better Place For Everyone**: OfficeSpace is a workplace management software that gives companies everything they need - an innovative platform, an intuitive experience, and an invested team. Our customers are an extremely diverse group, from the fastest growing technology companies to traditional enterprise customers who are transitioning to a...
-
Lead Data Engineer
hace 1 día
San José, Costa Rica Encora A tiempo completoAt Encora we are looking for a great talent like you to join our team as the next **Lead** Data Engineer (9988)**Would you like to join our great team of engineers?Here we will tell you more about us and the role!**Our Requirement**:- 8+ years of software development experience with at least 4+ years building data products/ data platforms/ Cloud data...
-
Senior Data Engineer
hace 1 día
San José, Costa Rica Encora A tiempo completoAt Encora we are looking for a great talent like you to join our team as the next **Senior Data Engineer (9989)**Would you like to join our great team of engineers?Here we will tell you more about us and the role!**Our Requirement**:- 8+ years of software development experience with at least 4+ years building data products/ data platforms/ Cloud data...
-
Data Architect
hace 5 días
San Francisco, Heredia, Costa Rica Philip Morris International A tiempo completo**Overview**This role can be based in various locations, including Costa Rica, Guatemala, El Salvador, Panama, Dominican Republic, or other Philip Morris International offices.As a key member of the Data & Solutions team at Philip Morris CARICOM, you will play a vital role in shaping the data strategy for our organization. You will collaborate closely with...
-
Data Engineer
hace 6 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...
-
Integration Engineer
hace 23 horas
San José, Costa Rica Officespace Software A tiempo completo**Create A Better Place For Everyone**:OfficeSpace is a workplace management software that gives companies everything they need - an innovative platform, an intuitive experience, and an invested team.Our customers are an extremely diverse group, from the fastest growing technology companies to traditional enterprise customers who are transitioning to a more...
-
Data Engineer
hace 1 día
San José, Costa Rica Cloudera A tiempo completoJob Description:Cloudera Data Engineers are focused on working internally on Cloudera's Data Warehouse implementation for purposes of ingesting data for Business Operations and Analytics.A Data Engineer is responsible for the design and implementation of data pipelines, drawing on a range of Big Data technologies to support data ingestion and transformation...