The OpportunityBerkadia Commercial Mortgage, LLC, seeks a Data Engineer II in Ambler, PA to build data pipeline to merge tested design of data warehousing and the latest big data technologies. Design and build data projects while securing core data elements. Develop ETL pipelines, in the cloud, to import, process and store data to be used by product teams. Support advanced data processing patterns used and deployed in this framework. Support the legacy data warehouse systems that leverage Microsoft SQL Server stack (SQL, SSIS, SSAS, SSRS). Create and modify data warehouse jobs using Kimball Data Warehouse methodology. Design and build data projects while securing core data elements. Research new technology and share knowledge with the team; implement