Senior Developer, SQL

Job Description

The Senior Developer, SQL will analyze and develop SQL for existing data structures and new applications. Responsibilities Analyze and develop queries, stored procedures, and functions for use by existing and new data sets. Responsible for code development in modern RDMS systems as well as unstructured data stores. Get familiar with existing business process and data structure. Learn code standards, development processes and tools. Gather and understand requirements and develop business modules using various data tools. Write complex queries to conduct research and implement complex business rules. Develop sequences of processes populating data into new database structure. Create required table structure for loading data and ingestion processes. Performance optimization and troubleshooting new code. Develop PowerShell script to schedule business jobs. Document technical processes and approach. Collaborate with team members and participate in design discussions. Knowledge and Experience 10+ years of experience and a degree in a technology field. Bachelors degree Strong experience with Data warehouse, T-SQL development supporting OLTP applications (complex queries, stored procedures, scripts, etc.). Experience with Postgres databases. Experience working with unstructured data and related tools. Good communication and problem-solving skills. Be able to understand requirements and communicate problems and solutions clearly. Experience working in agile development teams and utilizing SDLC tools such as Azure DevOps and Jira. Experience automating delivery of database changes using DevOps tools such as Azure DevOps and Jenkins. Experience with ETL processes utilizing SSIS. Experience with SSRS is desired. Experience with PowerShell scripting is desired. Familiar with data modeling concepts Basic knowledge of Mortgage domain. Strong verbal and written communication skills Schedule Shift timings: 3PM - 12:30AM