Yara Mansour Senior BI Developer
Seattle, WA • yara.mansour@gmail.com • +1 206-555-0163
Profile Summary
- Senior BI Developer with 7 years of experience delivering enterprise BI environments across outdoor retail co-op, premium home goods, and SaaS commerce, specializing in Power BI dashboard development, Snowflake dimensional modeling, and self-service BI governance.
- Solid technical background across BI platforms (Power BI, Tableau), data warehouses (Snowflake), ETL/ELT pipelines (dbt, Fivetran), semantic layers (DAX), and languages (SQL, Python) with strong fundamentals in dimensional modeling, governed semantic layers, and accessible visualization design.
- Deep expertise in star-schema dimensional modeling, single source of metric truth, dashboard performance tuning, and governed self-service analytics, leveraging methodologies such as Kimball-style dimensional design and data-product certification workflows to drive trusted, fast, and self-service-ready business intelligence.
- Engaged collaborator working cross-functionally with Finance, Merchandising, Marketing, and Data Engineering teams in data-product-as-service environments, contributing to requirements workshops, metric-review boards, and post-launch dashboard retrospectives with a stakeholder-first, ownership-first mindset.
- Emerging leader who shares technical excellence and fosters a culture of metric-trust obsession and documentation discipline through model reviews and BI office hours, while leading BI guild and metric-review sessions and authoring widely adopted dimensional-model and dashboard-design templates.
Technical Skills
- BI Platforms:
- Power BI (Service, Premium, Paginated Reports), Tableau, Looker, Qlik Sense, MicroStrategy, ThoughtSpot, SAP BusinessObjects
- Data Warehouses & OLTP:
- Snowflake, BigQuery, Redshift, Synapse, Databricks SQL Warehouse, SQL Server, Oracle, Postgres
- ETL / ELT:
- dbt, Azure Data Factory, SSIS, Informatica, Talend, Fivetran, Matillion, Power Query / M
- Data Modeling:
- Star & snowflake schemas, slowly-changing dimensions, Kimball methodology, tabular models, OLAP cubes
- Semantic Layer & Metrics:
- DAX, LookML, Tableau calculated fields, dbt metrics, certified-dataset governance, version-controlled metrics
- Visualization & UX:
- Chart-type selection, accessible color and contrast, narrative dashboard flow, mobile and tablet layouts, WCAG-aware design
- Governance, Quality & Security:
- Row-level security, workspace and dataset access controls, GDPR / HIPAA / SOX awareness, reconciliation tests, certified datasets
- Languages & Scripting:
- SQL (advanced window functions, CTEs), DAX, Python (pandas, basic ETL), M / Power Query, Bash, Git
Education
Work Experience
- Owned enterprise BI delivery for the Retail and Merchandising business supporting 2,400+ business users, leading requirements gathering and end-to-end delivery across executive merchandising scorecards, store-operations reporting, and finance and inventory analytics, delivering 180+ certified reports and dashboards.
- Designed the dimensional BI model on Snowflake with star schemas with conformed dimensions, slowly-changing dimensions (Type 2), and Power BI tabular models with calculation groups, maintaining 9 enterprise tabular models and cutting median query response from 14 seconds to 2.6 seconds.
- Built BI-ready data pipelines using dbt and Fivetran, with dbt models with tested grains, Fivetran SaaS connectors, and Azure Data Factory orchestration, maintaining 140+ dbt models and delivering 15-minute refresh on the executive scorecard.
- Designed executive and operational dashboards in Power BI and Tableau, including executive scorecards with drill-through detail, store-ops daily flash reports, and paginated reports for store leadership, shipping 48 production dashboards with 2,400 weekly active business users.
- Authored the team's warehouse query patterns in SQL including window functions and CTEs across fact tables, incremental aggregate tables, and query hints and clustering keys for Snowflake, powering 180,000 weekly query executions across the BI fleet.
- Drove the dashboard performance program using incremental refresh and dataset partitioning, query folding and aggregated views, and Power BI Premium capacity tuning, cutting median dashboard load from 12 seconds to 2.1 seconds.
- Ran the data-quality and governance program with dbt tests and source-system reconciliation, row-level security on store data, and certified-dataset workflow, achieving 92% reduction in finance reconciliation tickets across 4 quarters.
- Stood up the enterprise metric catalog on DAX with DAX-based shared measures, version-controlled metric definitions, and quarterly metric-review board, curating 220 certified metrics across 8 business domains.
- Authored the team's dashboard design system including chart-type selection guide for analysts, color and contrast standards aligned to WCAG, and narrative flow templates for executive decks, lifting time-on-page lifted from 1.2 to 3.8 minutes on the merchandising dashboards.
- Built the self-service BI program including weekly Power BI office hours, DAX and modeling workshops, and certified-dataset playbook, training 380 analysts and business power users and shipping 46 certified datasets.
- Worked closely with Finance, Merchandising, Marketing, and Data Engineering teams to coordinate quarterly metric-review boards, data-product roadmap planning, and audit-readiness reviews, authoring 11 BI standards and runbooks that shaped the team's standard playbook and mentoring 5 junior BI analysts and developers through their first dashboard launches.