CodeRoad

CodeRoad

CodeRoad is a software development company that specializes in turning ideas into reality. With a team of over 100 experts, we offer a range of services including product management, creative design, development, quality control, and project management...

Internet Software & Services
51-250
Founded 2002

Description

  • Design, build, optimize, and maintain ETL/ELT pipelines for high-volume data in MS SQL Server and PostgreSQL.
  • Architect ingestion, metadata, chunking, and embedding pipelines for RAG platforms and automated detection systems.
  • Use AI tools to accelerate code development, data modeling, and dataset design.
  • Orchestrate and monitor workflows with Airflow, Azure Data Factory, and SQL Agent while enforcing data quality checks.
  • Tune SQL queries and optimize dimensional models, data warehouses, and lakehouse architectures.
  • Collaborate with product owners, data scientists, and IT Operations to resolve production issues and enforce governance.
  • Maintain Git/Bitbucket and Jira delivery standards.

Requirements

  • 3+ years of professional data engineering experience supporting production-grade, high-volume pipelines.
  • Advanced proficiency in Python, including pandas, and SQL with 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.
  • Cloud experience, preferably with Azure.
  • Understanding of dimensional modeling, lakehouse structures, embeddings, document ingestion, and vector search.
  • Experience with Git/Bitbucket, Jira, and CI/CD practices.
  • Docker or containerization experience is preferred.
  • Fluent written and verbal English, with the ability to explain technical concepts to cross-functional stakeholders.
  • Availability to overlap with U.S. Central business hours.

Benefits

  • 100% remote USA contractor arrangement.
  • Competitive compensation paid in USD.
  • Paid holidays and paid time off.
  • Health insurance assistance program.
  • Exposure to high-growth U.S.-based companies and modern technology stacks.
  • Access to AI tools and training, Coursera Enterprise, practice labs, and a career framework.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Development Engineer

Attain Talent 1-10 staffing & recruiting

Attain Talent is hiring a Development Engineer to support CMS modernization by building and maintaining scalable AWS and Databricks data pipelines for healthcare analytics, reporting, and operational decision-making.

Apache Spark AWS CI/CD Databricks GitHub Python SQL
1 hour ago

Staff Data Engineer, Tech Foundations

Airbnb 5K-10K Hotels, Restaurants & Leisure

Airbnb is hiring a Staff Data Engineer for its Enterprise Core Datasets team to lead the architecture, development, and operation of reliable data foundations supporting AI measurement, unit economics, enterprise applications, and critical financial metrics.

Apache Spark Python Scala SQL
1 day, 1 hour ago

Data Engineer

Stack Overflow 251-1K Internet Software & Services

Stack Overflow is seeking a Data Engineer to build and operate reliable, secure data systems that support customer-facing features, shared data foundations, and product development on a remote-first team.

Apache Spark Azure CI/CD Databricks Git Python REST API SQL
1 day, 2 hours ago

Senior Data Engineer

Clear Street 501-1000 financial services

Clear Street is hiring a Data Engineer for its Active Data team to build and own reliable, governed data pipelines and warehouse models supporting growth, customer lifecycle, and regulated brokerage operations.

Apache Airflow CRM Datadog dbt Kubernetes Python Segment Snowflake SQL
1 day, 2 hours ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers