Data Engineer - Support Project L2

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 data reporting tools, dashboards, or data refresh processes. Experience with Tableau or similar BI platforms is an advantage.

• Scripting & Automation: Basic experience with Python, PowerShell, or other scripting tools is a plus. A proactive approach to leveraging AI-assisted coding and automation tools to simplify workflows, reduce repetitive work, and solve operational problems is especially desirable.

• AI-Driven Problem Solving: A proactive mindset toward adopting AI tools to investigate issues, automate repetitive tasks, improve troubleshooting, and identify opportunities to make daily operations more efficient. Curiosity, initiative, and a willingness to experiment with emerging AI technologies are highly valued.

• Operational Mindset & Problem Solving: Strong analytical and troubleshooting skills, attention to detail, and a proactive approach to identifying and resolving issues. Comfortable following documented procedures, managing tickets, and escalating issues when necessary.

• Communication & Collaboration: Good English communication skills, both written and verbal, with the ability to document findings, communicate technical issues clearly, and collaborate effectively within a small, cross-functional team.

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!