Data Engineer

Posted 3hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Data Engineer building scalable ETL/ELT pipelines and AI/RAG data workflows. Supporting CodeRoad’s US clients with SQL, Python, orchestration, and production data operations.

Responsibilities:

  • Develop, optimize, and maintain reliable ETL/ELT pipelines to ingest, transform, validate, and load transactional data into Microsoft SQL Server and PostgreSQL.
  • Contribute to data ingestion and preparation workflows supporting AI applications, including document processing, metadata management, chunking, and embedding generation for RAG systems.
  • Use modern AI tools to accelerate code development, improve data transformation workflows, troubleshoot issues, and improve data engineering efficiency.
  • Develop, schedule, and monitor data processing jobs using Airflow, Azure Data Factory, and SQL Server Agent.
  • Investigate pipeline failures and implement data quality checks.
  • Write and optimize SQL queries, contribute to data modeling, and improve database and analytical data structure performance.
  • Collaborate with Senior Data Engineers, data scientists, product owners, and IT Operations to resolve production issues and implement improvements.
  • Maintain documentation and follow Git, Bitbucket, and Jira workflows.

Requirements:

  • 3+ years of professional experience in data engineering, building, maintaining, and troubleshooting data pipelines and data processing workflows in production environments.
  • Hands-on experience with Python, particularly for data processing and transformation.
  • Strong SQL skills, including joins, CTEs, window functions, aggregations, and query optimization.
  • Familiarity with pandas.
  • Experience with Microsoft SQL Server or PostgreSQL.
  • Practical experience developing or managing data workflows using Airflow, Azure Data Factory (ADF), or SQL Server Agent.
  • Familiarity with cloud environments, preferably Azure, is an advantage.
  • Understanding of data modeling, relational database structures, and data quality principles.
  • Exposure to document ingestion, embeddings, vector search, or data pipelines supporting AI and RAG applications is a plus.
  • Experience with Git-based version control, collaborative development workflows, Bitbucket, and Jira.
  • Familiarity with CI/CD practices and Docker is an advantage.
  • Proactive adoption of AI tools to accelerate development, improve code quality, automate repetitive tasks, and solve technical challenges.
  • Strong troubleshooting and problem-solving skills, attention to detail, and ability to take ownership of assigned tasks.
  • Good English communication skills, written and verbal.
  • Ability to overlap with U.S. Central business hours is required.

Benefits:

  • USA Contractor / 100% Remote
  • Competitive Pay (USD)
  • Holidays Off & Paid Time Off
  • Health insurance assistance program
  • Opportunity to work with high-growth US-based companies and cutting-edge tech stacks.
  • Agentic AI tools and training
  • Coursera Enterprise
  • Studio practice labs
  • High-touch onboarding
  • Transparent leadership communication
  • Community recognition
  • Psychological safety
  • Continuous multi-project pipeline