Mid Level Business Intelligence (Power BI) Analyst

Description

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 a multitude of 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.

We are seeking a highly skilled Business Intelligence Analyst (Power BI). The ideal candidate will have extensive knowledge of and hands‐on experience with Microsoft Power BI and SQL with proven ability to work independently in converting business and functional requirements into complex reports, data visualizations and dashboards. This position will report directly to the Manager, Business Intelligence, and will work on projects that span all divisions. This role will be responsible for analyzing, cleansing, and transforming data from various sources, setting up security roles, and conducting training of end users. This includes providing technical and analytical guidance for Power BI architecture and implementing best practices in application systems development and
security. 

Location: Remote

What you will be doing:

● Serve as a valued business partner to the entire organization by developing creative solutions to provide management with actionable insights, answer business critical questions, and fulfill other information needs 
● Write SQL queries and retrieve data in a highly complex relational database environment.
● Design, configure, develop, and debug reports in Power BI 
● Build, update, and maintain technical documentation for projects 
● Interact effectively with business partners to understand business requirements and assist in developing project scope, requirements, timeline, and goal

Participate in architecture, technical design, and product implementation
discussions
● Provide ad-hoc data mining and analysis as requested

Requirements & Qualifications

To excel in this role, you should possess:

● Bachelor’s degree in Information Systems, Computer Science, Business, or a related field – or demonstrated, equivalent experience
● 3+ years of experience retrieving and providing data analysis using SQL
● 3+ years of experience in data preparation, modeling, and reporting using Microsoft Power BI (familiarity with all environments: Desktop, Services, Paginated, Gateway, libraries access, queries)
● 3+ years of experience with DAX and M languages regarding Power BI formulas and calculations
● Experience with relational databases such as Microsoft SQL, Oracle, or Essbase
● Strong proficiency with Microsoft Office, specifically Excel

Nice to have skills

● Background with business, finance, or supply-chain analytics
● Understanding of basic data warehousing concepts
● Familiarity with Microsoft Power Automate functionality
● Data Modeling using R/Python is a plus

Soft skills

● Analytical mindset and advanced problem-solving skills
● Strong attention to detail with proven ability to work collaboratively with internal and external teams
● Adaptable, flexible, and thrive in a fast-paced environment
● Highly motivated, proactive, self-starter and works well with minimal supervision

Output Summary of Main Tech skills

● Power BI, SQL (Expert)
● Data warehousing, embedded queries, libraries access (Expert)
● Previous knowledge of the industry (Expert)
● DAX knowledge (Advanced)
● MongoDB, Python, Azure Synapse (Good to have)

Why you will love Lean Tech:

● Join a powerful tech workforce and help us change the world through
technology
● Professional development opportunities with international customers
● Collaborative work environment
● Career path and mentorship programs that will lead to new levels.

Join Lean Tech and contribute to shaping the data landscape within a dynamic and growing organization. Your skills will be honed, and your contributions will play a vital role in our continued success. Lean Tech is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.