Mid Data Analyst

At Lean Tech, we are dedicated to building sophisticated and scalable digital solutions. As a forward-thinking organization, we are undertaking a significant strategic initiative to modernize our data infrastructure, migrating from a custom legacy stack to a state-of-the-art, cloud-based platform. Our culture is rooted in collaboration, continuous learning, and adaptability, fostering a dynamic and global team environment where engineers are empowered to solve complex challenges and uphold high engineering standards.

Position: Mid+ Level Data Analyst

Location: Remote - Colombia

Position Overview

We are seeking a Mid+ Data Analyst with a strong Data Engineering focus to bridge the gap between complex data infrastructure and actionable business intelligence. This role is designed for an analytical professional who is comfortable working end-to-end: from building and optimizing the ETL pipelines that feed our ecosystem to designing advanced, high-impact dashboards for business stakeholders. You will work closely with cross-functional teams to ensure that our data is not only robust and highly available but also translated into intuitive visualizations and models that drive strategic decision-making. Your responsibilities will include:

Advanced Visualization: Build and develop complex Power BI dashboards and reports, applying data visualization best practices to ensure they are intuitive, performant, and business-focused.

Analytics Modeling: Design and optimize analytics-ready data models in Snowflake, using dbt to ensure data is structured correctly for high-level reporting and self-service BI.

Pipeline Ownership: Design and develop scalable data pipelines and workflows using Airflow to ensure the timely delivery of data for analysis.

Data Ingestion & Transformation: Maintain and optimize ETL processes using Python and SQL to extract data from multiple sources and load it into our analytics environment.

Insight Generation: Monitor and analyze data quality, consistency, and reliability across systems to ensure business stakeholders are making decisions based on accurate information.

Collaborative Optimization: Work with application and product teams to optimize normalized transactional data structures in PostgreSQL for better reporting performance.

Technical Troubleshooting: Proactively monitor and optimize analytics workloads and data pipelines to minimize downtime and improve dashboard latency.

Cross-functional Integration: Act as the technical link between Data Science, Product, and Business teams to ensure seamless data integration and alignment with business requirements.

Required Skills & Experience

Bachelor’s degree in Systems Engineering, Computer Science, or a related field with 4+ years of experience in Data/Analytics Engineering or Data Analysis.

Power BI (Advanced): Expert-level proficiency in DAX, data modeling, performance optimization, and designing business-ready dashboards.

Snowflake & dbt: Proven experience building analytics-ready models, including testing, documentation, and SQL query optimization.

SQL & Python: Strong programming skills for data manipulation, analysis, and pipeline scripting.

AWS: Hands-on experience with S3 and RDS (PostgreSQL) for data storage and management.

Orchestration: Experience using Airflow to automate and monitor the data workflows that power your reports.

Databases: Solid understanding of PostgreSQL, including transactional data modeling and optimization for analytics.

ETL/ELT: Practical experience designing and maintaining data pipelines for large, complex datasets.

Nice to Have Skills

Experience using JavaScript, HTML, and CSS for

○ Dashboard customization

○ Embedded analytics

○ Supporting low-code / no-code solutions when required

Familiarity with low-code / no-code platforms (e.g., Lovable or similar).

Soft Skills

Experience working closely with business stakeholders and translating requirements into data solutions.

Strong analytical mindset and attention to detail.

Proactive, go-getter mentality.

Trustworthy and dependable.

Strong communication and interpersonal skills.

Ability to adapt and thrive in dynamic, fast-paced environments.

Comfortable collaborating across technical and non-technical teams.

Accountability.

Why You Will Love Working with Us

Join a powerful tech workforce and help us change the world through technology. Professional development opportunities with international customers, a collaborative work environment, a 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.

Apply Apply Later

← Back to Current Openings

Share

LinkedIn

Facebook

Twitter

Email

Powered by Jobvite