Application Support – Data Engineer (+3 Years Experience)

Role Overview

As a Data Engineer at Valleysoft, you will be responsible for designing, building, and managing scalable data pipelines and architectures that enable data-driven decision making. You will collaborate with data scientists, analysts, and business stakeholders to ensure the availability, reliability, and quality of data.

What You Will Do

Develop, construct, test, and maintain data architectures such as databases and large-scale processing systems. Provide second and third-line application support for the enterprise data platform, covering data warehouses, data marts, ETL pipelines, and data integration layers across production and non-production environments.

Why It Might Be a Fit

You will have the opportunity to work with cross-functional teams, investigate root causes of recurring data issues, and implement permanent fixes and preventive measures. You will also have the chance to maintain accurate and up-to-date support documentation and participate in change advisory board (CAB) reviews.

Requirements

• Hands-on experience supporting ETL platforms such as Informatica PowerCenter, IBM DataStage, Talend, or equivalent enterprise integration tools.
• Strong SQL skills (Oracle, SQL Server, or DB2) — capable of writing diagnostic queries, tracing data lineage manually, and performing targeted data fixes under change control.
• Solid understanding of data warehouse architecture: ODS, staging layers, data marts, and EDW — sufficient to trace and isolate issues across pipeline stages.
• Experience with enterprise job scheduling tools such as Control-M, TWS, or Autosys — managing job dependencies, calendars, and failure alerts.
• Familiarity with Unix/Linux shell scripting for log analysis, file transfer monitoring, and lightweight automation of support tasks.
• Understanding of database performance concepts: execution plans, index usage, partition pruning, and statistics — to diagnose slow-running jobs and queries.
• Exposure to data quality monitoring frameworks and the ability to validate pipeline outputs against expected row counts, aggregates, and business rules.
• Experience with ITSM platforms (ServiceNow, Remedy, or equivalent) for incident logging, change requests, and problem management workflows.
• Familiarity with cloud data platform components (Azure Data Factory, AWS Glue, Snowflake) is a plus.

Benefits

• Private Health Insurance
• Training & Development