Junior Business Intelligence Engineer

Company Overview Lean Tech is a rapidly expanding organization situated in Medellín, Colombia. We pride ourselves on possessing one of the most influential networks within software development and IT services for the entertainment, financial, and logistics sectors. Our corporate projections offer many opportunities for professionals to elevate their careers and experience substantial growth. Joining our team means engaging with expansive engineering teams across Latin America and the United States, contributing to cutting‑edge developments in multiple industries. Position Title & Location Junior Business Intelligence Engineer – Remote (LATAM) Responsibilities Assisting in the development and maintenance of Power BI dashboards using Power BI Desktop and Power BI Service. Supporting basic data modeling tasks using star schema concepts and helping maintain clean, structured datasets. Preparing and transforming data using Power Query to extract information from Excel, Outlook, Salesforce, CRM platforms, and other sources. Helping write and optimize simple SQL queries for data extraction and reporting. Performing data validation to ensure accuracy and consistency in reports. Updating recurring reports and assisting with scheduled data refreshes. Supporting integration of data from multiple sources to create unified reporting views. Creating user-friendly visualizations under the guidance of senior team members. Participating in requirement‑gathering sessions with internal teams to understand reporting needs. Documenting processes, report logic, and data flows. Conducting initial data analysis to identify trends, issues, or opportunities that support business operations. Requirements & Qualifications 1–2 years of experience in Business Intelligence, data analysis, reporting, or related coursework/internships. Basic to intermediate experience with Power BI Desktop (building dashboards, using Power Query, creating simple DAX measures). Exposure to Salesforce, Outlook, or other operational systems. Foundational knowledge of SQL (joins, filters, basic calculations). Understanding of data modeling concepts such as fact and dimension tables. Ability to clean, transform, and organize data from spreadsheets or simple system exports. Willingness to learn how to work with multiple data sources (CRM, Excel, email‑based data, etc.). Good analytical and problem‑solving skills. Attention to detail when validating or presenting data. Motivation to grow technical skills and take on more complex BI tasks over time. Nice to Have Basic understanding of QA/data validation processes. Familiarity with geographic or market analysis tools (e.g., Google Maps). Experience automating simple workflows in Excel, Power Query, or low‑code tools. Knowledge of Python or interest in learning it for automation in the future. Soft Skills Strong communication skills and the ability to work with both technical and non‑technical stakeholders. Proactive attitude, willingness to ask questions, and desire to improve. Strong sense of ownership for assigned tasks. Ability to work independently once trained, and to manage deadlines responsibly. Eagerness to learn new tools, technologies, and BI practices. Proactive approach to problem‑solving and identifying opportunities for business improvement through data, leveraging analytical expertise. Adaptability when working with stakeholders of varying technical backgrounds, including tailoring reports for both technical and non‑technical users. Curiosity and willingness to explore new tools and methods to optimize processes and enhance overall BI solution effectiveness. Benefits Join a powerful tech workforce and help us change the world through technology. Professional development opportunities with international customers. Collaborative work environment. Career paths and mentorship programs that will lead to new levels. Seniority Level Entry level Employment Type Full‑time Industries IT Services and IT Consulting Lean Tech is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. #J-18808-Ljbffr