Sr. System Analyst

Sonata Software Overview

Sonata is a global technology company specializing in platform-based digital transformation, supporting businesses to become connected, open, intelligent and scalable. Sonata s Platformation methodology brings together industry expertise, platform technology excellence, design innovation and strategic engagement models to deliver sustained value to customers. A trusted partner of world leaders in the retail, manufacturing, distribution, travel, services and software industries, Sonata s software portfolio includes the Brick & Click Retail Platform , Modern Distribution Platform , Rezopia Digital Travel Platform , Kartopia E-commerce Platform , Halosys enterprise development automation Platform , CTRM Commodity Trading and Risk Management Platform and KODO - AI Powered Customer Experience (CX) Platform. Sonata s Platformation approach ensures services built on Microsoft Dynamics 365, Microsoft Azure, AWS, Cloud Engineering and Managed Services deliver on the Platformation promise. As world leaders in digital technologies including IoT, Artificial Intelligence, Machine Learning, Robotic Process Automation, Chatbots, Block Chain and Cyber Security, Sonata s people and systems are nurtured to deliver on our commitment to excellence in business technology solutions.

Title- Sr. System Analyst

Location- Westlake Village, CA

As a Senior Systems Analyst, you will be responsible for planning, designing, and implementing major information systems. You will serve as a key liaison between business stakeholders and technical teams, translating complex business requirements into actionable technical specifications. Your day-to-day responsibilities will include:

1. Requirements Elicitation & Analysis: Collaborating extensively with business stakeholders to thoroughly understand their needs, processes, and challenges. You will then translate these into clear, comprehensive technical specifications for application and system changes.
2. System Design: Designing user interfaces, including data entry and query screen layouts, report layouts, and file structures, utilizing appropriate hardware, software, and system utility tools. This includes significant design experience in Relational Databases, Online Systems, and Web-Based Applications.
3. Documentation: Writing and revising program and system specifications, creating detailed directions for development and modifications of program code. You will also develop comprehensive business and technical documentation, including functional specifications, system design documents, and test plans.
4. Project Management & Coordination: Planning, monitoring, and controlling projects to effectively utilize time and programming resources. This includes leading and facilitating project-related activities, ensuring alignment with project timelines and deliverables.
5. Technical Problem Solving: Performing a variety of complex technical tasks, such as designing, documenting, and programming logic, and troubleshooting system issues.
6. Data Analysis & SQL: Creating and executing complex SQL queries for data analysis, mapping, and reporting to support business decisions and project insights.
7. Testing & Quality Assurance: Collaborating with QA teams to develop and execute test plans, ensuring systems meet functional and performance requirements and adhere to quality standards.
8. Collaboration & Communication: Acting as a subject matter expert, fostering strong relationships and effective communication with various internal business units, technical teams, and external vendors.
9. Continuous Improvement: Researching and evaluating new technologies and best practices, identifying opportunities for automation and process optimization to enhance efficiency and productivity.
10. Adherence to Culture & Values: Demonstrating behaviors aligned with PennyMac's desired organizational culture and values.

1. Bachelor s degree in Computer Science, Information Technology, Business Administration, or a related field, or equivalent work experience.
2. 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.
3. Demonstrated strong business knowledge, particularly within the Financial Services industry. Mortgage industry experience is highly preferred.
4. Proven ability to plan, monitor, and control projects, managing timelines, milestones, and deliverables. Experience with Agile methodologies (Scrum, Kanban) is highly valued.
5. Excellent verbal and written communication, interpersonal, and presentation skills, with the ability to effectively collaborate with stakeholders at all levels.
6. While not a primary development role, a foundational understanding of programming concepts and experience with general coding (e.g., scripting, understanding code logic for reverse engineering) is a significant plus. Experience with API specifications (REST, JSON) is also beneficial.
7. 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.
8. Significant design experience in Relational Databases, Online Systems, and Web-Based Applications.
9. Must be highly proficient in Microsoft Excel, Word, and their G Suite (Google Workspace) equivalents.
10. Ability to leverage AI tools for writing requirements, use cases, test cases, and design documentation. AI knowledge and usage desired
11. Strong analytical, problem-solving, and decision-making skills with keen attention to detail.
12. Ability to manage multiple priorities in a fast-paced, dynamic environment

Must-Have Skills:

1. Strong proficiency in SQL Server, including scripting and complex query writing.
2. Solid experience working in Agile environments (Scrum, Kanban).
3. Proven ability to analyze data, design relational databases, and translate business needs into technical solutions.
4. Excellent communication and collaboration skills with business and technical teams
5. Project management skills.
6. Experience leveraging AI tools for documentation and process improvement is a plus.
7. Foundational programming knowledge and scripting experience are beneficial.

Desired Skills:

1. Experience with the .NET framework.
2. Familiarity with PostgreSQL databases.
3. Exposure to Snowflake and Tableau for data warehousing and reporting.
4. Experience with AWS cloud services.
5. Strong business knowledge within the Financial Services industry is essential for this role.
6. Mortgage industry experience is highly preferred and will be a strong advantage.

Why join Sonata Software?
At Sonata, you ll have an outstanding opportunity. The chance to use your skills and imagination to push the boundaries of what s possible. To build never seen before solutions to some of the world s toughest problems. You ll be challenged, but you will not be alone. You ll be joining a team of diverse innovators, all driven to go beyond the status quo to craft what comes next.

Sonata Software is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity, age, religion, disability, sexual orientation, veteran status, marital status, or any other characteristics protected by law.