Lauren Mizner

Data Engineer i @Henderson Engineers

Lenexa, KS, US

Refactored transformation logic from Azure Data Factory pipelines into modular dbt models using SQL, T-SQL, CTEs, and macros, enhancing maintainability, scalability, and performance of data workflows• Developed time series project trend data marts using SQL and dbt - including performance by discipline, invoice metrics, and project health - to drive Power BI dashboards that support 100+ project managers in making data-driven decisions across the project lifecycle• Wrote complex SQL queries in Microsoft SQL Server and DBeaver to extract and structure data for analytics-ready datasets• Researched and developed a proof of concept for implementing row level security within dbt models and SQL server to provide secure and appropriate data access to engineers company-wide• Conducted in-depth research and analysis of cloud-based and open-source MLOps platforms, including Azure ML Studio and MLflow, to evaluate integration with the existing tech stack, enabling the data science team to build scalable ML services for software developers and enhance cross-functional operational efficiency• Leverage IfcOpenShell to extract and process BIM data from Revit models, enabling advanced analysis and insights into architectural engineering designs