Software Engineer Data Warehouse

hace 3 semanas

San José, 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 semanas

    San José, 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 1 semana

    San José, San José, Costa Rica 360Training A tiempo completo

    **Data Warehouse 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...

  • Data Warehouse Engineer

    hace 3 semanas

    San José, 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...

  • Data Warehouse Architect

    hace 1 semana

    San José, San José, Costa Rica Credito Real Usa Finance Llc A tiempo completo

    Job OverviewCredito Real Usa Finance Llc is seeking a seasoned data warehouse professional to lead the design, development and maintenance of our enterprise data warehouse solution. As a Microsoft data engineer leader, you will be responsible for providing technical leadership for strategy, architecture, design, development, testing, production launch, and...

  • Data Warehouse Engineer

    hace 6 días

    San José, San José, Costa Rica Tek Experts A tiempo completo

    Overview:We're searching for a Data Warehouse Engineer with a proven track record of developing Business Intelligence solutions to drive key outcomes.The role is responsible for different layers of the data hierarchy - including database design, data collection and storage techniques, to a deep understanding of data transformation tools and methodologies,...

  • Software Data Engineer Ii

    hace 2 semanas

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

    Come join a winning teamHere 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 our...

  • Data Warehouse Architect

    hace 5 horas

    San José, San José, Costa Rica beBee Careers A tiempo completo

    We are seeking an experienced Data Warehouse Architect to join our team and help us design and implement scalable data warehouses.About the role:Design and develop data warehouse architectures using data vault and star schema methodologies.Implement and maintain PowerBI models, reports, and paginated reports to meet business needs.Collaborate with...

  • Software Data Engineer II: Cloud-Native Data Architect

    hace 24 horas

    San José, San José, Costa Rica beBee Careers A tiempo completo

    Data Engineer Role OverviewYou will play a pivotal role in shaping the architecture, design, and development of a cloud-native, multitenant SaaS product as a data lake/warehouse for multiple lines of businesses.Cross-functional teams and stakeholders will rely on your expertise to develop resilient, dependable, and high-performing software.Key...

  • Senior Data Engineer

    hace 2 días

    San José, San José, Costa Rica beBee Careers A tiempo completo

    Senior Data Engineer PositionWe are seeking a highly skilled Senior Data Engineer to join our team. The ideal candidate will have expertise in designing data solutions that meet business, technical, and user requirements.The successful candidate will be responsible for building modern data pipelines, reports, and data visualizations using data from the...

  • Software Engineer Ii

    hace 4 semanas

    San José, 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...