Lead Data Engineer

This is a fully remote position, open to applicants in Colombia.

📋 Description

• Create, develop, and sustain automated data pipelines and analytical solutions.

• Streamline manual reporting tasks and repetitive data processes.

• Enhance SQL queries, data models, and processing efficiency.

• Assist in preparing production data and scoring models for predictive analytics.

• Oversee data quality, resolve pipeline issues, and enhance reliability.

• Partner with both business and technical stakeholders to provide scalable data solutions.

• Advocate for data engineering best practices and foster continuous improvement.

⛳️ Requirements

• Significant experience as a Data Engineer, Analytical Data Engineer, Analytics Engineer, BI Developer, Reporting Engineer, or a similar position, demonstrating a successful history of designing, automating, and delivering production reporting and analytical solutions.

• Proficient in SQL Server and database management.

• Strong capabilities in SQL Server development and database administration, including crafting complex queries, enhancing performance, and managing production reporting and analytical tasks.

• Ability to convert vague business inquiries into effective SQL solutions utilizing joins, window functions, CTEs, and sound data modeling principles.

• Skilled in Python for automation, data manipulation, and analytical processes.

• Experience with Databricks for developing, maintaining, and supporting production data pipelines and analytical solutions.

• Proven track record in creating reports and dashboards using Tableau or similar BI tools.

• Competence in designing reporting solutions that are actively utilized by the business and effectively communicating the purpose and value of each report.

• Experience transitioning recurring reporting tasks from manual execution to automated production solutions.

• Comfortable determining the appropriate technology—whether SQL, Python, or another—to construct scalable and maintainable data workflows.

• Experience in supporting predictive model production processes, including model scoring, preparing production data, scheduling workflows, monitoring, troubleshooting, and ensuring reliable operational execution of analytical models.

• Capability to interpret an undocumented Excel report, including its filters, joins, date logic, and business rules, and reproduce it accurately.

• Ability to gather requirements and business rules from report owners who know what they need but may not understand the underlying construction.

🏝️ Benefits

• Learning Opportunities: Certifications in AWS (we are AWS Partners), Databricks, and Snowflake. Access to AI learning paths to stay updated with the latest technologies. Study plans, courses, and additional certifications tailored to your role. Access to Udemy Business, offering thousands of courses to enhance your technical and soft skills. English lessons to support your professional communication.

• Travel opportunities to attend industry conferences and engage with clients.

• Mentoring and Development: Career development plans and mentorship programs designed to help shape your career path.

• Celebrations & Support: Special day rewards to commemorate birthdays, work anniversaries, and other personal milestones. Company-provided equipment.

• Flexible working options to help you achieve the right work-life balance.

• Other benefits may vary depending on your location in LATAM. For detailed information regarding the benefits applicable to your specific location, please consult with one of our recruiters.