ITE/ITO Data Engineer Consultant

Technical Support
2100000452 Requisition #

ITE/ITO Data Engineer Consultant


Background of this search: The ITE/ITO Data Management team is looking for a Data Engineer professional with a technical background and experience on data warehousing, big data, cloud platforms, scripting and ETL/ELT. The consultant will be tasked with identifying issues and designing solutions that fit within the overall business logic, architecture and governance of the Data Management cloud platform and IDB’s strategy.


The team’s mission: The ITE/ITO Data Management team provides system analysis, design and development of data warehouse models and ETL processes to automate data extraction/transformation/loading and participates in the technical support and documentation of the new subject areas from Operational and Corporate streams of implementation in EDW. At the same time, the team leads the Data Governance, Quality and Cloud Data Platform initiatives leveraging the latest technologies available.


What you’ll do: Organize key responsibilities with bullet points (between 4-6), use clear and simple sentences to describe exactly what the person will do (quantify as much as possible).

• Assume ownership of the requirements collection, design and delivery of new data models, including data warehouse solutions and ETL process, for various projects.

• Provide guidance to support team on current financial and operational warehouse solutions.

• Data mapping processes review and documentation. 

• Support the data asset inventory organization wide.

• Support impact assessment of new warehouse releases.

• Define best practices for data integration design, development and implementation including architectural and element naming standards and conventions.

• Performs data source analysis and data dictionary administration.

• Design and build ETLs and data pipelines leveraging latest technologies

• Defines dimensional models in support of analytical requirements; star schema, snowflake designs; as well as data lakes for real time analytics.

• Participates in data quality assessments and data governance initiatives.

• Provide expertise in modeling operational data stores, staging areas, central repositories and data marts. Data modeling competency would include both 3NF and dimensional modeling techniques as well as business rules modeling expertise.

• Transforming business requirements into logical data models with focus on metadata strategy and architecture.

• Design, architect and execute Advanced Analytics strategies to improve IDB’s infrastructure and capacity to perform this kind of projects.

• Provide support and guidance to specialists and key stakeholders regarding analytics and data related subjects


What you’ll need:

Citizenship: You are a citizen of one of our 48-member countries. We may offer assistance with relocation and visa applications for you and your eligible dependents.

Consanguinity: You have no family members (up to fourth degree of consanguinity and second degree of affinity, including spouse) working at the IDB Group.

Education: BS in Computer Science, Information Systems or equivalent work experience.

Experience: Minimum 2 years work experience in the Information Technology field.

- Experience in building production grade data architectures leveraging the latest cloud and on-prom technologies.

- Working knowledge of data storage and processing formats for data integration and data warehousing solutions.

- Experience with NoSQL databases like DynamoDB, CosmosDB or MongoDB as well as SQL databases like Oracle, SQL Server, and DB2.

- Solid understanding of SQL and SQL optimization techniques.

- Solid understanding of algorithms, data structures and deep data analytics using machine learning libraries and BI tools.

- Software development experience using Java, Scala, Python and other scripting languages like Perl, Linux, PHP, Ruby, R.

- Good documentation skills, excellent written and verbal communication skills.

- Must be able to work in a fast-paced agile development environment.

- Strong interpersonal and communication skills, self-motivation, commitment and the ability to work in an international team and across hierarchical levels are indispensable.

- Proven ability to work in an interdisciplinary environment and in a context of dynamic change.

- Proficiency in written and oral English is required.

Languages: English & Spanish


Core and Technical Competencies:

•             Scripting and Analytics tools: Python, R, Spark, AWS SageMaker, Azure Data Bricks

•             Data Integration tool: IBM Information Server suite, Azure Data Factory, AWS Glue & Athena

•             Databases and storage platforms: DB2, Oracle, SQL Server, CosmosDB, DynamoDB, S3

•             Data Virtualization: Denodo

•             Denormalization, Abstraction and other Data warehousing modeling techniques

•             Very good teamwork and communication skills

•             Technical writing ability

•             Experience working with Finance, Treasury and Risk systems is a plus (not required) 


Opportunity Summary: 

Type of contract: CNS Full Time

Length of contract: 18 months

Starting date: 05/01/2021

Location: IDB HQ, Washington DC, US

Responsible person: IT SR ASSOCIATE

Requirements: You must be a citizen of one of the IDB’s 48 member countries and have no family members currently working at the IDB Group.  


Our culture: Our people are committed and passionate about improving lives in Latin-America and the Caribbean, and they get to do what they love in a diverse, collaborative and stimulating work environment. We are the first Latin American and Caribbean development institution to be awarded the EDGE certification, recognizing our strong commitment to gender equality. As an employee you can be part of internal resource groups that connect our diverse community around common interests.

Because we are committed to providing equal opportunities in employment, we embrace all diversity and encourage women, LGBTQ+, persons with disabilities, afro-descendants, and indigenous people to apply.

About us: At the IDB, we’re committed to improving lives. Since 1959, we’ve been a leading source of long-term financing for economic, social, and institutional development in Latin America and the Caribbean. We do more than lending though. We partner with our 48-member countries to provide Latin America and the Caribbean with cutting-edge research about relevant development issues, policy advice to inform their decisions, and technical assistance to improve on the planning and execution of projects. For this, we need people who not only have the right skills, but also are passionate about improving lives.


Due to the current COVID-19 pandemic and its implications for our Region, the IDB Group is reviewing its hiring needs and re-prioritizing its areas of talent acquisition. We encourage candidates to continue to apply to the active postings, yet current job openings may be subject to further decisions in terms of timing of the processes, or other actions, in accordance with business needs. Final hiring decisions may also be conditioned to the candidate’s ability to timely relocate to the post of duty at the moment of starting service.


Our team in Human Resources carefully reviews all applications.



Previous Job Searches

My Profile

Create and manage profiles for future opportunities.

Go to Profile

My Submissions

Track your opportunities.

My Submissions

Similar Listings

Washington DC, United States - Headquarters

📁 Technical Support

Washington DC, United States - Headquarters

📁 Technical Support

Washington DC, United States - Headquarters

📁 Technical Support