Zev Chaiton

• Leveraged DBT to build a comprehensive data model for analysing the used car market, enabling data-driven insights and decision-making. Market insights are presented to the business and published externally on a monthly basis. Software/tools used: Snowflake (SQL) and DBT.
• Collaborate closely with stakeholders to understand their specific data requirements, translating their needs into actionable data models and reports that facilitate informed decision-making and drive business success. Notably, I crafted a data model and generated a widely utilised report, tracking stock movement and enhancing operational planning within the organization. Software/tools used: Snowflake (SQL), Dataiku and Tableau.
• Designed and implemented data pipelines in Python to seamlessly ingest and cleanse data, ensuring data quality and integrity, and enabling robust analytics and reporting capabilities. Software/tools used: Python and Snowflake (SQL).
• Successfully automated diverse processes, including data validation and cleansing as well as daily report generation, enhancing efficiency through the implementation of automated workflows, resulting in time and resource savings. Software/tools used: Python and Excel (VBA).
• Developed a revenue driving python script that allows for bulk valuations of vehicles (Python and Excel) and implemented an efficient process that empowered staff to accurately identify vehicles, resulting in substantial cost savings and risk mitigation by preventing misidentification, while also delivering significant time-saving benefits for the team. (Dataiku and Excel)

This was a contract role. My responsibility was data accuracy and validation.

• Developed a sophisticated Excel spreadsheet that served as a validation tool, proactively alerting the team to potential data issues, enhancing data quality control, and ensuring data integrity. Software/tools used : Excel

• Spearheaded the systemization of the lead management process, including lead follow up messages, scheduling a viewing and automatic quote generation. This created a structured and automated framework that facilitated the seamless gathering and analysis of data, optimising our ability to harness valuable insights for strategic decision-making and performance improvement. Software/tools used: Power Automate, Excel and Power BI
• Established reporting for tracking vacancies and maintenance jobs, enabling real-time visibility into property management. Software/tools used: Excel and Power BI