Python and Airtable Data Integration Specialist

About the Role

We are seeking an experienced Python and Airtable specialist to help us consolidate, cleanse, and normalise customer data from multiple sources into our existing Airtable platform. Our primary objective is to rank customers by their commercial value, enabling us to identify and prioritise our most valuable customers effectively.

You will work with data snapshots from MongoDB and SQL databases, integrate them into our pre-configured Airtable setup, and establish an automated sync process for ongoing updates. We need someone who can independently assess our existing setup and implement a reliable, low-maintenance solution. 20h/week commitment.

Key Responsibilities
✅ Assess existing Airtable configuration and understand the current data structure
✅ Extract and consolidate data from MongoDB and SQL database snapshots
✅ Cleanse and normalise data to ensure consistency and quality across sources
✅ Understand and implement customer ranking methodology based on commercial value
✅ Import processed data into our existing Airtable platform via API
✅ Design and implement automated data sync - either live feed or monthly automated updates
✅ Recommend best practices for data integration and ongoing maintenance
✅ Document the solution for future reference and minimal manual intervention

Requirements
✔ Strong Python programming skills with focus on data processing
✔ Proven experience with Airtable API and data integration
✔ Expertise in MongoDB - querying, data extraction, and manipulation
✔ Solid SQL knowledge - complex queries and data extraction
✔ Data cleansing and normalisation experience across multiple data sources
✔ ETL (Extract, Transform, Load) process implementation
✔ Automated data syncing and scheduling experience
✔ Ability to work independently and assess existing systems without extensive briefing
✔ Problem-solving skills to figure out requirements from existing setup and data snapshots
✔ Strong attention to detail and data quality standards

Nice to Have
➕ Experience with customer value analysis and ranking algorithms
➕ Knowledge of data warehousing concepts and best practices
➕ Familiarity with Apache Airflow or similar workflow automation tools
➕ Experience with API rate limiting and optimization
➕ Background in CRM data integration projects
➕ Understanding of data governance and security best practices
➕ Experience with Pandas, NumPy or similar Python data libraries
➕ Knowledge of cloud-based automation platforms (AWS Lambda, Google Cloud Functions, etc.)

Note: We will provide you with direct access to our Airtable account and links to updated data snapshots. You'll need to independently assess the setup and determine the best integration approach without extensive briefing from our previous consultant.