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.
PowerBI Developer creating dashboards and visual reports for business intelligence insights. Collaborating on data warehousing and technical specifications to enhance BI systems.
Advisory Business Intelligence Analyst supporting quantitative and qualitative data analysis for DoD customer wargame projects. Collaborating with senior analysts to provide business strategy recommendations and insights.
Business Intelligence Developer at Landis+Gyr, managing PowerBI for energy optimization. Collaborating with stakeholders on data analytics and visualization projects.
Senior BI Developer providing strategic data analysis and insights for MVNO and MNO clients. Involves data pipeline development, machine learning, and customer - centric reporting.
Business Intelligence Analyst II at Perry Homes working with data to improve productivity. Responsible for reporting and developing processes to capture business operation information.
Senior Business Intel Analyst specializing in fraud detection solutions using advanced technical skills. Managing analysis and rule writing for effective decision - making within a cross - functional team setting.
Senior BI Analyst shaping reporting and insights at Global App Testing. Collaborating cross - functionally to support decision making with reliable data - driven insights.
Senior Business Intelligence Engineer at NextEra Energy developing scalable reporting solutions and automated dashboards for regulatory analysis and strategic decision - making.
Business Intelligence Developer at ICON plc designing and implementing business intelligence solutions for data - driven decision - making. Collaborating with stakeholders to enhance healthcare industry insights and reporting.