Loading...
 

ETL Developer

Makati City, Philippines Office
Information Technology
Job Requisition Number:  APIT86

Sophos is a worldwide leader in next-generation cybersecurity, protecting more than 500,000 organizations and millions of consumers in more than 150 countries from today’s most advanced cyberthreats. Powered by threat intelligence, AI and machine learning from SophosLabs and SophosAI, Sophos delivers a broad portfolio of advanced products and services to secure users, networks and endpoints against ransomware, malware, exploits, phishing and the wide range of other cyberattacks. Sophos provides a single integrated cloud-based management console, Sophos Central – the centerpiece of an adaptive cybersecurity ecosystem that features a centralized data lake that leverages a rich set of open APIs available to customers, partners, developers, and other cybersecurity vendors. Sophos sells its products and services through reseller partners and managed service providers (MSPs) worldwide. Sophos has major hubs around the globe. More information is available at www.sophos.com

 

 

Role Summary

 

You 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 Informatica 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, Hadoop, 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 

 

Desirable:

  • Experience with developing and testing  APIs
  • Experience with PowerBI and/or Tableau
  • 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

 

 

What’s Great About Sophos?

  • Our people are what makes Sophos special – we demonstrate shared vision, talent, innovation, and creativity, all of which are accompanied by a great sense of fun and team spirit.
  • Employee-led diversity and inclusion groups that build community within Sophos and provide internal education and advocacy (eg. Sophos Women in Tech group to improve gender parity, encourage gender-balanced leadership, and support career progression at Sophos)
  • Sophos Environment Network and employee challenges to contribute to sustainability and reduce our environmental footprint
  • Annual commitment to charity and fundraising across our global sites and volunteer days for employees to give back to local communities
  • Global trivia competitions to keep our minds sharp
  • Global Mental Health days off work for all Sophos to help employees relax and recharge
  • Monthly employee wellbeing webinars and training to support employee health and wellbeing
  • Employee rewards and thanks, such as our free annual subscription to Calm

 

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 that 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 dataprotection@sophos.com.

At Sophos, we want every organization to be protected by innovative, next-generation IT security, even those who don't have a huge IT staff. We protect organizations of all sizes, all around the world by making enterprise-grade security that is simple to deploy, manage, and use. It is our passion, and something we are truly proud of.


Job Segment: Developer, Database, SQL, Cloud, Information Technology, Technology