Operations Etl Engineer

Job Description

Operations ETL Engineer

San Mateo, CA

We have a superb opportunity for an Operations ETL Engineer to join our Data Strategy and Operations team in San Mateo, CA! This role will undertake ETL Operational duties as well as pick up support around alerting, carrying out changes through scripting or use of Ansible on the AWS Cloud Infrastructure.

The ETL Engineer is required to work within the DevOps team with the successful applicant responsible for the operations and support of the Business Intelligence platform. They will be required to fit into a highly skilled team and work with limited supervision, under their own initiative.

The role is based in our San Mateo office, reporting to our Technical Engineering Manager, and offers significant options for working remotely! This team provides business intelligence services for various global business units associated with Sony Interactive Entertainment.

Key Duties and Tasks:
• Provide 1st/2nd line support for the Production data processing platform, including response to and resolution of any failures
• Undertake production releases into the platform
• Ability to identify and automate manual tasks where you can make time or cost savings
• Conduct code peer reviews with particular emphasis on operational aspects
• Configuration management of code, covering versioning, deployments and building of tags
• Investigation, management and prioritization of any incidents or queries raised
• Perform impact analysis, identifying ways to make operational improvements and make code changes to improve resilience or efficiency
• Liaison with data providers
• Communication with end users and explanation of technical terms and concepts
• Work with Scrum Masters, Developers and Product Owners to ensure any failures are communicated in a concise manner
• Acting as the first line advisory and support for end users on 'How-to' questions

Requirements:
• 2+ years experience in UNIX, including shell scripting, admin and utilities
• Skilled in scripting (Python, Bash)
• Skilled in Linux and comfortable in using command line
• Understand ETL concepts with 2-3 years demonstrable experience with an ETL tool (Ab-Initio preferred)
• Demonstrable experience working on and supporting large-scale complex data processing platforms
• Experience in working with SQL
• Undertaking Production environment releases
• Strong troubleshooting and problem-solving ability
• Interpersonal skills including presentation, negotiating, conflict resolution, etc
• Strong communication skills. It is vital that the successful candidate can explain complex technical issues in non-technical terms to business partners
• Communicating effectively to business partners with incident resolution details
• Proven abilities to work creatively and analytical in a problem-solving environment
• Experience in a similar role, with proven expertise gained in complicated, business critical projects
• Strong can-do attitude with an appetite for learning and developing further
• English: Fluent

Desirable:
• Understanding of other data processing technologies and knowledge of data warehouse appliances, e.g. Snowflake
• Experience using AWS Cloud technology
• Knowledge of business intelligence reporting suites
• Appreciation of emerging and newer technologies
• 1-2 years proven experience in using Airflow
• Other programming languages

#LI-GD1

Jobcode: Reference SBJ-gpj0kx-18-218-168-16-42 in your application.