A complete application in a minute
Tailored resume and cover letter, ready to send.
Private Advertiser is seeking an EDW Support and Data Operations professional to manage incidents, investigate data issues, and coordinate with integration and platform teams. The role focuses on data governance, security and continuous improvement across the data environment.
You will work with SQL, dbt models and Airflow to fix defects, reprocess data and ensure data quality, while following ITIL practices and standard escalation procedures.
Join the team as an EDW Support and Data Operations professional, helping ensure reliable, accurate and timely enterprise data. You will manage incidents and service requests, investigate data and business-logic issues, resolve defects in EDW code, and coordinate with integration and platform teams to deliver effective outcomes. The role also contributes to data governance, security, continuous improvement and stakeholder communication across the data environment.
Receive, classify and prioritise incidents, problems and service requests in ServiceNow, following ITIL practices and agreed SLAs.
Keep users informed through clear status updates, set expectations on resolution times and confirm closure with requesters.
Escalate critical incidents promptly and participate in hypercare and major-event support.
Analyse EDW business logic by reading and understanding SQL, dbt models and Airflow DAGs, and trace data lineage across layers.
Identify the sources of incorrect, missing, duplicated or late data, report discrepancies, and validate data quality and freshness.
Perform root cause analysis, document findings, define corrective and preventive actions, and maintain RCA reports, known-error records, runbooks and knowledge articles.
Fix defects in EDW code, including SQL, dbt models, macros, tests and Airflow DAG logic such as dependencies, schedules and parameters.
Follow Git workflow, code review, testing and release processes, and support production deployments of fixes.
Reprocess or backfill affected data where required and verify results with users.
Determine whether issues belong to EDW logic, the integration chain or the platform, and hand them over to the appropriate team with logs, evidence and impact details.
Coordinate with the Data Integration & Pipeline team on pipeline, connector, streaming and API issues.
Raise cloud platform, Snowflake, PostgreSQL and platform upgrade issues with the Platform team.
Organise and lead cross-team calls for complex or high-priority issues, track actions and own tickets through to closure.
Capture enhancement requests and recurring problems, assess their impact and prioritise them with stakeholders.
Implement enhancements within EDW logic, including SQL, dbt and Airflow DAG logic, and route integration or platform enhancements to the relevant teams.
Coordinate change requests through the project process, including impacts on effort, plans and release dates.
Improve runbooks, SOPs and routine checks, and report ticket trends, SLA performance and improvement results.
Follow access control, data protection and API security requirements, and handle Personally Identifiable Information in line with security and compliance requirements.
Participate in daily stand-ups, weekly operational reviews, technical reviews and Agile delivery activities.
Collaborate with business stakeholders, technical teams and external service providers.
At least 3 years of relevant experience in data engineering, EDW or data warehouse support, application support or similar technical operations roles.
Strong SQL skills, including complex queries, debugging and performance analysis, with experience using Snowflake or a similar cloud data warehouse.
Hands-on experience with dbt models, tests and macros, and the ability to read, analyse and modify Airflow DAGs.
Working knowledge of Git and basic Python.
Proven experience in production support, incident and problem management, and root cause analysis.
Experience with ServiceNow or similar ITSM tools and ITIL practices.
Ability to analyse data lineage and business logic across data layers and validate data quality.
Strong communication and coordination skills, with the ability to lead cross-team issue resolution and manage stakeholders.
Fluent spoken and written English as the working language.
Understanding of data governance, security, access management and data protection principles.
Ability to work independently, take ownership and contribute to continuous improvement.
Your application will include the following questions: