Business Intelligence Consultant delivering analytical capabilities and visual analytics for global specialty insurance. Collaborating with business partners to enhance data - driven decision - making.
About the role
- Senior Business Intelligence Analyst ensuring data accuracy and consistency for marketing funnels at Sioux digital. Leading dashboard creation and team mentorship in a hybrid work model.
Responsibilities
- Ensure accuracy, consistency and clarity of marketing and business funnel data.
- Lead the creation/evolution of metrics and dashboards (Power BI and Looker Studio).
- Structure and validate data in BigQuery (and relational databases).
- Drive analyses that lead to action and mentor the team (mid and junior levels).
Requirements
- Senior BI experience (agency or product/marketing data-driven), with a track record of ownership of the numbers and reducing reporting errors.
- Strong analytical profile and structured logical reasoning: decompose problems, define inclusion/exclusion criteria, build rules (CASE WHEN), validate edge cases, compare database vs platform and justify each metric.
- Marketing/business metrics: CPC, CPA, ROAS, LTV, funnel/cohort, pacing/projections; critical review and reconciliation across sources.
- Advanced Power BI (tabular modeling, DAX, Power Query/M, RLS, performance optimization) and advanced Looker Studio (parameters, blends, optimizations).
- Strong BigQuery and SQL for BI: CTEs, joins, aggregations, basic window functions; creating views/tables; understanding of partitioning/clustering and efficient consumption.
- GA4 and GTM: plan measurement (events, parameters, UTMs), specify dataLayer for developers, validate (Tag Assistant/DebugView) and ensure alignment between tracking and dashboard metrics.
- Quality and governance: metrics glossary, single source of truth, automated checks (integrity/reconciliation), pre-publication audit, access control (RLS/IAM) and basic versioning.
- Practical automation: schedule light extractions/transformations (scheduled SQL, Apps Script or similar), handle timezones/currencies/late data and document the flow.
- Advanced Excel/Google Sheets (validations, functions, etc.).
- Clear, didactic communication; ability to mentor and raise the team’s level.
- Nice-to-haves: ELT with Dataform/dbt (tests: unique/not null/referential), Git and standardized documentation.
- Python (pandas) in Google Colab/Jupyter for validations, POCs and light automations.
- Google Apps Script for Workspace integrations/routines (alerts, Sheets, APIs).
- Media/CRM integration (Meta/Google/TikTok/LinkedIn × RD Station/HubSpot): join keys, daily granularity, reconciliation of currencies/timezones, deduplication and handling delays.
- FinOps in BigQuery (column pruning, correct partitioning, pre-aggregations, BI Engine) and cost/performance monitoring.
- Power BI Service (Deployment Pipelines, Tabular Editor/XMLA, governance in the Service).
- Server-side tagging, Consent Mode and MMPs (AppsFlyer/Adjust).
- Applied statistics (A/B testing, hypothesis testing) and basics of attribution models (MTA/MMM).
- English for reading and meetings when necessary.
Benefits
- Flexible benefits: choose how to allocate the benefit amount among meal voucher (VR), food allowance (VA), fuel voucher, home-office allowance, etc.;
- Health and dental insurance: it’s important to take care of your health;
- Life insurance: your safety matters to us too;
- Annual bonus: to reward your dedication throughout the year;
- Paid annual leave: because you deserve time to recharge;
- Support for courses, certifications and events: we care about your development;
- Birthday day off and a small gift;
- Alura e-learning: employees have access to a learning path to take courses for free;
- Referral program: help us find talent and earn a bonus;
- Work in a dynamic, collaborative environment with lots of learning, recognition and flexible hours;
- Hybrid work model (2 days in-office per week), based in the Berrini area.
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Business Intelligence Analyst providing business intelligence support for MercyCare’s Actuarial and Underwriting department. Handling data collection, reconciliation, reporting, and analysis for informed decision - making.
Entry - Level Power BI Analyst at Mitsubishi Power supporting development and maintenance of Power BI reports. Collaborating with teams to ensure reporting consistency and data quality standards.
Senior Business Intelligence Analyst at Clio creating data solutions for better decision - making. Collaborating with stakeholders and enhancing business intelligence in a hybrid work environment.
SR BI ANALYST in an international insurance company analyzing and visualizing data. Collaborating with Finance and Operations areas to meet information needs.
Senior Specialized BI Analyst creating advanced business intelligence insights for Memorial Hermann's analytics team. Responsible for supporting critical business decisions across various organizational domains.
Business Intelligence Developer working on reporting and dashboard solutions for 32BJ Benefit Funds. Collaborating with senior developers to advance business insights through data analytics.
Intern supporting Business Intelligence Developer tasks while collaborating with professionals at Uline's corporate headquarters. Focusing on data integrations and analytics for business solutions.
BI Developer reviewing data and metrics on insider and cyber risks for SMBC at a hybrid workplace. Building visualizations and reports to foster security within the organization.
Senior Manager driving business intelligence initiatives for Snap’s Small & Mid - sized Clients business. Leading analytics team to transform insights into data - driven actions across Go - To - Market and Sales strategies.