IT - EP Lending - Sr Business Systems Analyst (Remote in CA Only)

<p style="margin: 0in; line-height: 115%; font-size: 12pt; font-family: 'Times New Roman', serif;"><strong><span style="font-size: 13.0pt; line-height: 115%; font-family: Arial, sans-serif;">JOB TITLE: </span></strong><span style="font-size: 13.0pt; line-height: 115%; font-family: Arial, sans-serif;">Senior Business Systems Analyst </span></p> <p style="margin: 0in; line-height: 115%; font-size: 12pt; font-family: 'Times New Roman', serif;"><strong><span style="font-size: 13.0pt; line-height: 115%; font-family: Arial, sans-serif;">DEPARTMENT: </span></strong><span style="font-size: 13.0pt; line-height: 115%; font-family: Arial, sans-serif;">Information Technology </span></p> <p style="margin: 0in; line-height: 115%; font-size: 12pt; font-family: 'Times New Roman', serif;"><strong><span style="font-size: 13.0pt; line-height: 115%; font-family: Arial, sans-serif;">STATUS: </span></strong><span style="font-size: 13.0pt; line-height: 115%; font-family: Arial, sans-serif;">EXEMPT </span></p> <p style="margin: 0in; line-height: 115%; font-size: 12pt; font-family: 'Times New Roman', serif;"><strong><span style="font-size: 13.0pt; line-height: 115%; font-family: Arial, sans-serif;">JOB CODE: </span></strong><span style="font-size: 13.0pt; line-height: 115%; font-family: Arial, sans-serif;">4509</span></p> <p style="line-height: 115%; margin: 0in 0in 8pt; font-size: 11pt; font-family: Calibri, sans-serif;"><strong><span style="font-size: 13.0pt; line-height: 115%; font-family: Arial, sans-serif;">PAY SCALE: </span></strong><span style="font-size: 13.0pt; line-height: 115%; font-family: Arial, sans-serif;">$102,000.00 - $110,000.00 Annually</span></p> <p style="margin-bottom: 0px; margin-top: 0px;"><span style="font-size: medium;"> </span></p> <p style="margin-bottom: 0px; margin-top: 0px;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;"><strong><u>GENERAL DESCRIPTION: </u></strong></span></p> <p style="margin-bottom: 0px; margin-top: 0px;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">The Senior Business Systems Analyst is responsible for translating business data needs into data warehousing and reporting solutions through close collaboration with business teams to identify business requirements enabling data driven decision making throughout the enterprise. </span></p> <p style="margin-bottom: 0px; margin-top: 0px;"><br><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;"><strong><u>TASKS, DUTIES, FUNCTIONS: </u></strong></span></p> <ol> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">This role covers all aspects of the Software Development Lifecycle with respect to data warehousing and reporting solutions.<span style="white-space: normal;">  </span>Requirements analysis, report content identification and report functionality analysis, SDLC documentation, and other recommend designs/solutions will be necessary to meet business or other requirements.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Determine and recommend reporting enhancements or improvements for existing as well as new processes through the use of enterprise business intelligence tools to enhance the analysis capability or operational efficiency of various business units within the organization. This includes working across business areas, applications, data domains and technologies.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Document business requirements (BRDs) and functional design specifications (FRDs) for conversions, interfaces and reports.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Drive efficient and effective joint business/IT requirements and solution discussions in addition to stakeholder review meetings.<span style="white-space: normal;"> </span></span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Identify functional gaps and opportunities of improvement.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Coordinate and drive issue resolution with cross-functional teams during the design and development process.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Work closely with users to define and document use cases, scenarios and test scripts.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Prepare and execute test plans to ensure solution/design meet business requirements.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Create documentation for processes, training and operational support.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Ensure requirements are delivered in timely stages, allowing the design and development to make the necessary progress.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Maintain a thorough understanding of state and federal laws and regulations related to credit union compliance including bank secrecy and anti-money laundering laws appropriate to the position.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Ensure solutions within the environment follow established guidelines.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Research, define and evaluate data requirements and specifications for departmental projects.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Perform evaluations of data and data structures from disparate systems. Proactively seek opportunities to understand and improve business processes through data business intelligence and data analytics.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Mentors and trains other Business Systems Analyst as needed.<span style="white-space: normal;"> </span></span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Act as liaison between business clients and technical staff throughout the life cycle of projects or process improvements. Coordinate effectively with IT and other departmental projects analysts and managers.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Stay current with technology trends, solutions and vendors.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Perform other job-related duties as necessary.</span></li> </ol> <p style="margin-bottom: 0px; margin-top: 0px;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;"><strong><u>PHYSICAL SKILLS, ABILITIES, AND EXERTION UTILIZED IN THE PERFORMANCE OF THESE TASKS: </u></strong></span></p> <ol> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Effective oral and written communication skills required to interpret, resolve, and document networking problems.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Occasional local, statewide and inter-state travel may be required.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Periodically work extended and weekend hours.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Ability to work under pressure.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Must possess sufficient manual dexterity to operate standard office equipment such as PC, copy and fax machines and telephones.</span></li> </ol> <p style="margin-bottom: 0px; margin-top: 0px;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;"><strong><u>ORGANIZATIONAL CONTACTS & RELATIONSHIPS: </u></strong></span></p> <ol> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;"><strong>INTERNAL: </strong>All Credit Union Staff</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;"><strong>EXTERNAL: </strong>Vendors</span></li> </ol> <p style="margin-bottom: 0px; margin-top: 0px;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;"><strong><u>QUALIFICATIONS: </u></strong></span></p> <ol> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;"><strong>EDUCATION:</strong> Bachelor’s degree in Computer Science or related field or equivalent work experience.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;"><strong>EXPERIENCE: </strong>Combined minimum 7-10 years’ progressive experience in business requirements analysis and data analysis are key success factors in for this position.<span style="white-space: normal;">  </span>High intermediate to expert SQL skills are a must.<span style="white-space: normal;">  </span>Previous experience with data modeling, data analysis, data quality analysis and report development desired.<span style="white-space: normal;">  </span>Exposure to a diverse enterprise application landscape with a solid understand of how data flows through a business is critical to this position.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;"><strong>KNOWLEDGE/SKILLS:</strong></span> <ul> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Must be proficient at analyzing data with SQL, TSQL PSQL or Excel while accessing diverse application architectures and data models.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;"> Ability to access and analyze data in complex data models with little supervision or input is a must.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Scripting experience with Bash, Powershell, Python or Perl desired.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Excellent analytical and technical skills in varied IT technologies. Proficient in software/hardware enterprise technologies, systems integrations and software/hardware release to production methodologies, etc</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Excellent complex problem-solving skills.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Ability to quickly comprehend the functions and capabilities of new and existing technologies.<span style="white-space: normal;"> </span></span></li> </ul> </li> <ul> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;"><strong>TECHNICAL:</strong></span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;"><strong>NON-TECHNICAL:</strong></span></li> </ul> </ol> <ul> <li style="list-style-type: none;"> <ul> <li style="list-style-type: none;"> <ul> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Project and program management capabilities.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Proven experience in executing system and integration testing.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Proficient in requirements definition, evaluation and documentation.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Excellent planning and organization skills.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Strong communication and interpersonal skills, with the ability to influence technical and non-technical parties.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Ability to work with technical and business oriented teams.</span></li> </ul> </li> </ul> </li> </ul> <p style="margin-bottom: 0px; margin-top: 0px;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;"><strong><u>PHYSICAL REQUIREMENTS: </u></strong></span></p> <ol> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Carry and respond to a cell phone 7 days a week. May be able to diagnose problems from home, occasionally may need to travel to site to correct problem either by car or public conveyance.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Prolonged sitting throughout the day.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Must possess sufficient manual dexterity to skillfully operate applicable computer hardware, software and a variety of hand tools and standard office equipment.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Corrected vision in the normal range.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Corrected hearing in the normal range. A telephone device will be provided if needed.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Occasional bending, stooping, and standing on a stepladder.</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Lifting and carrying up to 50 pounds.</span></li> </ol> <p style="margin-bottom: 0px; margin-top: 0px;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;"><strong><u> LICENSES/CERTIFICATIONS: </u></strong></span></p> <ol> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Advanced technical and/or project management certifications (Desired)</span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-size: 12pt; font-family: arial, helvetica, sans-serif;">Certified Business Analysis Professional (CBAP) </span></li> </ol> <p style="box-sizing: border-box; margin: 0in 0in 8pt; color: #1c1c1e; white-space: normal; background-color: #ffffff; line-height: 15.6933px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="box-sizing: border-box; font-family: arial, helvetica, sans-serif; font-size: 12pt;"><em style="box-sizing: border-box;"><span style="box-sizing: border-box; line-height: 18.4px;">Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.</span></em></span></p> <p style="box-sizing: border-box; margin: 0in 0in 8pt; color: #1c1c1e; white-space: normal; background-color: #ffffff; line-height: 15.6933px; font-size: 11pt; font-family: Calibri, sans-serif;"><span style="box-sizing: border-box; font-family: arial, helvetica, sans-serif; font-size: 12pt;"><em style="box-sizing: border-box;"><span style="box-sizing: border-box; line-height: 18.4px;">#LI-Remote</span></em></span></p> <p><strong><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">THIS JOB DESCRIPTION PROVIDES AN OVERVIEW OF THE GENERAL SCOPE AND LEVEL OF WORK EXPECTED TO BE PERFORMED, BUT IT IS NOT AN EXHAUSTIVE LIST OF ALL DUTIES OR RESPONSIBILITIES ASSOCIATED WITH THE POSITION. THE CREDIT UNION RESERVES THE RIGHT TO MODIFY, ADD, OR REMOVE DUTIES AS NEEDED WITHOUT ADVANCE NOTICE. EMPLOYEES MAY BE REQUIRED TO PERFORM ADDITIONAL TASKS AND DUTIES AS DIRECTED BY THEIR SUPERVISOR, PROVIDED SUCH TASKS ARE WITHIN THE EMPLOYEE’S KNOWLEDGE, SKILLS, AND ABILITIES, OR CAN BE PERFORMED WITH REASONABLE TRAINING. NOTHING IN THIS JOB DESCRIPTION ALTERS THE AT-WILL EMPLOYMENT RELATIONSHIP OR LIMITS THE CREDIT UNION’S RIGHT TO ASSIGN OR REASSIGN DUTIES AND RESPONSIBILITIES TO THIS POSITION AT ANY TIME.</span></strong></p> <p style="text-align: right;"> </p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...