Senior Data Engineer
Description
Company Overview
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: Senior Data Engineer
Position: Senior Data Engineer
Location: Remote - Colombia
Position Overview
We are seeking a Senior Data Engineer with a strong Analytics focus to support and scale our data infrastructure while enabling high-impact analytics and business intelligence. This role is a hybrid between Data Engineering and Data Analytics, ideal for someone comfortable working end-to-end: from building robust ETL pipelines to designing and developing advanced dashboards for business stakeholders. You will work closely with technical and business teams to design, build, and optimize data pipelines, transactional databases, analytics models, and visualizations that support our growing business needs. Your responsibilities will include:
We are seeking a Senior Data Engineer with a strong Analytics focus to support and scale our data infrastructure while enabling high-impact analytics and business intelligence. This role is a hybrid between Data Engineering and Data Analytics, ideal for someone comfortable working end-to-end: from building robust ETL pipelines to designing and developing advanced dashboards for business stakeholders. You will work closely with technical and business teams to design, build, and optimize data pipelines, transactional databases, analytics models, and visualizations that support our growing business needs. Your responsibilities will include:
- Design and develop scalable data pipelines and workflows using Airflow to orchestrate data ingestion, transformation, and delivery.
- Build robust and highly available data solutions leveraging AWS services (S3, RDS PostgreSQL, IAM, EC2, Lambda, etc.).
- Design, develop, and maintain ETL processes to extract, transform, and load data from multiple sources.
- Implement and maintain advanced dbt models on Snowflake, applying best practices for testing, documentation, modularity, and performance.
- Design and optimize analytics-ready data models aligned with business requirements. Develop and maintain transactional databases in PostgreSQL on AWS RDS, ensuring optimal performance and reliability.
- Collaborate with application teams to design and optimize normalized transactional data structures.
- Ensure data quality, consistency, and reliability across data pipelines and systems.
- Build and develop advanced Power BI dashboards and reports, enabling clear, actionable insights for decision-making.
- Apply strong data visualization best practices to ensure dashboards are intuitive, performant, and business-focused.
- Monitor, troubleshoot, and optimize data pipelines and analytics workloads proactively.
- Collaborate with cross-functional teams (Data Science, Product, IT, Business) to ensure seamless data integration.
- Participate in architecture reviews, technical roadmaps, and strategic planning discussions.
Required Skills & Experience
- Bachelor’s degree in Systems Engineering, Computer Science, Engineering, or a related field. 4+ years of experience in Data Engineering, Analytics Engineering, or a similar role.
- AWS (MUST): Strong hands-on experience with S3, RDS (PostgreSQL), IAM, and related AWS services.
- Snowflake (MUST): Proven experience designing, developing, and optimizing data models and SQL queries.
- dbt (MUST): Strong experience building and maintaining dbt projects for analytics, including testing, documentation, and optimization.
- Power BI (MUST – ADVANCED): Advanced expertise in Power BI, including data modeling, DAX, performance optimization, and the design of complex, business-ready dashboards.
- ETL: Solid experience designing and maintaining data pipelines for large datasets.
- Databases: Strong proficiency in PostgreSQL, including transactional data modeling and SQL optimization.
- Orchestration: Hands-on experience using Airflow to automate and monitor data workflows.
- Programming: Proficiency in Python and SQL.
- Comfortable working end-to-end, from ETL processes to analytics modeling and dashboard development
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 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.