Lilian Kobrossy
Senior Business Intelligence & Data Governance Analyst
Hire this person
Send a job offer directly to this candidate
About
Senior Business Intelligence & Data Governance Analyst with 7+ years of experience designing scalable Power BI solutions, executive dashboards, and reporting that translate complex financial and operational data into fact-based findings and actionable recommendations. Advanced expertise in SQL, DAX, Power Query, data modeling, ETL, data profiling, and KPI development across enterprise ERP and data warehouse environments. Proven success partnering with executives, business users, and data engineering to define data quality rules, document metadata and lineage, optimize BI performance, and apply AI-assisted analysis to improve delivery and decision-making.
Experience
Senior Business Intelligence Data Analyst - Azuria
(2025-01)
Design and deliver scalable Power BI dashboards, semantic models, KPI frameworks, and internal reporting for Finance, Operations, Procurement, Inventory, Supply Chain, and executive leadership.
- Develop advanced SQL queries and ETL/Power Query transformations integrating JDE, EPM, SharePoint, and SQL Server data; optimize models and reporting layers for performance and reuse.
- Translate core business processes and strategy into reporting requirements, metric definitions, and executive-ready insights with fact-based findings and recommended next steps.
- Profile and audit datasets; define and monitor data quality rules for completeness, accuracy, consistency, and timeliness; reconcile source-to-report results and partner with data engineering to remediate root causes.
- Create and maintain data dictionaries, table and column descriptions, glossary terms, KPI logic, source mappings, and lineage documentation to strengthen knowledge sharing, discoverability, and AI-ready metadata.
- Trace lineage from Power BI reports and semantic models through ERP and warehouse source tables, improving transparency, data trust, and support for enterprise metadata cataloging.
- Analyze testing and user-acceptance results to confirm solutions meet business needs; recommend BI standards, validation procedures, documentation practices, and reporting controls.
- Apply structured, hypothesis-driven analysis and AI-assisted SQL/documentation workflows to explore large datasets, identify patterns, relationships, anomalies, and trends, and accelerate validated BI delivery.
Senior Business Intelligence Data Analyst - Solmax
(2023-01 - 2025-12)
Designed enterprise Power BI dashboards, scalable data models, and reporting architectures integrating SAP, AS400, Dynamics F&O, and SQL data across multi-site manufacturing operations.
- Built SQL-based transformations and automated reporting workflows supporting Procurement, Supply Chain, Inventory, SIOP, Finance, and executive reporting.
- Explored high-volume operational and transactional data to uncover trends, anomalies, meaningful relationships, demand signals, supplier performance issues, and cost-saving opportunities.
- Established profiling, reconciliation, and validation checks across source systems and reporting layers; collaborated with technical teams to resolve data quality and integration issues.
- Partnered with business leaders to understand operational workflows, define KPIs, and convert analytical findings into clear presentations, dashboards, and recommendations.
- Documented KPI definitions, data mappings, transformation logic, and source-to-report lineage to improve reporting consistency, governance, and long-term maintainability.
- Supported post-acquisition data integration by validating business processes, harmonizing metric definitions, and testing reporting outputs across newly acquired business units.
- Applied statistical and AI/ML-assisted trend, anomaly, and predictive analysis to support demand forecasting, inventory optimization, and operational decision-making.
Finance BI Analyst - Rockwell Automation
(2021-01 - 2023-12)
Developed Power BI dashboards, SQL reporting datasets, and executive presentations supporting budgeting, forecasting, cost management, and operational performance.
- Created and optimized SQL queries and ETL processes across financial and operational systems, delivering scalable and decision-ready reporting data.
- Defined QA and validation procedures for financial dashboards, tested calculations and reporting outputs, and reconciled results to authoritative sources.
- Conducted variance, trend, and root-cause analysis to identify performance drivers, risks, and opportunities and present fact-based recommendations to senior leadership.
- Collaborated with Finance, Operations, IT, and BI teams to standardize KPIs, reporting structures, and analytics practices across business units.
Business Data Analyst - Collabera
(2020-01 - 2021-12)
- Delivered customer-facing performance analytics and compliance reporting using validated financial, revenue, and operational datasets.
- Performed data quality audits, reconciliation, profiling, and validation testing in regulated environments and documented findings for stakeholders.
Business Analyst - Alvarez & Marsal Disputes and Investigations, LLC
(2019-01 - 2020-12)
- Analyzed large operational and compliance datasets to identify trends, workflow bottlenecks, anomalies, and opportunities for process improvement.
- Built KPI reporting and communicated analytical findings, documentation, and project status to technical and non-technical client stakeholders.
Education
Master of Business Administration - University of South Florida (2019)
Bachelor of Science - Finance - University of South Florida (2017)
