What are the responsibilities and job description for the Business Analyst position at Purple Drive Technologies LLC?
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 Google Cloud Platform services (BigQuery, 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(Google Cloud Platform) services, including BigQuery 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