About the role
We are looking for a Senior/Lead Data Engineer to build and maintain the pipelines and data models behind a centralized HR data warehouse. Working in Snowflake, DBT, Python, and Airflow, this person designs semantic layers that make HR data consumable by both BI tools and AI agents. Experience with Snowflake Cortex or MCP-based tooling for agentic querying is a strong plus.
What you will do
- Develop and maintain secure, efficient data pipelines using DBT, PySpark, and Python applications within an Indeed-supported cloud environment for HR data sources.
- Build the infrastructure and tooling required for optimal extraction, transformation, and loading of data from a wide variety of sources using Python, DBT, Terraform, and AWS technologies such as Glue, EMR, and S3.
- Identify and implement internal process improvements, develop tests within the Data Quality Framework, monitor pipelines to maintain 99.5% uptime, and create and maintain the data models used by partner teams.
- Design and build semantic views and ontology layers on top of existing dbt models (CORE → SEMANTIC → METRICS) so HR data is consumable by both BI tools and AI agents/LLMs, defining business-friendly entities, relationships, and metrics that abstract away raw warehouse structure.
- Develop and deploy AI agents (e.g., via Snowflake Cortex Analyst/Cortex Search) for HR COE use cases — including PE, ICIMS, LMS, and Sales/CS Worker agents — enabling natural-language querying over certified HRDM data.
- Configure and maintain MCP (Model Context Protocol) connections between Snowflake and internal AI tooling to securely expose HR data to conversational and agentic interfaces.
Must haves
- 4+ years of experience.
- Snowflake, including data modeling, datamarts, and data warehouse design.
- DBT for data transformations.
- Python, including object-oriented programming and data scripting.
- Airflow for pipeline orchestration.
- REST API integration and data ingestion.
- Google BigQuery querying and optimization.
- Secure handling of large-scale and sensitive data.
- Real-time data processing (e.g., from Google Sheets or APIs).
- Strong SQL, including highly optimized queries.
- Comprehensive documentation skills.
- Upper-intermediate English level.
Nice to haves
- Semantic layer / semantic modeling design, providing business-object abstraction over dbt and warehouse models.
- Snowflake Cortex (Cortex Analyst, Cortex Search) or equivalent LLM-native query layers.
- MCP (Model Context Protocol) or similar tool-calling / context-exposure frameworks.
- Familiarity with prompt and context engineering for grounding LLM agents in certified data sources.
Perks
- Growth without limits: build your skills through mentorship, internal TechTalks, challenging projects, and a dedicated annual learning budget
- Competitive compensation: get recognition that reflects your skills and impact, with regular performance and compensation reviews
- Flexibility: work 100% remotely with flexible hours that support focus, autonomy, and a healthy work rhythm
- Meaningful, modern projects: build impactful products using modern technologies alongside global teams and leading brands
- Collaborative culture: join a supportive environment with zero micromanagement where ideas are welcomed and contributions are recognized
- Well-being & support: access local well-being programs and people-focused support tailored to your location
Didn’t find the perfect fit?
Subscribe to get notified about new roles that match your skills and interests.
Hiring process timeline
We designed our hiring process to be fast, transparent, and convenient — so you always know what to expect and can move through the steps without unnecessary delays.
A quick note
After applying, keep an eye on your inbox — including your spam folder. Occasionally, emails from our hiring platform, LaunchPod, may land there.
Tell us about yourself
Submit a short application form.
Pass a quick test
Pass a 30’- 60’ test.
Record a short video
Introduce yourself on video to fast-track your application process.
Meet our team
Once you pass the video review, grab a spot on our calendar for a technical interview.
Get an offer
Welcome to AgileEngine!
Have any questions?
What is the work format and schedule?
We are a remote-first company, so all our positions are remote. Schedules are flexible, but the main requirement is to have an overlap with your client’s schedule to ensure smooth collaboration. Specific details depend on the project and are discussed during the interview process.
What level of English is required?
We look for Upper-Intermediate (B2) proficiency or higher. Since you will be collaborating with international teams and global clients (including Fortune 500 companies), English is a part of your daily work.
Does AgileEngine provide work equipment?
It depends on your location. We provide equipment in Ukraine, Poland, Argentina, Colombia, Mexico, Brazil, Guatemala, Portugal, Spain, and India. In the USA, equipment is usually provided by the client; otherwise, you will be expected to use your own setup.
What opportunities for professional growth do you offer?
We support continuous growth through personalized development paths tailored to each expert. Also, you can expect:
- An annual learning and development budget
- Internal workshops, tech talks, and mentorship programs
- Opportunities to switch projects or grow into new roles over time
What does a typical team look like, and what tools do you use?
Teams vary by project, but you’ll usually work with a mix of experts across different fields, along with a delivery or project manager who supports collaboration and onboarding.
For day-to-day work, teams commonly use tools like Jira and Google Workspace, along with communication platforms such as Google Chat. Depending on the client, you may also work with Slack, Confluence, Notion, or similar tools.
Need help?
Want more details? See full FAQ
If something doesn’t work or you have questions regarding your application process, drop us a line.