Operations Engineer – Data Operations

Engagement Type: [Full-Time / Contractor]

 

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

• Investigate & Resolve Data Incidents: Execute advanced SQL queries across MS SQL Server to trace missing, duplicate, or inconsistent transactional data, conducting end-to-end root-cause analysis.

• Trace & Monitor Data Pipelines: Oversee pipeline runs and scheduled orchestration jobs (Airflow, Azure Data Factory, SQL Agent), identifying bottlenecks and resolving failures across ETL/ELT pipelines and data warehouse structures.

• Support & Optimize BI Dashboards: Maintain and troubleshoot Tableau dashboards, data extracts, and reporting sources to resolve data discrepancies, refresh failures, and query performance degradation.

• Drive Data Governance & Change Management: Safely perform controlled data corrections, maintaining strict data integrity standards, runbooks, and SQL best practices across database workloads.

• Automate Operational Workflows: Write Python or PowerShell scripts to automate recurring data investigation workflows, utilizing modern AI tools to accelerate incident triage and resolution.

• Collaborate Across Engineering & Support Teams: Manage and resolve tickets in ITSM platforms (Jira Service Management), serving as the primary data specialist bridging business users, software developers, and IT Operations.

What You Bring

• Core Experience: Solid technical background in data operations, database support, or data pipeline troubleshooting within enterprise environments.

• Database & Querying Mastery: Advanced, hands-on SQL skills (complex CTEs, window functions, aggregations, and performance tuning) using tools like SSMS or Azure Data Studio, primarily with MS SQL Server (PostgreSQL is a plus).

• Pipeline & Warehousing Knowledge: Deep understanding of dimensional data warehousing concepts (fact/dimension tables, SCDs) and hands-on experience debugging ETL/ELT pipeline workflows.

• BI & Automation Stack: Experience supporting Tableau (or similar BI tools) alongside scripting proficiency in Python or PowerShell for analysis and task automation.

• Operational & ITSM Workflows: Practical familiarity with ITSM processes, on-call escalations, ticket management (Jira Service Management), and orchestration platforms (Airflow / ADF).

• Communication & Problem Solving: Fluent English (written and verbal) with an analytical mindset, meticulous attention to detail, and the ability to explain complex data issues clearly to non-technical stakeholders.

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!