Operations Engineer – Data Operations

CodeRoad; United States; Remote; USD 120,000 - 160,000; Full time

Benefits offered by this job

Health insurance assistance program

Holidays Off & Paid Time Off

Job summary

CodeRoad is seeking a data operations professional to join our remote team serving US-based clients. You will investigate data incidents, monitor pipelines, and optimize BI dashboards while ensuring data governance and scalable automation.

You'll work with SQL Server, Tableau, Python or PowerShell, Airflow/ADF, Jira Service Management, and ITSM workflows to deliver reliable data solutions across ETL/ELT stacks. Fluent English and strong problem-solving are essential for cross-team collaboration.

Qualifications

• Solid technical background in data operations and data pipeline troubleshooting.
• Advanced SQL skills with MS SQL Server; SSMS/Azure Data Studio usage.
• Deep understanding of ETL/ELT pipelines and data warehousing concepts.
• Experience with Tableau and scripting in Python or PowerShell for automation.
• Familiarity with ITSM workflows and Jira Service Management.

Responsibilities

• Investigate & Resolve Data Incidents: execute advanced SQL queries to trace data issues and perform root-cause analysis.
• Trace & Monitor Data Pipelines: oversee pipelines (Airflow, ADF, SQL Agent) and resolve failures in ETL/ELT processes.
• Support & Optimize BI Dashboards: maintain Tableau dashboards and data sources, fix refresh failures and improve performance.
• Drive Data Governance & Change Management: perform controlled data corrections and maintain best practices.
• Automate Operational Workflows: write Python/PowerShell scripts to automate recurring investigations.
• Collaborate Across Engineering & Support Teams: manage tickets in Jira Service Management and coordinate with IT Operations.

Skills

Fluent English

Data operations

Analytical mindset

Communication

Problem solving

Tools

MS SQL Server

SSMS

Azure Data Studio

Tableau

Python

PowerShell

Jira Service Management

Airflow

Azure Data Factory

SQL Agent

Job description

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.

This role is 100% remote and LATAM-only.