Business Analyst - Salesforce Marketing Cloud

Business Analyst

Must Have Technical/Functional

Skills:

• Gather, analyze, and document business and data requirements from stakeholders.
• Experience as a Business Analyst, Data Analyst, or Project Manager.
• Work with stakeholders to understand reporting and analytics needs.
• Translate functional requirements into technical data specifications and SQL-based solutions.
• Design and support ETL workflows using GCP services (Big Query, Dataform, Composer, Dataflow).
• Perform complex data transformations and validation using advanced SQL.
• Create and manage test data assets and support SIT/UAT validation.
• Conduct data analysis to ensure accuracy, completeness, and consistency.
• Collaborate with engineering, analytics, and business teams to ensure data reliability.
• Provide clear documentation, data dictionaries, and technical artifacts.

Roles & Responsibilities:

• Strong experience with Google Cloud Platform(GCP) services, including Big Query and preferably Dataform.
• Advanced SQL expertise for complex data transformations and analysis.
• Moderate to advanced data modelling experience preferably medallion data architecture.
• Advanced experience gathering and documenting requirements and translating requirements into technical data solutions primarily SQL based.
• Experience in data quality rules and implementation of data quality strategies.
• Experienced with test data assets.
• Excellent written and verbal communication.
• Working knowledge of Python, Google Cloud Composer or Google Cloud Dataflow