Business Systems Analyst Consultant

Regular or Temporary Regular Language Fluency English (Required) Work Shift 1st shift (United States of America) Work Location This is an office-centric position and will require 5 days per week onsite. Job Description We are seeking a Salesforce & ETL Business/Data Analyst to join our Salesforce Integration (ETL & API) Development team. This role is ideal for someone who thrives at the intersection of business processes, technology, and user experience. The BSA will work closely with cross-functional business stakeholders, product managers, delivery teams and engineering teams to translate business needs into well-defined requirements and deliver scalable Salesforce and ETL integration solutions that drive efficiency and growth. Essential Duties And Responsibilities Independently analyzes and documents complex business requirements, conducting requirements gathering sessions to define scope and objectives for new or enhanced systems. Collaborates with stakeholders to identify opportunities for process improvements and technology innovations aligned with organizational strategies. Translates business needs into detailed system and application specifications for development and support teams. Designs, configures, and helps deploy enterprise systems, applications, and infrastructure to meet business requirements. Supports the testing, validation, and quality assurance of new and existing systems to ensure functionality, performance, and security standards are met. Provides technical guidance and mentorship to team members and stakeholders throughout project lifecycles. Ensures compliance with organizational standards, policies, and regulatory requirements in all system and process activities. Monitors system performance, identifies issues, and implements corrective actions to optimize operational efficiency. Manages vendor relationships and oversees third-party service providers to ensure quality and compliance. Additional Responsibilities Partner with business and technical teams to gather, document, and analyze business requirements for Salesforce Sales Cloud, Marketing Cloud and other initiatives. Ability to work independently and analyze distributed and cloud systems like SQL, ETL, Salesforce, execute SQL queries in different database systems, SOQL queries in Salesforce and perform gap analysis. Deliver mapping documents and other technical requirement documents. Analyze business requirements and compare them against Salesforce/ source data structures to confirm alignment and identify any gaps or inconsistencies. Validate developer- loaded data in Salesforce by detailed checks to ensure accuracy, completeness and compliance with defined requirements. Collaborate with cross-work-stream teams to review, refine, and finalize business and technical requirements. Develop comprehensive Business Requirement Documents (BRDs), Product Requirement Documents (PRDs), User Stories, and User Acceptance Criteria in collaboration with Product and Engineering teams. Build user journeys, process flows, and system diagrams to visualize and communicate business processes and solution designs. Support the backlog management and grooming process, ensuring clear prioritization and alignment with business goals. Collaborate with engineering and QA teams during development and UAT to validate solutions meet business expectations. Maintain accurate and updated documentation using Confluence and track development progress using Jira. Serve as a subject matter expert on Salesforce capabilities and data flows, identifying opportunities to optimize business processes and system usage. Support change management, end-user training, and documentation as part of new feature rollouts and enhancements. Qualifications Required Qualifications Bachelor’s degree in Information Technology, Computer Science, or related field. Minimum of 5 years of experience in business systems analysis, enterprise architecture, or related roles. Strong knowledge of system design, integration, and support of enterprise applications and infrastructure. Experience with requirements gathering, process modelling, and documentation. Relevant certifications such as CBAP, CCBA, or PMP are preferred. Preferred 6-8 years of professional experience as an IT Business Analyst or Business System Analyst, preferably supporting Salesforce CRM platforms (Sales Cloud and/or Marketing Cloud). Strong proficiency in Jira and Confluence for requirements tracking and documentation. Proven experience in creating BRDs, PRDs, user stories, acceptance criteria, and process documentation. Demonstrated ability to build user journeys, workflows, and diagrams using tools such as System Architect, Visio. Strong communication, presentation, and documentation skills, able to clearly convey complex information to both technical and non-technical audiences. Experience preparing executive-ready PowerPoint decks and managing deliverables via Smartsheet or similar tools. Working knowledge of Salesforce platform capabilities, data model, and integration patterns. Preferred Top Requirements Must-have requirements for this BSA role are: Experience with ETL technologies like Informatica or Talend Experience with Salesforce Platform, SOQL queries. Understanding of Salesforce REST APIs Experience with Microsoft SQL, DB2, data querying, and reporting tools. Understanding of digital banking operations, API, XML, JSON, CSV and system integrations. Experience working with projects following Agile framework. Experience with Agile tooling like Gitlab, Rally/JIRA/Confluence Business & Communication Skills Strong communication and relationship-building skills Ability to bridge business and technical teams Hands-On Expectations Can translate and validate requirements in Salesforce Salesforce SOQL querying and Salesforce data model and data analysis SQL querying and Database data and datamodel analysis Job development using Informatica or Talend Ideally has hands-on Salesforce or prior system integration experience Can perform business-level QA and test their documented stories General Description of Available Benefits for Eligible Employees of Truist Financial Corporation All regular teammates (not temporary or contingent workers) working 20 hours or more per week are eligible for benefits, though eligibility for specific benefits may be determined by the division of Truist offering the position. Truist offers medical, dental, vision, life insurance, disability, accidental death and dismemberment, tax-preferred savings accounts, and a 401k plan to teammates. Teammates also receive no less than 10 days of vacation (prorated based on date of hire and by full-time or part-time status) during their first year of employment, along with 10 sick days (also prorated), and paid holidays. For more details on Truist’s generous benefit plans, please visit our Benefits site. Depending on the position and division, this job may also be eligible for Truist’s defined benefit pension plan, restricted stock units, and/or a deferred compensation plan. As you advance through the hiring process, you will also learn more about the specific benefits available for any non-temporary position for which you apply, based on full-time or part-time status, position, and division of work. Truist is an Equal Opportunity Employer that does not discriminate on the basis of race, gender, color, religion, citizenship or national origin, age, sexual orientation, gender identity, disability, veteran status, or other classification protected by law. Truist is a Drug Free Workplace. EEO is the Law E-Verify IER Right to Work #J-18808-Ljbffr Truist