<p data-path-to-node="1"><strong data-path-to-node="1" data-index-in-node="0">Engagement Type:</strong> Full-Time / Contractor</p> <h3 data-path-to-node="2">About CodeRoad</h3> <p data-path-to-node="3">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.</p> <p data-path-to-node="4">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.</p> <h3 data-path-to-node="5">Why Build Your Career at CodeRoad?</h3> <ul data-path-to-node="6"> <li> <p data-path-to-node="6,0,0"><strong data-path-to-node="6,0,0" data-index-in-node="0">High-Velocity Work & Client Exposure:</strong> We work close to the technology, teams and roadmaps that move real outcomes. Direct engagement with U.S. client teams and roadmaps.</p> </li> <li> <p data-path-to-node="6,1,0"><strong data-path-to-node="6,1,0" data-index-in-node="0">Career Continuity & Long-Term Opportunity:</strong> Your career here can outlast any single project. Continuous multi-project pipeline; long-tenure CodeRoaders.</p> </li> <li> <p data-path-to-node="6,2,0"><strong data-path-to-node="6,2,0" data-index-in-node="0">Engineering Autonomy & Technical Mastery:</strong> We invest in the skills that shape what's next. Agentic AI tools and training, Coursera Enterprise, Studio practice labs, L1-L7 Career Framework.</p> </li> <li> <p data-path-to-node="6,3,0"><strong data-path-to-node="6,3,0" data-index-in-node="0">High-Trust Employee Experience:</strong> You grow in an environment built on trust, transparency and recognition. High-touch onboarding, transparent leadership communication, community recognition, psychological safety.</p> </li> </ul> <h3 data-path-to-node="7">Key Responsibilities</h3> <ul data-path-to-node="8"> <li> <p data-path-to-node="8,0,0"><strong data-path-to-node="8,0,0" data-index-in-node="0">Design and implement modern semantic models</strong> (facts, dimensions, and metrics stores using tools like dbt) to abstract complex operational databases for AI querying and analytical consumption.</p> </li> <li> <p data-path-to-node="8,1,0"><strong data-path-to-node="8,1,0" data-index-in-node="0">Build curated, high-performance analytical views</strong> and production ELT/ETL pipelines that streamline data retrieval, enhance freshness, and minimize redundant database queries.</p> </li> <li> <p data-path-to-node="8,2,0"><strong data-path-to-node="8,2,0" data-index-in-node="0">Optimize database query performance</strong>, indexing, and schema definitions for low-latency analytical workloads through systematic query log analysis.</p> </li> <li> <p data-path-to-node="8,3,0"><strong data-path-to-node="8,3,0" data-index-in-node="0">Implement granular data governance frameworks</strong>, including Role-Based Access Control (RBAC), Row-Level Security (RLS), and dynamic data masking for PII protection.</p> </li> <li> <p data-path-to-node="8,4,0"><strong data-path-to-node="8,4,0" data-index-in-node="0">Establish comprehensive data quality</strong>, pipeline monitoring, and anonymization standards across all analytical layers.</p> </li> <li> <p data-path-to-node="8,5,0"><strong data-path-to-node="8,5,0" data-index-in-node="0">Collaborate with cross-functional AI engineering teams</strong> to align data structures with the operational requirements of RAG architectures and Agentic AI workflows.</p> </li> </ul> <h3 data-path-to-node="9">What You Bring</h3> <ul data-path-to-node="10"> <li> <p data-path-to-node="10,0,0"><strong data-path-to-node="10,0,0" data-index-in-node="0">3+ years of dedicated Data Engineering experience</strong> with strong, production-grade command of SQL across Azure SQL, PostgreSQL, or modern cloud data warehouses.</p> </li> <li> <p data-path-to-node="10,1,0"><strong data-path-to-node="10,1,0" data-index-in-node="0">Proven production track record</strong> building and maintaining resilient ETL/ELT data pipelines and optimized analytical structures.</p> </li> <li> <p data-path-to-node="10,2,0"><strong data-path-to-node="10,2,0" data-index-in-node="0">Demonstrated experience in database security</strong>, including role-based permissions (RBAC), Row-Level Security (RLS), and dynamic data masking for PII protection.</p> </li> <li> <p data-path-to-node="10,3,0"><strong data-path-to-node="10,3,0" data-index-in-node="0">Hands-on expertise tuning complex queries</strong> for low-latency analytical workloads alongside a strong foundation in dimensional modeling (Kimball) and semantic layers (dbt).</p> </li> <li> <p data-path-to-node="10,4,0"><strong data-path-to-node="10,4,0" data-index-in-node="0">Strong ownership mindset</strong> and proactive problem-solving abilities within collaborative nearshore team