Software Developer

Berkadia•Midvale, UT

9d•Hybrid

About The Position

Berkadia Commercial Mortgage, LLC seeks a Software Developer 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.
3 years of experience using SQL server integration services (SSIS) including experience upgrading, enhancing and troubleshooting legacy systems as well as designing new functionality.
3 years of experience using NodeJS software coding language in cloud systems and on-premises SQL Servers.
3 years of experience using Event Sourcing and Command Query Responsibility Segregation (CQRS) patterns for designing software solutions.
3 years of experience implementing and enhancing Spark software-based pipelines written in Python.
3 years of experience using AirFlow to schedule and monitor software jobs on a variety of frequencies.
3 years of experience designing and deploying new DAGs (Directed Acyclic Graphs) and using AWS managed Airflow.

Responsibilities

Coordinate comprehensive software and data solutions through the full lifecycle including designing, coding, documenting, and testing.
Integrate various solutions with team members.
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.
Support advanced data processing patterns and legacy database processes.
Create Spark framework and work 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 packages and cloud systems using Spark software, AWS and NodeJS.
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.