Business Systems Analyst Consultant

Truist•Atlanta, GA

1d•Onsite

About The Position

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. This is an office-centric position and will require 5-days per week onsite.

Requirements

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.
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
Strong communication and relationship-building skills
Ability to bridge business and technical teams
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

Nice To Haves

Relevant certifications such as CBAP, CCBA, or PMP are 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.

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.
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.