Data Workflow & Integration

Responsibilities and duties:
Data Architecture & Schema Design

Design scalable relational and/or non-relational database schemas for structured and unstructured datasets
Define tables, relationships, metadata standards, and naming conventions to maximize clarity and future scalability
Establish data governance rules and documentation

Data Ingestion, Transformation & Pipelines

Develop and manage ETL/ELT workflows to pull data from various sources (APIs, CSVs, SaaS platforms, cloud storage) using both automated and manual methods
Perform data cleaning, normalization, deduplication, and enrichment
Prepare datasets for migration to new platforms, ensuring structural and semantic consistency
Automate recurring data ingestion and transformation processes when possible

Platform & System Implementation

Support new software/platform rollouts by preparing data for ingestion, testing migrations, and validating results
Configure platform-specific data models, permissions, and workflows
Assist with vendor coordination and implementation timelines

Workflow Automation & Integration

Build and maintain automations to streamline manual processes (status updates, notifications, custom calculations)
Integrate disparate platforms (e.g., Airtable, MFST 365, SFDC, BI tools) via native connectors, middleware (Zapier, Power Automate, etc.), or APIs
Create alerts, validation rules, and monitoring dashboards to ensure data quality

Quality Assurance & Maintenance

Conduct regular QA checks for data integrity, completeness, and compliance
Troubleshoot schema, automation, and integration issues
Maintain version control for workflows and pipelines

Stakeholder Collaboration

Partner with Voice of Customer, operations, and product teams to gather requirements and align workflows when needed
Provide training and support to internal users on Airtable features and best practices
Contribute to knowledge base and onboarding materials

Requirements:

5-10 years of experience in data operations, workflow design, or platform integration
Proven experience building and maintaining ETL/ELT pipelines across multiple data sources
Proficiency with data cleaning and transformation tools (Excel, SQL, Python, or similar)
Strong skills in relational database design and metadata management
Excellent written and verbal communication, with a focus on clear documentation

Experience with Airtable