Business Intelligence and Automation Engineer
At a glance
Mid-level Data Analysis & BI role at Mmc. Bogota · full-time.
Pay not stated Data Analysis & BI salary
dataroles summary, based on the employer's posting.
What you'll do
- Build and maintain dashboards for commercial performance, new business, sales status and commission payments
- Shape the data architecture through semantic models, ETL workflows and row-level access controls
- Automate finance reporting and executive KPI reports, and maintain the consolidated local data warehouse
- Provide specialist technical support for CRM and business intelligence systems
What you bring
- At least ten years in business intelligence, data analytics or data engineering
- You have spent at least two years in each of your two most recent roles
- You bring advanced Power BI skills, including semantic modeling, DAX, Power Query and row-level security, plus strong SQL and advanced Excel
- You have handled sensitive, business-critical processes in insurance, brokerage or financial services
- You hold a degree in systems, engineering, business administration or data science, and have intermediate-to-advanced English
Who this fits
This role suits a senior BI or data engineering professional with deep Power BI and SQL experience. It is based in Bogotá and follows a hybrid schedule, with at least three days each week in the local office or at client sites.
From the employer
Company:
MarshDescription:
Buscamos Business Intelligence and Automation Engineer Senior para gestionar arquitectura analítica, dashboards críticos de comisiones y reportería ejecutiva en nuestro negocio de Riesgo en Marsh. Rol estratégico que requiere expertise avanzada en Power BI, SQL y automatización de procesos de datos sensibles. Este rol requiere expertise senior en BI/Data Engineering
Responsabilidades:
- Diseñar y mantener dashboards críticos de Control de Gestión Comercial, Nuevos Negocios, Semáforo Comercial y liquidación de comisiones
- Gestionar arquitectura de datos: modelado semántico, ETL, RLS
- Desarrollar y automatizar reportería de Finanzas y KPIs ejecutivos
- Administrar Datawarehouse local consolidado
- Proporcionar soporte técnico especializado en CRM y sistemas de BI
REQUISITOS (MUST-HAVE)
Experiencia:
- 10+ años comprobables en Business Intelligence, Data Analytics o Data Engineering
- Mínimo 2 años en CADA uno de los últimos 2 roles anteriores
- Experiencia en procesos críticos y sensibles
- Experiencia en seguros, brokers o sectores financiero/asegurador
Stack Técnico (Crítico):
- Power BI AVANZADO: Modelado de datos semánticos, DAX, Power Query, RLS
- SQL sólido: Queries complejas, stored procedures, ETL
- DAX comprobable en CV
- RLS (Row-Level Security) comprobable en CV
- Excel avanzado
Formación & Idioma:
- Profesional en Sistemas, Ingeniería, Administración o Data Science
- Inglés intermedio-avanzado
DESEABLE (DIFERENCIALES)
- Agentes de IA o Power Automate avanzado
- BigQuery, Snowflake o data warehouses cloud
- Python/R para BI
- Experiencia con MPOWER, Inbroker u otros CRM comerciales
- Exposición a comité de dirección o reportería ejecutiva