Data Engineer 1

About Us

Sophos is a global leader and innovator of advanced security solutions that defeat cyberattacks, including Managed Detection and Response (MDR) and incident response services and a broad portfolio of endpoint, network, email, and cloud security technologies. As one of the largest pure-play cybersecurity providers, Sophos defends more than 600,000 organizations and more than 100 million users worldwide from active adversaries, ransomware, phishing, malware, and more. Sophos’ services and products connect through the Sophos Central management console and are powered by Sophos X-Ops, the company’s cross-domain threat intelligence unit. Sophos X-Ops intelligence optimizes the entire Sophos Adaptive Cybersecurity Ecosystem, which includes a centralized data lake that leverages a rich set of open APIs available to customers, partners, developers, and other cybersecurity and information technology vendors. Sophos provides cybersecurity-as-a-service to organizations needing fully managed security solutions. Customers can also manage their cybersecurity directly with Sophos’ security operations platform or use a hybrid approach by supplementing their in-house teams with Sophos’ services, including threat hunting and remediation. Sophos sells through reseller partners and managed service providers (MSPs) worldwide. Sophos is headquartered in Oxford, U.K. More information is available at www.sophos.com.

Role Summary

As a data engineer, you will be expected to understand business and data requirements, and support development by implementing ETL (Extract Transform Load) / ELT (Extract Load Transform) jobs/components and pipelines.

*****Please note this role is based in the Philippines only******

What You Will Do

• Familiarity with system modelling tools including Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, and Use Case Scenarios
• Develop Matillion ETL transformations and orchestrations as required
• Develop and write simple to complex SQL queries and stored procedures through Snowflake to extract, transform and load data into and from the Data warehouse
• Work closely with the team to deliver new data requirements and maintenance, data analysis and reporting solutions, and possible continuous improvement initiatives (e.g performance tuning) within the team scope
• Responsible for the coordination of the Production, Development and Sandbox environments
• Accountable for coordinating releases with the DevOps team and helping create and maintain technical and system documentation related to release/changes
• Provide assistance to fix reported bugs and out-of-hours support as requested as part of incidents management

What You Will Bring - Essential

• B.S. degree in Computer Science or a related technical field, or equivalent practical experience
• 1 to 2 years of IT experience required in working with ETL tools (e.g. Matillion, Informatica, SSIS, Talend, etc.)
• Understanding and familiarity of knowledge in ETL design, concept and methodologies such as relational and dimensional data models
• Proficient with basic SQL using any of industry databases (e.g. Snowflake, Oracle, MSSQL, etc.)
• Knowledge of the processes when working on pre-release environments, moving changes between environments
• Ability to deliver work to schedule and under pressure (capable to self-manage workload and prioritize effectively)
• Ability to work in a cross-functional team environment
• Team player and proactive in nature
• Passionate to learn about complex data structures and problem-solving
• Ability to pick up new data tools and concepts quickly
• Excellent written and verbal English communication skills

What You Will Bring - Desirable

• Familiarity and understanding of API development
• Familiarity with AWS (EC2, IAM, etc.)
• Familiarity with Snowflake and/or columnar data stores
• Familiarity on Jira and Confluence
• Basic experience with PowerBI

Ready to Join Us?

At Sophos, we believe in the power of diverse perspectives to fuel innovation. Research shows that candidates sometimes hesitate to apply if they don't check every box in a job description. We challenge that notion. Your unique experiences and skills might be exactly what we need to enhance our team. Don't let a checklist hold you back – we encourage you to apply.

What's Great About Sophos?

· Sophos operates a remote-first working model, making remote work the primary option for most employees. However, some roles may necessitate a hybrid approach. Please refer to the location details in our job postings for further information.

· Our people – we innovate and create, all of which are accompanied by a great sense of fun and team spirit

· Employee-led diversity and inclusion networks that build community and provide education and advocacy

· Annual charity and fundraising initiatives and volunteer days for employees to support local communities

· Global employee sustainability initiatives to reduce our environmental footprint

· Global fitness and trivia competitions to keep our bodies and minds sharp

· Global wellbeing days for employees to relax and recharge 

· Monthly wellbeing webinars and training to support employee health and wellbeing

Our Commitment To You

We’re proud of the diverse and inclusive environment we have at Sophos, and we’re committed to ensuring equality of opportunity. We believe that diversity, combined with excellence, builds a better Sophos, so we encourage applicants who can contribute to the diversity of our team. All applicants will be treated in a fair and equal manner and in accordance with the law regardless of gender, sex, gender reassignment, marital status, race, religion or belief, color, age, military veteran status, disability, pregnancy, maternity or sexual orientation. We want to give you every opportunity to show us your best self, so if there are any adjustments we could make to the recruitment and selection process to support you, please let us know. 

Data Protection

If you choose to explore an opportunity, and subsequently share your CV or other personal details with Sophos, these details will be held by Sophos for 12 months in accordance with our Privacy Policy and used by our recruitment team to contact you regarding this or other relevant opportunities at Sophos. If you would like Sophos to delete or update your details at any time, please follow the steps set out in the Privacy Policy describing your individual rights. If you have any questions about Sophos’ data protection practices, please contact [email protected].