Job Description Job Purpose Analyzing and develop SQL for existing data structure and new applications. Responsibilities Responsible for code development in SQL Server. 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 T-SQL or SSIS. 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 an approach. Collaborate with team members and participate in design discussions. Knowledge and Experience Strong experience with Data warehouse, SQL Server T-SQL development supporting OLTP applications (complex queries, stored procedures, scripts, etc.). Good communication and problem-solving skills. Be able to understand requirements and communicate problems and solutions clearly. 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. 10 to 14 year’s experience and any Degree Schedule This role offers work from home flexibility of one day per week.