Overview
Skills
Job Details
Job Title :: Snowflake BA
Location :: 100% Remote
Duration :: 6+ Months
Interview :: Video
Job Description:
Must have worked a Snowflake Data Ingestion project – Knowledge of Snaplogic/ETL is a big plus.
Must have worked in a Agile/Scrum environment
Strong Data Governance/Data Analysis
Business Analyst – Snowflake Data Ingestion
Overview
We are seeking a detail-oriented and technically savvy Business Analyst to support data ingestion initiatives within our Snowflake environment. This role will bridge business requirements with technical execution, ensuring that new data sources are accurately defined, onboarded, validated, and optimized for use across analytics, reporting, and downstream applications.
Key Responsibilities
Requirements & Analysis
● Collaborate with business stakeholders to gather, document, and validate data requirements for new Snowflake data ingestion pipelines.
● Analyze source systems (structured and unstructured) to understand data models, key fields, relationships, and business rules.
● Work with data engineers to translate business needs into clear technical specifications, mapping documents, and acceptance criteria.
Data Ingestion Support
● Partner with ETL/ELT engineers to support ingestion into Snowflake, including defining transformations, quality checks, and data validation rules.
● Perform data profiling and gap analysis to ensure source data aligns with business expectations.
● Assist with schema design considerations, ingestion patterns, and metadata requirements.
Testing & Validation
● Create and execute test plans, including data validation, reconciliation, and end-to-end workflow testing for new and updated data pipelines.
● Troubleshoot data discrepancies and partner with engineering teams to resolve ingestion issues.
Documentation & Governance
● Maintain comprehensive documentation for data ingestion processes, data definitions, lineage, and business rules.
● Ensure compliance with data governance, security, and privacy standards.
Stakeholder Communication
● Communicate project updates, risks, and issues to cross-functional teams and project leads.
● Serve as the liaison between business users, data engineers, and project leads.
Qualifications
● Bachelor’s degree in Information Systems, Business, Computer Science, Data Analytics, or related field.
● 3+ years of experience as a Business Analyst, Data Analyst, or similar role in a data-focused environment.
● Strong understanding of Snowflake or cloud data warehouses (e.g., AWS Redshift, BigQuery).
● Experience with data ingestion pipelines, ETL/ELT processes, and structured/unstructured data sources.
● Ability to create data mappings, process flows, and business requirement documents.
● Proficiency in SQL for data profiling and validation.
● Familiarity with data modeling concepts and data governance practices.
● Excellent communication and stakeholder management skills.
Preferred Skills
● Knowledge of cloud platforms (AWS, Azure, or Google Cloud Platform).
● Experience working in Agile methodologies.
● Background in analytics, business intelligence, or data quality frameworks.
● Experience in a higher education skills
● Experience with Workday- Student and Platform