Business Intelligence Specialist

Omnicom Global Solutions Colombia; Bogotá ciudad; Presencial; COP 60 000 000 - 110 000 000; Tempo integral

Resumo da oferta

Omnicom Global Solutions (OGS) seeks a Business Intelligence Specialist to transform complex datasets into actionable insights and to develop scalable reporting solutions for global teams. You will partner with Sales, Marketing, Finance, and Leadership to deliver analytics that drive decisions.

The role requires strong analytical thinking, technical expertise, and business acumen to support data-informed decision-making across the organization.

Qualificações

• 4-6 years of experience in BI, Data Analytics, Analytics Engineering, Reporting, or related fields.
• Advanced SQL skills.
• Strong experience with data modeling and ETL/ELT processes.
• Experience working with CRM data, particularly Salesforce.
• Hands-on experience with Power BI, Tableau, or Looker.
• Ability to gather business requirements and translate them into reporting solutions.
• Knowledge of SaaS metrics.
• Experience with data governance and data quality management.
• English proficiency at B2 level or above.

Responsabilidades

• Design, develop, and maintain BI dashboards and reporting solutions.
• Build and optimize data models to support business reporting needs.
• Develop and manage ETL/ELT processes to ensure data accuracy and availability.
• Partner with business stakeholders to translate requirements into analytical solutions.
• Analyze CRM and operational data to identify business opportunities and trends.
• Monitor key SaaS performance metrics and provide actionable insights.
• Ensure data quality, governance, and reporting best practices.
• Support ad hoc analysis and strategic initiatives across global teams.

Conhecimentos

Advanced SQL

Data modeling

ETL/ELT

Requirements gathering

SaaS metrics

English proficiency (B2)

Ferramentas

Power BI

Tableau

Looker

Salesforce

dbt

Snowflake

BigQuery

Redshift

Git

Descrição da oferta de emprego

Omnicom Global Solutions (OGS) is seeking a Business Intelligence Specialist to support global reporting and analytics initiatives. This role will be responsible for transforming complex datasets into actionable insights, developing scalable reporting solutions, and partnering with stakeholders across Sales, Marketing, Finance, and Leadership teams.

The ideal candidate combines strong analytical thinking, technical expertise, and business acumen to drive data-informed decision-making.

Responsibilities

• Design, develop, and maintain BI dashboards and reporting solutions.
• Build and optimize data models to support business reporting needs.
• Develop and manage ETL/ELT processes to ensure data accuracy and availability.
• Partner with business stakeholders to translate requirements into analytical solutions.
• Analyze CRM and operational data to identify business opportunities and trends.
• Monitor key SaaS performance metrics and provide actionable insights.
• Ensure data quality, governance, and reporting best practices.
• Support ad hoc analysis and strategic initiatives across global teams.

Required Qualifications

• 4-6 years of experience in Business Intelligence, Data Analytics, Analytics Engineering, Reporting, or related fields.
• Advanced SQL skills.
• Strong experience with data modeling and ETL/ELT processes.
• Experience working with CRM data, particularly Salesforce.
• Hands-on experience with Power BI, Tableau, or Looker.
• Ability to gather business requirements and translate them into reporting solutions.
• Knowledge of SaaS metrics.
• Experience with data governance and data quality management.
• English proficiency at B2 level or above.

Preferred Qualifications

• Experience with dbt.
• Experience with cloud data warehouses such as Snowflake, BigQuery, or Redshift.
• Python for automation, analytics, and data processing.
• Experience building churn prediction, risk, or customer health scoring models.
• Experience with Git and version control practices.