𝗦𝗲𝗻𝗶𝗼𝗿 𝗦𝗼𝗳𝘁𝘄𝗮𝗿𝗲 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿, 𝗙𝗮𝗰𝘁𝗦𝗲𝘁Focused on sell-side data in Content Integration, specializing in data engineering within a team of 11.𝗞𝗲𝘆 𝗣𝗿𝗼𝗷𝗲𝗰𝘁𝘀 𝗮𝗻𝗱 𝗥𝗲𝘀𝗽𝗼𝗻𝘀𝗶𝗯𝗶𝗹𝗶𝘁𝗶𝗲𝘀:• 𝗦𝗲𝗹𝗹 𝗦𝗶𝗱𝗲 𝗘𝗧𝗟 𝗜𝗻𝗳𝗿𝗮𝘀𝘁𝗿𝘂𝗰𝘁𝘂𝗿𝗲: Developed and maintained Python and TSQL data pipelines for integrating data into an MSSQL data warehouse, ensuring consistency across various financial data models.• 𝗗𝗮𝘁𝗮 𝗣𝗶𝗽𝗲𝗹𝗶𝗻𝗲 𝗖𝗿𝗲𝗮𝘁𝗶𝗼𝗻: Built a Python pipeline for extracting, cleaning, and transforming data from diverse sources, integrating it for multiple consumer applications.• 𝗢𝗿𝗰𝗵𝗲𝘀𝘁𝗿𝗮𝘁𝗶𝗼𝗻 𝗮𝗻𝗱 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻: Utilized Prefect for batch processing and converted legacy ETL processes to Python, enhancing task orchestration with tools like Dremio and AWS.• 𝗣𝘂𝗯𝗹𝗶𝘀𝗵𝗶𝗻𝗴 𝗜𝗻𝗳𝗿𝗮𝘀𝘁𝗿𝘂𝗰𝘁𝘂𝗿𝗲: Designed a Python and TSQL infrastructure to ensure high availability and data integrity across disparate datasets, implementing a robust ETL design for rapid recovery from failures.• 𝗔𝗣𝗜 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁: Created a proof-of-concept GraphQL API in Python to standardize data exposure from various sources using SQLAlchemy and Pandas.• 𝗟𝗲𝗴𝗮𝗰𝘆 𝗠𝗶𝗴𝗿𝗮𝘁𝗶𝗼𝗻 𝗮𝗻𝗱 𝗥𝗲𝗳𝗮𝗰𝘁𝗼𝗿𝗶𝗻𝗴: Led the migration of ETL processes from MySQL to MSSQL, refactoring schema designs and converting legacy scripts from Ruby/Perl/Bash to Python.• 𝗗𝗮𝘁𝗮 𝗜𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻: Enhanced data models by integrating third-party data, coordinating with vendors for timely delivery and conducting thorough testing.• 𝗔𝗣𝗜 𝗗𝗮𝘁𝗮 𝗔𝗰𝗰𝗲𝘀𝘀: Expanded data offerings via APIs, optimizing queries for efficient access to complex datasets.• 𝗩𝗲𝗿𝘀𝗶𝗼𝗻 𝗖𝗼𝗻𝘁𝗿𝗼𝗹 𝗠𝗶𝗴𝗿𝗮𝘁𝗶𝗼𝗻: Transitioned the team from Perforce to GitHub, streamlining deployment processes and implementing CI/CD practices for rapid, low-risk code updates.