Challenge
One of the key components within the current file processing flow to generate and transmit payroll, investment, general ledger tax and other types of files to banks, 401k providers and other external entities is no longer going to be supported in December 2020.
Solution
With a move to a Modern Data Architecture, utilizing the Snowflake platform, BUILT provided a solution where ingested files can be automatically piped into the Data Lake, cataloged and tagged.
Results
Utilizing Azure Data Factory to ingest these files into an Azure hosted Snowflake Data Lake, BUILT provided data engineering consultants, Python and .NET Core consultants and a UI React consultant to develop an end to end Minimal Viable Product (MVP) solution to accomplish the following goals for our client:
•Retire Legacy Platform
•Eliminate reliance on Manual Intervention
•Cut SLAs from Weeks to Hours
•Allow for scalability to create more 3rd Party Integrations to drive revenues and speed to market
Photo by Olia Danilevich on Pexels
