About the role
Build and maintain enterprise data lakes on BigQuery while designing ETL pipelines for various ERP and CRM systems. Develop and deploy machine learning models for forecasting and create AI agents using LLM APIs.
What they look for
Requirements
Requires 4+ years of experience with Python, SQL, and GCP cloud services. Proficiency in data modeling, API integration, and machine learning techniques is essential for this role.
Full description
Experience: 4+ Years
Role Summary
Build and maintain the enterprise data lake, design ETL pipelines, develop ML models for forecasting, and create AI agents/MCP integrations using LLM APIs.
Required Skills:
- Python ETL — Pandas, NumPy, data modelling, API integrations
- SQL — Complex queries, schema design, performance tuning
- GCP — BigQuery, Cloud Storage, CloudRun, Secret Manager
- Data Lake Design — Ingestion from ERP/CRM systems (NetSuite, Salesforce), schema evolution, data quality
- REST API — Development and consumption (OAuth, webhooks)
- Git & CI/CD — Version control and deployment basics
Preferred Skills:
- AI Agent Development — Tool-calling agents, MCP servers, LLM APIs (Claude, Gemini, OpenAI)
- Machine Learning — Time series forecasting, predictive modelling (Prophet, XGBoost, SARIMAX)
- BI Tools — Qlik or Looker
- Orchestration — Cloud Scheduler, Airflow, or cron-based job pipelines
Key Responsibilities:
1. Build and maintain data lake on BigQuery — ingestion, transformation, scheduling
2. Design and implement ETL pipelines (Python) across banking, ERP, and CRM sources
3. Experiment with and deploy ML models for cash forecasting and business predictions
4. Develop AI agents and MCP tool integrations using LLM APIs
5. Ensure data quality, monitoring, and alerting across pipelines
Our Process
Aeris is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, gender, sexual orientation, gender identity or expression, religion, national origin, marital status, age, disability, veteran status, genetic information, or any other protected status.
As part of our hiring process, Aeris may conduct background checks to verify the information provided in your application and assess your suitability for the role. The scope and type of checks will comply with the applicable laws and regulations of the country where the position is based. Additional detail will be provided via the formal application process.
