Senior Data Engineer

Posted One Month Ago
Be an Early Applicant
11 Locations
Remote
Senior level
Artificial Intelligence • Cloud • Professional Services • Software
The Role
Designs and optimizes semantic data models, analytical views, and production ETL/ELT pipelines for AI and analytics workloads. Tunes databases for low-latency retrieval, implements RBAC, row-level security, data masking, governance, monitoring, and quality standards, and collaborates with AI engineering teams on RAG and agentic AI systems.
Summary Generated by Built In

Engagement Type: Full-Time / Contractor

Location: Latin America | 100% Remote

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
  • Architect Semantic & Data Layers: Design and implement modern semantic models (facts, dimensions, and metric stores using tools like dbt) to abstract complex operational databases for AI querying and analytical consumption.

  • Build Scalable Data Pipelines: Construct curated, high-performance analytical views and production ELT/ETL pipelines that streamline data retrieval, enhance freshness, and eliminate redundancy across environments.

  • Optimize Low-Latency Performance: Tune complex database queries, indexing, and schema definitions through systematic query log analysis to support demanding analytical and AI workloads.

  • Implement Robust Governance & Security: Lead the rollout of granular data governance, including Role-Based Access Control (RBAC), Row-Level Security (RLS), dynamic data masking, and anonymization for PII protection.

  • Enable Agentic AI & RAG Ecosystems: Collaborate directly with cross-functional AI engineering teams to align data structures, semantic foundations, and retrieval mechanisms with Retrieval-Augmented Generation (RAG) and Agentic AI workflows.

  • Establish Quality & Observability: Define standards for pipeline monitoring, continuous data quality checks, and automated alerting to maintain high reliability across all analytical layers.

What You Bring
  • Core Engineering Experience: 4+ years of dedicated data engineering experience with production-grade command of SQL (Azure SQL, PostgreSQL, or modern Cloud Data Warehouses).

  • Data Modeling & ELT Foundations: Solid expertise in Kimball dimensional modeling, building resilient ELT/ETL pipelines, and structuring semantic/metrics layers using dbt.

  • Security & Governance Standards: Proven track record implementing strict database security policies, fine-grained RBAC/RLS, and dynamic data masking for PII compliance.

  • AI Integration & Latency Tuning: Practical experience tuning queries for low-latency workloads and supporting data foundations for RAG applications and Agentic AI frameworks.

  • Ownership & Soft Skills: Strong technical autonomy, proactive problem-solving mindset, and a collaborative approach to driving execution within nearshore agile teams.

  • Communication: Advanced/Fluent English proficiency (written and spoken) is required for direct daily collaboration with U.S. stakeholders.

Nice to have: Experience with orchestration tools (Airflow, Prefect, Dagster), vector databases (pgvector, Pinecone, Qdrant), event-driven streaming (Kafka, Kinesis), or Cloud Infrastructure/CI-CD (Terraform).

What You’ll Love
  • 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.

Ready to Build What Actually Ships?

Explore opportunities and submit your application today!

Skills Required

  • 4+ years of dedicated data engineering experience
  • Production-grade SQL experience with Azure SQL, PostgreSQL, or modern cloud data warehouses
  • Experience with dimensional modeling using Kimball methodology
  • Experience with semantic layer or metrics store architecture, such as dbt
  • Production experience building and maintaining resilient ETL or ELT pipelines
  • Experience implementing database security policies and granular role-based permissions
  • Experience with dynamic data masking and PII protections
  • Hands-on experience tuning complex queries for low-latency analytical workloads
  • Practical experience with RAG applications and agentic AI frameworks
  • Advanced written and spoken English fluency
  • Experience with Apache Airflow, Prefect, or Dagster
  • Exposure to vector databases such as pgvector, Pinecone, or Qdrant
  • Familiarity with Apache Kafka or AWS Kinesis
  • Experience with Terraform or cloud-native CI/CD automation
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
350 Employees
Year Founded: 2002

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.

Similar Jobs

Dev.Pro Logo Dev.Pro

Senior Data Engineer

Information Technology • Software
In-Office or Remote
3 Locations
1000 Employees

CodeRoad Logo CodeRoad

Senior Data Engineer

Artificial Intelligence • Cloud • Professional Services • Software
Remote
11 Locations
350 Employees

CodeRoad Logo CodeRoad

Senior Data Engineer

Artificial Intelligence • Cloud • Professional Services • Software
Remote
11 Locations
350 Employees

Truelogic Software Logo Truelogic Software

Senior Data Engineer

Information Technology • Software
Remote
12 Locations
266 Employees

Similar Companies Hiring

Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees
VCA Animal Hospitals Thumbnail
Pet • Professional Services
Los Angeles, CA
35000 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account