Data Engineer

Engagement Type: [Full-Time / Contractor]

About CodeRoad

CodeRoad is a technology execution partner trusted by companies across North America since 2002. We work alongside our clients to engineer, modernize, and scale the technology that powers their businesses, combining deep technical expertise, specialized teams, and shared accountability for outcomes. Our capabilities span product engineering, platform engineering, legacy modernization, and AI engineering.

Our engineers, designers, delivery leaders, and technology specialists collaborate through Velocity Studios: specialized teams developed within CodeRoad to deliver complex technology initiatives. Being assigned to a project means you become part of a collaborative environment where you can strengthen your expertise, take ownership of meaningful work, and grow alongside experienced professionals.

Why Build Your Career at CodeRoad?

High-Velocity Work & Client Exposure: We work close to the technology, teams and roadmaps that move real outcomes. Direct engagement with U.S. client teams and roadmaps .

Career Continuity & Long-Term Opportunity: Your career here can outlast any single project. Continuous multi-project pipeline; long-tenure CodeRoaders.

Engineering Autonomy & Technical Mastery: We invest in the skills that shape what's next. Agentic AI tools and training, Coursera Enterprise, Studio practice labs, L1-L7 Career Framework.

High-Trust Employee Experience: You grow in an environment built on trust, transparency and recognition. High-touch onboarding, transparent leadership communication, community recognition, psychological safety.

Key Responsibilities

Build & Maintain Scalable Data Pipelines: Develop, optimize, and maintain reliable ETL/ELT pipelines to ingest, transform, validate, and load transactional data into relational databases, particularly Microsoft SQL Server and PostgreSQL.

Support AI & Data-Driven Solutions: Contribute to data ingestion and preparation workflows that support AI applications, including document processing, metadata management, chunking, and embedding generation for Retrieval-Augmented Generation (RAG) systems.

Leverage AI-Assisted Engineering: Proactively use modern AI tools to accelerate code development, improve data transformation workflows, troubleshoot issues, and identify opportunities to make data engineering processes more efficient.

Orchestrate & Monitor Data Workflows: Develop, schedule, and monitor data processing jobs using tools such as Airflow, Azure Data Factory (ADF), and SQL Server Agent. Investigate pipeline failures and implement data quality checks to ensure reliable processing.

Improve Database & Data Model Performance: Write and optimize SQL queries, contribute to data modeling, and improve the efficiency and reliability of database operations and analytical data structures.

Collaborate & Support Production Workloads: Work alongside Senior Data Engineers, data scientists, product owners, and IT Operations to resolve production issues, implement improvements, maintain documentation, and follow established Git, Bitbucket, and Jira workflows.

What You Bring

Core Experience: 3+ years of professional experience in data engineering, building, maintaining, and troubleshooting data pipelines and data processing workflows in production environments.

Python & SQL Proficiency: Hands-on experience with Python, particularly for data processing and transformation, and strong SQL skills, including joins, CTEs, window functions, aggregations, and query optimization. Familiarity with pandas and experience with Microsoft SQL Server or PostgreSQL are expected.

Pipeline Orchestration & Cloud Knowledge: 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.

Data Modeling & AI Data Preparation: Understanding of data mode