Engagement Type: [Full-Time / Contractor]
About CodeRoadCodeRoad 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.
Design & Architect Scalable Data Pipelines: Engineer, optimize, and maintain robust ETL/ELT data pipelines to ingest, transform, and load high-volume transactional data into MS SQL Server and PostgreSQL platforms.
Power AI Products & RAG Systems: Architect data ingestion, metadata structures, chunking, and embedding pipelines feeding Retrieval-Augmented Generation (RAG) platforms and automated detection systems.
Leverage AI-First Data Engineering: Daily application of modern AI tools to accelerate code development, data modeling, and dataset design for advanced AI and analytics workloads.
Orchestrate & Monitor Data Workflows: Schedule, automate, and manage complex data jobs utilizing Airflow, Azure Data Factory (ADF), and SQL Agent while implementing strict data quality checks.
Optimize Database & Query Performance: Perform deep SQL query tuning, dimensional modeling, and structural optimization across enterprise data warehouse and lakehouse architectures.
Collaborate & Ensure Production Excellence: Work directly with product owners, data scientists, and IT Operations to triage production issues, enforce governance, and maintain Git/Bitbucket and Jira delivery standards.
Core Experience: 3+ years of professional data engineering experience building, orchestrating, and supporting production-grade, high-volume data pipelines.
Technical Stack Expertise: Advanced proficiency in Python (pandas) and SQL (complex CTEs, window functions, tuning), with deep experience in MS SQL Server and PostgreSQL.
Pipeline Orchestration & Cloud Knowledge: Hands-on experience orchestrating workflows using Airflow, Azure Data Factory (ADF), or SQL Agent within cloud ecosystems (Azure preferred).
Data Modeling & AI Data Pipelines: Strong understanding of dimensional modeling, data lakehouse structures, and data preparation for AI systems (e.g., embeddings, document ingestion, vector search).
DevOps & Engineering Practices: Proven track record using Git (Bitbucket), Jira, and CI/CD best practices; containerization exposure (Docker) is a plus.
Communication & Availability: Fluent English (written and verbal) with the ability to articulate technical concepts to cross-functional stakeholders and overlap with US Central business hours.
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.
Explore opportunities and submit your application today!
Skills Required
- 3+ years of professional data engineering experience building, orchestrating, and supporting production-grade, high-volume data pipelines
- Advanced proficiency in Python and pandas
- Advanced proficiency in SQL, including complex CTEs, window functions, and query tuning
- Deep experience with MS SQL Server and PostgreSQL
- Hands-on workflow orchestration experience with Airflow, Azure Data Factory, or SQL Agent
- Experience with cloud ecosystems, preferably Azure
- Understanding of dimensional modeling and data lakehouse structures
- Experience preparing data for AI systems, including embeddings, document ingestion, or vector search
- Experience using Git or Bitbucket, Jira, and CI/CD best practices
- Fluent written and verbal English
- Ability to overlap with US Central business hours
- Containerization experience with Docker
What We Do
CodeRoad is a nearshore software development and technology-execution partner that helps organizations modernize applications, migrate to the cloud, build digital products, and implement enterprise AI. Its services span the full software development lifecycle, including dedicated engineering teams, platform engineering, data and AI infrastructure, legacy modernization, cloud architecture, quality automation, and DevOps. The company serves startups, enterprises, and private-equity portfolio businesses.
