Data Engineer

About the Role

As a Data Engineer at Aspire, you will play a key role in delivering trusted, high-quality data to teams, with this role centered on the Analytics product. The HR Data Mart (HRDM) team enables people insights and a data-driven culture by building and maintaining a centralized, secured, and quality-certified HR data warehouse. You will develop and maintain the data pipelines, infrastructure, and data models for HR data sources that power analytics and insights for HR Centers of Excellence (COEs) and HR leaders. The overarching objective is to deliver faster data insights through secure, efficient, and scalable analytical datasets. This position requires US

What You'll 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.

What You'll Need

• 5+ 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.
• Advanced English communication.
• 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.

Why Aspire

• Be part of a team that delivers trusted, high-quality data to teams across Indeed.
• Enable people insights and a data-driven culture through a centralized, secured, and quality-certified HR data warehouse.
• Power analytics and insights for HR Centers of Excellence (COEs) and HR leaders.
• Deliver faster data insights through secure, efficient, and scalable analytical datasets.
• Work on modern data and AI enablement through semantic layers, ontology models, AI agents, and MCP connections.
• Gain exposure to a data environment that prioritizes security, quality, and reliability.