Job Description
At Softgic, we work with the best — with the builders, the ones who love what they do, and those who bring 100% attitude. That’s our #Cooltura. Join our purpose of making life easier with technology and become part of our team as a Business Intelligence (Looker).
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.Marketing Data Integration :
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.Dashboard & Report Development :
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.Preferred :
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.Requirements
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. Preferred : 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.