Data Engineer II
The Opportunity
Berkadia 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 and release data applications in AWS using big data technologies. Assist development efforts across the organization. Understand and adhere to development standards and processes. Use the latest technology to develop ETL pipelines in the cloud to import, process and store data to be used by product teams. Support the legacy data systems that leverage the Microsoft SQL Server stack. Use SQL Language to interact with databases. Perform Process Troubleshooting to understand, identify, and resolve data issues. Perform data transformation for different tasks like data cleansing, aggregation, and formatting. Perform Data Modeling activities to store data in databases and files.
Requirements: Bachelor’s degree (or foreign equivalent) in Computer Science, Computer Engineering, or related and experience in the following: 5 years of experience using SQL Language to interact with databases. 5 years of experience Process Troubleshooting to understand, identify, and resolve data issues. 5 years of experience performing data transformation for different tasks like data cleansing, aggregation, and formatting. 1 year of experience performing Data Modeling activities to Store data in databases and files. Up to 5% national travel required. Remote work available at employer discretion. Apply at: https://berkadia.com/careers/ . Ref #1633
#LI-DNI
Berkadia, a joint venture of Berkshire Hathaway and Jefferies Financial Group, is a leader in the commercial real estate industry, offering a robust suite of services to our multifamily and commercial property clients. Powered by deep relationships and industry-changing technology, our people sell, finance, and service commercial real estate, providing support for the entire life cycle of our clients’ assets. Our unique ownership structure allows us to put the client’s interests first and creates a marketplace that delivers a superior experience.
Berkadia complies with the law regarding reasonable accommodations for disabled applicants. Applicants who require reasonable accommodations to participate in the interview process should contact Emma.Petersen@berkadia.com to arrange for such accommodations.
Berkadia is an Equal Opportunity employer and complies with all applicable Federal, State and local laws concerning discrimination in employment. No question in this Application is intended to elicit information in violation of any such law, nor will any information obtained in response to any question be used in violation of any such law.
By applying to this job opportunity you are acknowledging Berkadia’s Application Policy and Berkadia’s Privacy Policy. Applicants have rights under Federal Employment Laws. Please click the following links for more information: EEOC, Employee Rights under the FMLA, EPPA.