IDB Invest - Data Analyst External Consultant (PEC) - Financial Products and Services Division
Location: United States of America
The IDB Group is a community of diverse, versatile, and passionate people who come together on a journey to improve lives in Latin America and the Caribbean. Our people find purpose and do what they love in an inclusive, collaborative, agile, and rewarding environment.
About this position:
The Investment Operations Department (INO) is responsible for generating a portfolio of high quality, creditworthy, and environmentally and socially sound projects that result in significant developmental impact. The business cycle goes from the identification, selection, origination, structuring and execution of transactions to their monitoring. The Department follows a matrix model, with three segment divisions covering Infrastructure and Energy, Financial Institutions and Corporates, and two transversal divisions covering Financial Products and Services, and Portfolio Management.
The Financial Products and Services Division (FNP) works closely with the Segment divisions to provide product-structuring expertise in the following broad range of products and services: blended finance, capital markets solutions, equity and mezzanine, trade and supply chain finance and resource mobilization. The external consultant will report to the Equity & Mezzanine Team (EQM). The EQM team is responsible for supporting the origination, structuring, negotiation, approval and closing of equity and mezzanine investment deals in the Latin America and the Caribbean.
What youโll do:
You will collaborate with stakeholders to build a solution that streamlines and centralizes the entire equity and mezzanine investment cycle. Your main responsibilities will include:
โข Data Integration. Collect, organize, and integrate financial and non-financial investee data from various sources, including SQL databases, Excel, and other flat files.
โข Database Creation. Design and create new databases to store integrated data.
โข Data Modeling and Transformation. Create data models and implement data transformations to enable analytics on portfolio and company-level performance, leveraging data science toolsets, such as Power Query, SQL, Python and/or others.
โข Analytics and Visualization. Analyze datasets to identify actionable insights. Design and build interactive dashboards, reports, and visualizations using Power BI.
โข Collaboration. Collaborate effectively with stakeholders, including technology, operations, and domain experts.
โข Documentation. Create and maintain detailed documentation of data sources, integration processes and user manual.
Deliverables and Payments Timeline:
Deliverable #
Percentage
Integrated Database
70%
Interactive Dashboard
30%
What you'll need:
Education: bachelorโs degree (or equivalent advanced degree) in Business analytics, Finance, Computer Science, Data Science or other fields relevant to the responsibilities of the role. Experience: At least 2 years of relevant work experience (reporting, analytics, data management) with preferred exposure to alternative investments. Experience gathering and interpreting data. Knowledge of Power BI, Databricks and programming languages. High degree of adaptability to changing requirements. Ability to self-start and propose data-driven solutions. Languages: Proficiency in English and one of the other Bank official languages (Spanish, French or Portuguese) is required.Key skills:
Learn continuously. Collaborate and share knowledge. Focus on clients. Communicate and influence. Innovate and try new things.Requirements:
Citizenship: No requirement for IBD Invest. Consanguinity: You have no family members (up to the fourth degree of consanguinity and second degree of affinity, including spouse) working at the IDB, IDB Invest, or IDB Lab.Type of contract and duration:
Type of contract: Products and External Services Consultant (PEC), Lump Sum. Length of contract: 12 months. Work Location: Residence consultant .Our culture
At the IDB Group we work so everyone brings their best and authentic selves to work, willing to try new approaches without fear, and where they are accountable and rewarded for their actions.
Diversity, Equity, Inclusion and Belonging (DEIB) are at the center of our organization. We celebrate all dimensions of diversity and encourage women, LGBTQ+ people, persons with disabilities, Afro-descendants, and Indigenous people to apply.
We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job interview process. If you are a qualified candidate with a disability, please e-mail us at diversity@iadb.org to request reasonable accommodation to complete this application.
Our Human Resources Team reviews carefully every application.
About the IDB Group
The IDB Group, composed of the Inter-American Development Bank (IDB), IDB Invest, and the IDB Lab offers flexible financing solutions to its member countries to finance economic and social development through lending and grants to public and private entities in Latin America and the Caribbean.
About IDB Invest
IDB Invest, a member of the IDB Group, is a multilateral development bank committed to promoting the economic development of its member countries in Latin America and the Caribbean through the private sector. IDB Invest finances sustainable companies and projects to achieve financial results and maximize economic, social, and environmental development in the region. With a portfolio of $14.1 billion in asset management and 325 clients in 25 countries, IDB Invest provides innovative financial solutions and advisory services that meet the needs of its clients in a variety of industries.
Follow us:
https://www.linkedin.com/company/idbinvest/