Berkadia Commercial Mortgage, LLC seeks a Software Developer (Midvale, UT) to coordinate comprehensive software and data solutions through the full lifecycle including designing, coding, documenting, and testing. This includes both new development projects as well as maintenance activities. Work with team members to integrate various solutions. Analyze user needs and software requirements to determine feasibility of design within time and cost constraints. 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 and support the legacy database processes. Create our Spark framework and work closely with Platform Architects to go from an Event Source data model, into Spark software, and out to SQL. Confer with systems analysts, engineers, programmers and others to design systems and to obtain information on project limitations and capabilities, performance requirements and interfaces. Deliver high quality, secure, tested data solutions on both cloud and prem systems. Work on both on-premises SQL servers running SSIS (SQL server integration services) packages and cloud systems using Spark software, AWS (amazon web services) and NodeJS among other technologies. Monitor functioning of equipment to ensure system operates in conformance with specifications. Support the day-to-day data operations of the company including bug fixes and data migrations. Prepare reports or correspondence concerning project specifications, activities, or status.
REQUIREMENTS: Bachelor's degree or foreign equivalent in Information Systems or closely related field. Must have (3) years of experience in the following:
- Using SQL server integration services (SSIS) including experience upgrading, enhancing and troubleshooting legacy systems as well as designing new functionality;
- Using NodeJS software coding language in cloud systems and on- premises SQL Servers;
- Using Event Sourcing and Command Query Responsibility Segregation (CQRS) patterns for designing software solutions;
- Implementing and enhancing Spark software-based pipelines written in Python;
- Using AirFlow to schedule and monitor software jobs on a variety of frequencies;
- Designing and deploying new DAGs (Directed Acyclic Graphs) and using AWS managed Airflow.
Remote work available up to 4 days per week at employer discretion. Must live within commuting distance of Midvale, UT.
#LI-DNI
