Business Systems Analyst, SQL
Serigor Inc
SQL
Business Systems Analyst
Prudential Financial
full-time
Posted on:
Location Type: Hybrid
Location: Newark • New Jersey • 🇺🇸 United States
Visit company websiteSalary
💰 $75,000 - $90,000 per year
Job Level
Mid-LevelSenior
Tech Stack
CognosSDLCSQL
About the role
- Serve as a liaison between IT development teams and business units to support new system implementations and enhancements
- Provide support across multiple investment management business units
- Gather and translate business requirements into actionable terms for systems and operations teams
- Contribute to major infrastructure projects through business analysis and technical documentation
- Provide production support and resolve issues, including during peak periods (overtime may be required)
- Participate in all phases of the systems development life cycle (SDLC)
- Create and execute test plans to validate system functionality
- Document software bugs and collaborate on solutions
- Prepare communications and presentations on system enhancements and alternatives
- Support cross-functional initiatives and take ownership of resolving production
Requirements
- Bachelor’s degree or equivalent experience in Management Information Systems (MIS), Business Analytics and Information Technology (BAIT), Business, Accounting, Computer Science, Finance, or Economics
- A combination of business and technology studies is ideal
- 3–5 years of relevant experience with a solid understanding of business functions, workflows, and supporting systems
- Some investment knowledge, particularly related to investment trades, transactions, activity, positions, and associated systems
- Familiarity with systems design methodologies, testing tools, and the interfaces, applications, reconciliations, and workflows that support investment operations
- Experience with SQL and related tools (e.g., Microsoft Query, Rapid SQL, DBeaver)
- Knowledge of the software development life cycle; Agile experience is a plus
- Exposure to business analysis, requirements gathering, software testing, and automation tools
- Strong technical aptitude, problem-solving abilities, communication skills, and business insight
- Proficiency in MS Office (Excel, Word, PowerPoint, Visio, SharePoint, OneDrive, Outlook, MS Project)
- Experience with reporting platforms (e.g., Cognos) and API support is a plus
- Strong analytical, organizational, and project management skills.
Benefits
- Medical, dental, vision, life insurance, disability insurance
- Paid Time Off (PTO)
- 401(k) plan with company match (up to 4%)
- Company-funded pension plan
- Wellness Programs including up to $1,600 a year for reimbursement of items purchased to support personal wellbeing needs
- Work/Life Resources to help support topics such as parenting, housing, senior care, finances, pets, legal matters, education, emotional and mental health, and career development
- Education Benefit to help finance traditional college enrollment toward obtaining an approved degree and many accredited certificate programs
- Employee Stock Purchase Plan: Shares can be purchased at 85% of the lower of two prices (Beginning or End of the purchase period), after one year of service
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLbusiness analysisrequirements gatheringsoftware testingAgilesystems design methodologiestechnical documentationtest plansproduction supportinfrastructure projects
Soft skills
communication skillsproblem-solving abilitiesorganizational skillsproject management skillsanalytical skillsbusiness insightcross-functional collaborationownershipinterpersonal skillspresentation skills
