Data Engineer

• Jan 2023 - Present

- Designed and implemented dynamic data pipelines in Apache Airflow, facilitating automated weekly and monthly reporting that simplified workflows and enhanced the precision of business insights. - Integrated automated testing scripts in Python, which meticulously validated data quality and accuracy during ETL processes, thereby minimizing errors and guaranteeing reliable data analysis for critical business functions. - Collaborated with the actuary to leverage machine learning, streamlining the automation of rate adjustments with batch pipelines and enhancing the precision of insurance rate computations. - Wrote complex SQL scripts to address ad-hoc requests, meeting immediate data needs and ensuring the timely delivery of business insights and regulatory requests. - Constructed and optimized tables in Oracle SQL Developer to classify and display crucial data from the Oracle database for various departments, increasing data efficiency and accessibility across the organization. - Cataloged intricate data models, data dictionaries, and technical specifications for data pipelines and databases, ensuring seamless information accessibility across multi-disciplinary teams. - Developed interactive data dashboards using Power BI, which streamlined the communication of vital insights to stakeholders, aiding in informed decision-making and enhancing operational efficiency. - Fostered collaborative relationships with team members and stakeholders, proactively identifying and implementing potential enhancements to reporting processes and precision in data analytics. - Revitalized letter templates by crafting SQL statements to link fields with pertinent data sources, facilitating the accurate and timely dispatch of personalized letters to uninsured motorists. Show less

Real Estate Agent

• Mar 2020 - Jun 2022