Business Analyst – Snowflake Data Ingestion

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

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