Data Engineer
Posted 1ds ago
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior Data Engineer building secure HR data warehouses and pipelines for Inallmedia.com’s workforce analytics clients. Developing dbt semantic layers, Snowflake Cortex agents, and MCP-enabled natural-language querying.
Responsibilities:
- Develop, optimize, and maintain secure HR data pipelines using dbt, PySpark, Python, and Apache Airflow
- Ingest HR data from REST APIs, real-time streams, Google Sheets, web APIs, and external platforms
- Provision, configure, and maintain scalable extraction, transformation, and loading infrastructure using Terraform, AWS Glue, AWS EMR, and AWS S3
- Design and maintain data models, data marts, and warehouse structures in Snowflake and Google BigQuery
- Build semantic views and ontology layers mapping CORE → SEMANTIC → METRICS on dbt models
- Configure and deploy generative AI query agents using Snowflake Cortex Analyst and Cortex Search
- Maintain MCP connections between Snowflake and internal AI tools
- Monitor pipelines to enforce 99.5% uptime
- Build automated tests within a Data Quality Framework
- Ensure secure handling of PII and produce comprehensive technical documentation
- Support workforce analytics for international enterprise Centers of Excellence and executive leadership
Requirements:
- 5+ years of dedicated, hands-on data engineering experience
- Deep expertise in Snowflake, Google BigQuery, and dbt
- Strong object-oriented Python scripting capabilities
- Hands-on experience with REST API integrations and real-time data ingestion
- Proficiency in Apache Airflow
- Advanced, highly optimized SQL writing skills
- Experience securely handling large-scale sensitive data (PII)
- Comprehensive technical documentation skills
- Experience working in Agile teams and remote, distributed environments
- Advanced/Fluent English communication skills
- Minimum 4 core working hours of overlap with US Eastern Standard Time
- Nice-to-have: semantic modeling, Snowflake Cortex, Cortex Analyst, Cortex Search, MCP, equivalent LLM query frameworks, prompt engineering, and context engineering
Benefits:
- Remote work from LATAM
- Full-time vendor contract
- Time zone flexibility with EST overlap
- Distributed-team work environment
- Long-term technical expertise and product innovation projects

















