Operations Engineer – Data Operations Junior/Mid

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 Issues: Identify, investigate, and troubleshoot missing, duplicate, inconsistent, or unexpected data in operational systems. Use SQL queries to trace issues, identify root causes, and help implement appropriate resolutions.

Monitor Data Pipelines & Scheduled Jobs: Monitor data processing workflows, scheduled jobs, and pipeline executions. Investigate failures, identify bottlenecks, and coordinate troubleshooting to help maintain reliable data flows.

Support Data Reporting & Refresh Processes: Troubleshoot data discrepancies, failed refreshes, and issues affecting reporting tools and dashboards, working with the appropriate teams to restore accurate and reliable data.

Maintain Data Integrity: Perform approved data corrections and operational changes while following established procedures, documentation, and data integrity standards.

Automate & Improve Operational Workflows: Identify opportunities to streamline recurring investigations, reduce manual effort, and improve operational efficiency through scripting, automation, and AI-assisted tools. Proactively experiment with AI solutions to accelerate troubleshooting and find smarter ways to solve everyday problems.

Collaborate Within the Infrastructure Team: Work as part of a three-person infrastructure team to investigate and resolve data-related operational issues. Track incidents and resolutions through ticketing systems and collaborate with developers, IT Operations, and business stakeholders as needed.

What You Bring

Relevant Experience: 1–3 years of professional experience in IT Operations, Data Operations, application support, database support, or a similar technical troubleshooting role.

SQL & Database Fundamentals: Hands-on experience writing SQL queries to investigate data issues, validate records, identify discrepancies, and troubleshoot problems. Familiarity with relational databases, particularly Microsoft SQL Server, is preferred.

Data Processing & Pipeline Knowledge: Basic understanding of data pipelines, ETL/ELT processes, scheduled jobs, and how data moves between operational systems and reporting environments. Exposure to tools such as Azure Data Factory, Airflow, or SQL Server Agent is a plus.

Reporting & Troubleshooting: Familiarity with da