Compensation:
USD 1K - 2K/month.
Location:
Remote (for Colombia residents).
Mission of Softgic:
In Softgic S.A.S. we work for the digital and cognitive transformation of our clients, aware that quality is an essential factor for us, we incorporate the following principles into our policy:
- Deliver quality products and services.
- Achieve the satisfaction of our internal and external clients.
- Encourage in our team the importance of training to grow professionally and personally through development plans.
- Comply with the applicable legal and regulatory requirements.
- Promote continuous improvement of the quality management system.
What makes you a strong candidate:
- You have 3+ years of experience in Looker Studio.
- You are proficient in ETL (Extract, transform, load), dashboard development. SQL, and data modeling.
- English - Native or fully fluent.
- Spanish - Conversacional.
Responsibilities and more:
ERP Data Integration (Odoo):
- Design and maintain ETL processes to extract, transform, and load Odoo data into a reporting-friendly structure.
- Build dashboards for sales, inventory, purchasing, and financial performance.
- Ensure integrity, consistency, and accuracy of ERP reports.
- Connect and integrate data from Google Ads, Meta Ads, and other ad platforms into Looker.
- Develop marketing performance dashboards, including ROI, CAC, ROAS, and attribution reports.
- Automate reporting pipelines for real-time and scheduled updates.
- Translate business needs into scalable Looker dashboards and data models.
- Deliver clear, actionable reporting for stakeholders in operations, sales, and marketing.
- Provide training and documentation for business users to self-serve reporting in Looker.
Requisitos
- 3+ years of experience with Looker (LookML, dashboard development, data modeling).
- Hands-on experience integrating ERP systems (Odoo strongly preferred) into BI/reporting tools.
- Proven track record of connecting marketing platforms (Google Ads, Meta Ads, etc.) to BI solutions.
- Strong SQL skills and familiarity with relational data modeling.
- Experience with ETL/ELT tools and APIs for data integration.
- Analytical mindset and ability to translate business questions into reporting solutions.
- Experience with Python or dbt for data transformation.
- Understanding of finance, sales, and digital marketing metrics.
- Ability to work in a fast-paced environment with multiple stakeholders.
Ventajas
- We're certified as a Great Place to Work.
- Opportunities for advancement and growth.
- Paid time off.
- Formal education and certifications support.
- Benefits with partner companies.
- Referral program.
- Flexible working hours.