Title- Sr System Analyst
Location- Westlake Village , CA / Plano, TX - REMOTE
Type of Hire- CTH
Interview process :
L1 - Sonata hacker rank
L2 - Sonata technical interview
L3 - Client Virtual interview
Note :
- Client is looking Senior System analyst with strong Mortgage or BFSI clients exp.
- Candidate should be technically proficient in skills such as .NET, cloud(AWS, AZURE) .
- Strong exposure in PostgreSQL
- Bachelor's degree in computer science, Information Technology, Business Administration, or a related field, or equivalent work experience.
- 7+ years of relevant work experience as a Systems Analyst or Business Systems Analyst, with a proven track record of designing and implementing complex systems solutions.
- reverse engineering) is a significant plus. Experience with API specifications (REST, JSON) is also beneficial.
- Must be highly proficient in writing and executing complex SQL queries for data analysis, data mapping, and reporting. Strong understanding of relational database schemas and SQL management tools is essential.
- Significant design experience in Relational Databases, Online Systems, and Web-Based Applications.
- Must be highly proficient in Microsoft Excel, Word, and their G Suite (Google Workspace) equivalents.
- Ability to leverage AI tools for writing requirements, use cases, test cases, and design documentation. AI knowledge and usage desired
Must-Have Skills :
Strong proficiency in SQL Server, including scripting and complex query writing.Solid experience working in Agile environments (Scrum, Kanban).Proven ability to analyze data, design relational databases, and translate business needs into technical solutions.Excellent communication and collaboration skills with business and technical teamsProject management skills.Experience leveraging AI tools for documentation and process improvement is a plus.Foundational programming knowledge and scripting experience are beneficial.Desired Skills :
Experience with the .NET framework.Familiarity with PostgreSQL databases.Exposure to Snowflake and Tableau for data warehousing and reporting.Experience with AWS cloud services.Strong business knowledge within the Financial Services industry is essential for this role.Mortgage industry experience is highly preferred and will be a strong advantage.