About Koltiva


We are a technology-enabled service company empowering over half of the millions of producers and business users across 27 countries. We support some of the largest multinational companies by digitizing and verifying global supply chains. Our focus is to enhance traceability, inclusiveness, and sustainability.

We combine quadruple-tech (agritech, fintech, edutech, and climatech) with “boots on the ground” services to improve producers’ outcomes and profitability, while building more sustainable supply chains.

Our team is growing. With offices in 6 cities across the globe and still counting. Where in the world will you join us?

  1. PT KOLTIVA
    RA Mampang Office, 6th floor
    Jl. Mampang Prapatan Raya No. 66 A - 66 B, Mampang Prapatan, South Jakarta, 12790, Indonesia

  2. PT KOLTIVA
    Miles Coworking Space
    Jl. Jambu, Losari, Ujung Pandang, Makassar, South Sulawesi, 90113, Indonesia

  3. PT KOLTIVA
    Jl. Bumi Ayu Gg. Pungut Sari No.6, Sanur, South Denpasar, Denpasar City, Bali 80228, Indonesia

  4. KOLTIVA AG
    Baselstrasse 8
    4532 Feldbrunnen, Switzerland

  5. KOLTIVA SARL
    Arsène Usher Assouane 99, Riviera 3, Cocody, Abidjan, Côte d'Ivoire

  6. PT KOLTIVA
    Artech Space
    Jl. Sagan Kidul No. 14, Yogyakarta, 55223, Indonesia

What’s it like working at Koltiva?
At Koltiva, we embodied honest, open, and upfront communication. We always seek and continuously improve existing tech solutions while focusing on our business users. Here, delivering value and making an impact on our customers while insisting on great standards are what we are aiming for.

Our Core Values

  1. Be Transparent
    Embody honest, open, and upfront communication. Provide visibility and willingness to share information even when it is uncomfortable to do so.
  2. Always innovate
    Seek and continuously improve existing tech solutions. Where solutions do not exist, create them.
  3. Focus on the user
    Think user backward; consider market needs and requirements. All else will follow.
  4. Commit to real results
    Develop relationships that make a positive difference in our customers’ businesses. Ensure to deliver value.
  5. Make an impact
    Make better, do better, and be better for our customers, our employees, our partners, and the world at large.
  6. Insist on great standards
    Raise the performance bar and deliver high-quality processes products, and services.

Our Mission
We are digitizing agriculture end-to-end, from offering digital and financial inclusion to our farmers to delivering performance data verified by humans. From seed to table.

Our Vision
To be the world’s leading tech company in building ethical, transparent, and sustainable supply chains.

Benefits and perks of working with Koltiva include:

Compensation: Competitive salaries
Family benefits: Paid maternity / paternity leave
Lifestyle: Casual dress code, Flexible hours, Work-from-home
Progression: Professional development
Welfare: Health insurance

Do you belong with Koltiva?


Who is the Koltiva BI Engineer?

Job Overview

The BI Engineer is to ensure all support provided to customers in the form of reports and visualization, data checking and technical support in excellent service standards across all our web and mobile applications.


What are the key responsibilities of the BI Engineer?

Responsibilities and Duties
The BI Engineer Specific responsibilities in this role include:

  • Development of high-quality database solutions.
  • Develop, implement and optimize stored procedures, triggers and functions.
  • Develop procedures and scripts for data migration.
  • Analyze existing SQL queries for performance improvements or probably can suggest new queries.
  • Design, build and deploy BI solutions (e.g. reporting tools) or data analytics report using existing tools and databases.
  • Maintain and support data analytics platforms.
  • Create tools to store data (e.g. OLAP cubes).
  • Conduct unit testing and troubleshooting.
  • Evaluate and improve existing BI systems and data reporting platforms.
  • Commissioning and decommissioning of data sets.
  • Develop and execute database queries and conduct analyses.
  • Create visualizations and reports for requested projects.
  • Helping develop reports and analysis to another team.
  • Managing and designing the reporting environment, including data sources, security, and metadata.
  • Build appropriate and useful reporting deliverables.
  • Review data for deficiencies or errors, correct any incompatibilities if possible and check output.
  • Processing confidential data and information according to guidelines.
  • Provide quality assurance of imported data, working with quality assurance analyst if necessary.
  • Collaborate effectively with the development team by creating and issuing bug finding and proposing new feature upon request.
  • Stay up to date with new products and features.
  • Respond to queries for information and access relevant reports.
  • Comply with data integrity and security policies.

Requirements

  • Minimum one year of experience as a Data Analyst, a BI Developer or similar role
  • BS/MS degree in Computer Science, Engineering, Statistics or a related subject.
  • Knowledge of data analysis and reporting.
  • Experience using statistical tools for data analysis (Excel, SPSS, SAS).
  • Strong knowledge and experience with reporting packages (Business Objects etc.), databases (MySQL, PostgreSQL, etc.)
  • Having knowledge of programming as added value (PHP, JavaScript, or ETL framework).
  • Background in data warehouse design (e.g. dimensional modelling) and data mining.
  • In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
  • Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI).
  • Experience with MS Office (MS Excel in particular) and data programs.
  • Ability to work with stakeholders to assess potential risks.
  • Ability to translate business requirements into non-technical, lay terms.
  • High-level experience in methodologies and processes for managing large scale databases.
  • Demonstrated experience in handling large data sets and relational databases.
  • Understanding of addressing and metadata standards.
  • Excellent time management skills and attention to detail is required.
  • Analytical mind with a problem-solving attitude and critical thinking skills.
  • Ability and desire to learn new skills and techniques.
  • Ability to work multi-task and under strict deadlines.
  • Ability to work independently and as part of a team.
  • High-level written and verbal communication skills, including communicating technical issues to non-technical audiences.
  • Diligent and firm with high ethical standards.

How do you apply?

Kindly submit your updated CV to recruitment@koltiva.com with subject (BI Engineer)


Jobs Details

  • Location: Jakarta, DKI Jakarta
  • Advertised: 29 August 2022
  • Application Close: 28 October 2022



Join the Agritech Revolution

We are the first company with boots on the ground to make supply chains traceable, inclusive, and sustainable.