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 field. 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.
#LI-DNI
Berkadia, as an equal opportunity employer, celebrates our employees’ unique differences, which we believe drives personal and company-wide innovation and creates a people-first culture where your career can take the long view. To achieve these goals, we are committed to the full inclusion of all qualified individuals, without regard to race, religion, age, color, national origin, gender, sexual orientation, gender identity or expression, marital status, domestic partner status, military and veteran status, disability, pregnancy, parental status, genetic information, political affiliation, or any other status protected by federal, state and local laws.
In keeping with our commitment, Berkadia takes the necessary steps to provide a workplace free from harassment and discrimination, as well as access and reasonable accommodations for individuals with disabilities. If you require reasonable accommodation to take part in the interview process, please contact talentacquisition@berkadia.com.
You have rights under Federal and State employment laws. 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. If you apply for this role, you are acknowledging Berkadia’s Application Policy and Berkadia’s Privacy Policy. Please click the following links for more information about: EEOC, Employee Rights under the FMLA, EPPA.