[Hiring] Operations Engineer @CodeRoad

Role Description

CodeRoad is seeking a data operations specialist to join our team. The role involves:

• Investigating & Resolving Data Incidents:
  • Execute advanced SQL queries across MS SQL Server to trace missing, duplicate, or inconsistent transactional data.
  • Conduct end-to-end root-cause analysis.
• Tracing & Monitoring Data Pipelines:
  • Oversee pipeline runs and scheduled orchestration jobs (Airflow, Azure Data Factory, SQL Agent).
  • Identify bottlenecks and resolve failures across ETL/ELT pipelines and data warehouse structures.
• Supporting & Optimizing BI Dashboards:
  • Maintain and troubleshoot Tableau dashboards, data extracts, and reporting sources.
  • Resolve data discrepancies, refresh failures, and query performance degradation.
• Driving Data Governance & Change Management:
  • Safely perform controlled data corrections, maintaining strict data integrity standards.
  • Follow runbooks and SQL best practices across database workloads.
• Automating Operational Workflows:
  • Write Python or PowerShell scripts to automate recurring data investigation workflows.
  • Utilize modern AI tools to accelerate incident triage and resolution.
• Collaborating Across Engineering & Support Teams:
  • Manage and resolve tickets in ITSM platforms (Jira Service Management).
  • Serve as the primary data specialist bridging business users, software developers, and IT Operations.

Qualifications

• Solid technical background in data operations, database support, or data pipeline troubleshooting within enterprise environments.
• 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).
• Deep understanding of dimensional data warehousing concepts (fact/dimension tables, SCDs) and hands-on experience debugging ETL/ELT pipeline workflows.
• Experience supporting Tableau (or similar BI tools) alongside scripting proficiency in Python or PowerShell for analysis and task automation.
• Practical familiarity with ITSM processes, on-call escalations, ticket management (Jira Service Management), and orchestration platforms (Airflow / ADF).
• 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.

Requirements

• Core Experience: Solid technical background in data operations, database support, or data pipeline troubleshooting.
• Database & Querying Mastery: Advanced SQL skills using MS SQL Server.
• Pipeline & Warehousing Knowledge: Understanding of dimensional data warehousing concepts.
• BI & Automation Stack: Experience with Tableau and scripting in Python or PowerShell.
• Operational & ITSM Workflows: Familiarity with ITSM processes and ticket management.
• Communication & Problem Solving: Strong communication skills and analytical mindset.

Benefits

• 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.