e
ellen_data_pro

Ellen w

@ellen_data_pro

Data Solutions Architect, Business Intelligence Developer, Data Engineer

United States
English
About me
I am a data-driven Data Solutions Architect and Analytics Engineer with over 14 years of experience in the Fortune 100 sector. I specialize in end-to-end data architecture, including Medallion Lakehouse structures, ETL pipelines, and Power BI design. I have a proven ability to translate complex business requirements into scalable technical solutions across platforms like Microsoft Fabric, Azure, and SQL Server.... Read more

Skills

e
ellen_data_pro
Ellen w
Offline • 
Average response time: 1 hour

See my services

Data Dashboards
I will provide data consulting, analysis and development services

Portfolio

Work experience

Microsoft

Data Architect | Business Intelligence Data Consultant (Contract)

Microsoft

Apr 2020 - Jan 2025 • 4 yrs 9 mos

• Planned and architected Fabric data framework with Medallion architecture for reporting needs. • Built semantic models from Fabric Lakehouse – SQL Analytics Endpoint. • Designed Power BI report and optimized data model’s schema. • Created T-SQL dataset from Lakehouse SQL Analytics Endpoint, and Kusto (KQL) data retrieval dataset for data analysis and reporting. • Evaluated business needs for reporting. • Identified and ensured report data’s accuracy, consistency and integrity. • Solved problems and delivered strategic technical solutions. • Enrich metadata for AI-driven data analysis reporting, and prepare data for AI to give users insightful, accurate answers. • Developed and maintained ETL data pipelines with Azure Data Factory for data integration, data transformation, and data consolidation.