Core Data Engineer (AI)

Location: Remote; remote-first collaboration across a global team.

Company

hirify.global is building a business intelligence and data platform that provides trusted, current data for company decision-making.

What you will do

• Operate and troubleshoot an on-premises Microsoft SQL Server environment, including linked servers, OPENQUERY, and PolyBase.
• Investigate stale feeds, broken joins, changing source systems, and other data quality issues through to resolution with data owners.
• Maintain Airflow DAGs and Python jobs across Windows and Linux virtual machines, including failed tasks, backfills, retries, and dependencies.
• Model new source domains and build warehouse data models that analysts can use independently.
• Implement automated data quality gates for freshness, volume, referential integrity, and business rules.
• Tune SQL queries, stored procedures, indexes, and execution plans, while improving alerting, logging, runbooks, automation, and production checks for AI-assisted code.

Requirements

• 3+ years of core data engineering experience in a production environment.
• Professional Microsoft SQL Server expertise, including T-SQL, indexing, execution plans, query tuning, partitioning, linked servers, OPENQUERY, and PolyBase.
• Strong data modelling skills and experience designing warehouse tables, dimensional models, and effective quality gates.
• Strong Python and production Airflow experience, including authoring, operating, scheduling, retrying, backfilling, and debugging DAGs.
• Hands-on experience with Claude Code or comparable agentic coding tools, MCP servers, and LLM-powered workflows, with rigorous verification of generated SQL and pipeline code.
• Experience with Git and GitLab, Windows and Linux virtual machines, and at least one major cloud platform such as Azure or AWS; clear professional English is required.

Nice to have

• Microsoft Fabric experience, including Lakehouse, Warehouse, Data Factory pipelines, or OneLake.
• Experience building MCP servers or internal LLM tooling.
• Power BI or another BI tool experience.
• Experience in fast-growing B2C or subscription-driven businesses.

Culture & Benefits

• Remote-first collaboration across a global team.
• EU meet-ups and an annual company summer getaway.
• Ownership of the operational data platform with responsibility for running and improving it.
• Production use of Claude Code, MCP servers, and LLM tooling.
• Culture focused on clarity, structure, long-term thinking, and close collaboration with BI, analytics, and data-owning teams.