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. - Orchestrated complex ETL workflows utilizing Python scripts and Oracle SQL Developer, enabling precise data extraction from a diverse data warehouse, followed by comprehensive data cleaning and loading into targeted databases, improving data integrity and reliability. - 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. - Systematized and cataloged intricate data models, data dictionaries, and technical specifications for data pipelines and databases, thus ensuring seamless information accessibility and comprehension across multidisciplinary teams, fostering collaborative efforts and project synergy. - 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. - Fostered collaborative relationships with team members and stakeholders, proactively identifying and implementing potential enhancements to the reporting processes which boosted efficiency and precision in data management. - Revitalized existing 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. - Constructed and optimized tables in Oracle SQL Developer to classify and display crucial data from the Oracle database for various departments, a move that escalated data efficiency and accessibility across the organization. Show less

Real Estate Agent

• Mar 2020 - Jun 2022