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 building enterprise reporting and self-service BI for outdoor retail and home goods brands, focused on Power BI semantic models, Snowflake data marts and KPI governance.
- Hands-on with BI tools (Power BI, Tableau), warehouses (Snowflake, SQL Server), ETL (dbt, Azure Data Factory) and languages (SQL, DAX).
- Deep experience in star schema design, DAX measure libraries, report performance tuning and row-level security, using Kimball dimensional modeling and a certified dataset process to deliver numbers Finance and Merchandising sign off on.
- Works closely with Finance, Merchandising, Store Operations and Data Engineering in a central BI team that serves the whole co-op, from requirements workshops and mockup reviews to KPI sign-off with Finance.
- Coaches analysts on DAX and data modeling, runs the monthly semantic model review, and wrote the team’s Power BI design standards.
Technical Skills
- BI & Reporting Tools:
- Power BI, Tableau, Power BI Report Builder, SSRS, Excel
- SQL & Scripting:
- SQL, T-SQL, Snowflake SQL, Python, Power Query M
- Data Warehouses:
- Snowflake, SQL Server, Azure Synapse Analytics, Microsoft Fabric
- Modeling & Semantic Layer:
- DAX, Star schema, Kimball methodology, Slowly changing dimensions, Tabular models, Calculation groups
- ETL & Orchestration:
- dbt, Azure Data Factory, Fivetran, SSIS, Power Query
- Governance & Security:
- Row-level security, dbt tests, Certified datasets, Microsoft Purview, Sensitivity labels
- BI Dev Tools & Workflow:
- Tabular Editor, DAX Studio, Git, Azure DevOps, Power BI deployment pipelines, Jira
Education
Work Experience
- Built the merchandising scorecard in Power BI for 210 buyers and planners, with drill-through from department to SKU to store and a weekly flash report in Power BI Report Builder, retiring 14 Excel packs emailed every Monday.
- Wrote the Snowflake SQL views behind the store sales mart, using window functions for comparable-store sales and CTEs for promotion lift by region, cutting the nightly mart build from 52 minutes to 9 minutes.
- Designed a star schema for sales, inventory and returns with conformed product, store and calendar dimensions and Type 2 history on product hierarchy changes, merging 6 team-built datasets into one model that 38 reports now share.
- Built a library of 142 certified DAX measures with calculation groups for time intelligence, and got Finance and Merchandising to agree on one definition of gross margin, closing a 3.2-point gap between their reports.
- Moved the reporting loads from SSIS packages to dbt models run by Azure Data Factory, with Fivetran syncing POS and e-commerce data, raising on-time morning refreshes from 88% to 99.4% of business days.
- Tuned the sales model behind the scorecard with incremental refresh, aggregation tables and DAX fixes found in DAX Studio traces, cutting median page load from 11 seconds to 2.4 seconds through the holiday peak.
- Set up row-level security by region and store on Entra ID groups, dbt tests on every source table and a daily check of warehouse sales against the POS ledger, cutting finance reconciliation tickets by 71% over 4 quarters.
- Ran requirements workshops with Figma mockups before each build, then trained 380 store and merchandising users in weekly Power BI office hours on certified datasets, cutting one-off report requests by 44%.
- Built Tableau dashboards on orders, returns and delivery times for the e-commerce teams, used weekly by 95 brand and site managers, replacing an emailed SSRS report pack.
- Rewrote the SSIS packages loading order data into SQL Server, with set-based T-SQL and staged loads, cutting the nightly load from 4 hours to 75 minutes.
- Wrote the first shared KPI glossary with Finance for demand, return rate and average order value, adopted across 27 dashboards for the brands’ weekly business reviews.