Data Engineer

CodeRoad

. Design and implement modern semantic models, including facts, dimensions, and metrics stores using tools like dbt, for AI querying and analytical consumption .

Posted 11/1/2026full-timeRemote • United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and implementing semantic models and data governance frameworks, with a strong command of SQL and experience in building resilient ETL/ELT pipelines. Proficient in optimizing database performance and collaborating with cross-functional teams to align data structures with advanced AI workflows.

Highest-signal resume keywords

Data Engineering ExperienceSQL ProficiencyETL/ELT Pipeline DevelopmentDatabase Security ImplementationDimensional Modeling Expertise

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLETLELTDimensional ModelingData GovernanceQuery OptimizationData Quality StandardsData AnonymizationPerformance TuningSemantic Layer Design

Soft Skills

Problem-SolvingOwnership MindsetCollaboration

Tools & Technologies

DbtAzure SQLPostgreSQLAirflowPrefect

Industry Keywords

RBACRLSDynamic Data MaskingPII ProtectionAnalytical WorkloadsRAG Frameworks

Tech Stack

Tools & technologies

AirflowAzureCloudETLPostgresSQL

About the role

Key responsibilities & impact

Design and implement modern semantic models, including facts, dimensions, and metrics stores using tools like dbt, for AI querying and analytical consumption
Build curated, high-performance analytical views and production ELT/ETL pipelines
Optimize database query performance, indexing, and schema definitions through systematic query log analysis
Implement data governance frameworks including RBAC, RLS, and dynamic data masking for PII protection
Establish data quality, pipeline monitoring, and anonymization standards across analytical layers
Collaborate with cross-functional AI engineering teams to align data structures with RAG architectures and Agentic AI workflows

Requirements

What you’ll need

3+ years of dedicated Data Engineering experience
Strong, production-grade command of SQL across Azure SQL, PostgreSQL, or modern cloud data warehouses
Proven production track record building and maintaining resilient ETL/ELT data pipelines and optimized analytical structures
Demonstrated experience in database security, including RBAC, RLS, and dynamic data masking for PII protection
Hands-on expertise tuning complex queries for low-latency analytical workloads
Strong foundation in dimensional modeling (Kimball) and semantic layers (dbt)
Strong ownership mindset and proactive problem-solving abilities within collaborative nearshore team environments
Advanced English fluency, written and spoken, strictly required
Bonus exposure to orchestration platforms (Airflow/Prefect), vector databases, or RAG frameworks

Benefits

Comp & perks

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
L1-L7 Career Framework