Data Engineer 2 (Remote, EMEA Shift)

Sophos

  • Philippines
  • Permanent
  • Full-time
  • 28 days ago
About UsSophos is a global leader and innovator of advanced security solutions for defeating cyberattacks. The company acquired Secureworks in February 2025, bringing together two pioneers that have redefined the cybersecurity industry with their innovative, native AI-optimized services, technologies and products. Sophos is now the largest pure-play Managed Detection and Response (MDR) provider, supporting more than 28,000 organizations. In addition to MDR and other services, Sophos' complete portfolio includes industry-leading endpoint, network, email, and cloud security that interoperate and adapt to defend through the Sophos Central platform. Secureworks provides the innovative, market-leading Taegis XDR/MDR, identity threat detection and response (ITDR), next-gen SIEM capabilities, managed risk, and a comprehensive set of advisory services. Sophos sells all these solutions through reseller partners, Managed Service Providers (MSPs) and Managed Security Service Providers (MSSPs) worldwide, defending more than 600,000 organizations worldwide from phishing, ransomware, data theft, other every day and state-sponsored cybercrimes. The solutions are powered by historical and real-time threat intelligence from Sophos X-Ops and the newly added Counter Threat Unit (CTU). Sophos is headquartered in Oxford, U.K. More information is available at www.sophos.com.Role SummaryYou will be responsible for delivering and supporting data integrations from internal and external sources into the data warehouse technical stack, ensuring accurate data delivery to systems. You will be required to build new data integrations (ETL components) and make changes to existing software and will be a key role in designing and building a strong Enterprise Data warehouse.What You Will Do
  • Understanding business and data requirements, defining solution approach, designing and implementing the ETL components.
  • Demonstrated working knowledge of various business process and system modelling tools including: Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, and Use Case Scenarios.
  • Develop Matillion ETL scripts and ETL orchestrations as required.
  • Ensure the team is following best practices of ETL development.
  • Leverage monitoring tools to track status of ETL Pipelines for performance and completion.
  • Develop and write complex SQL queries and stored procedures to extract and insert data into and from the Datawarehouse.
  • Engage with Business Analyst & Technical Architects to clarify business requirements and offer recommendations for improvements.
  • Contribute to defining a scalable data warehouse architecture
  • Responsible for the coordination of the production, development and sandbox environments.
  • Responsible for coordinating releases with DevOps team and prepare the required documentation related to release.
  • Participate in peer code reviews.
  • Provide coaching and guidance to junior team members on technologies and processes
  • Provide support and recommendation for testing and UAT for work being delivered
  • Provide out of hours support as requested for incidents
  • Participate in routine maintenance, performance tuning and support of ETL and the DW Environment.
What You Will Bring
  • Essential:
  • 2+ years of IT experience required in working with ETL in an enterprise environment.
  • Knowledge in ETL Design methodologies including best practices, performance tuning, architecture, monitoring and alerting
  • Knowledge of at least one ETL tool (SSIS, Informatica, Matillion, Talend, etc.)
  • Experience with relational and dimensional data modelling and ability to represent data using standard modelling techniques
  • Proficient with SQL and stored procedures.
  • Experience in working with at least one of these warehouse technologies such as (SQL, Snowflake,AWS RedShift)
  • Knowledge of the processes when working on pre-release environments, moving changes between environments
  • Ability to deliver work to schedule (capable to self-manage workload and priority effectively).
  • Ability to work in a cross-functional team environment.
  • Passionate about complex data structures and problem solving
  • Ability to pick up new data tools and concepts quickly
  • Excellent written and verbal English communication skills
  • Amenable to work remotely
  • Amenable to work on EMEA Shift (4PM-1AM PHT)
Desirable: * Experience with developing and testing APIs
  • Experience with Snowflake and/or columnar data stores
  • Experience with PowerBI
  • Experience designing and managing end-to-end business reporting, from data sourcing and mapping, through to the production and delivery of reports
  • Experience defining, implementing, and building products and roll-out strategy for Data Quality, MDM and Data Governance
#LI-Remote#JE#B1Ready 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 wellbeingOur Commitment To YouWe'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 ProtectionIf 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. For more information on Sophos' data protection practices, please consult our Privacy Policy

Sophos