Loading...

Senior ETL / Data Integration Lead Developer

Makati City, National Capital Region (NCR), PH, 1225

Information Technology

Sophos Overview – Cybersecurity Evolved


Sophos evolves to meet every new challenge, protecting more than 400,000 organizations of all sizes in more than 150 countries from today’s most advanced cyberthreats. Powered by SophosLabs, our cloud-native and AI-enhanced solutions are able to adapt and evolve to secure endpoints and networks against never-before-seen cybercriminal tactics and techniques. Managed through our award-winning, cloud-based platform, Sophos Central, our best-of-breed products work together through our unique Synchronized Security system to share threat intelligence and respond to evolving threats. The Sophos suite of products secures networks and endpoints against automated and active-adversary breaches, ransomware, malware, exploits, data exfiltration, phishing, and more. 
 

Job Purpose

 

We are looking for an energetic Senior ETL/Data Integration Lead Developer who will be responsible for building ETL orchestrations, pipelines, jobs, components and database schemas within Snowflake databases and Matillion ETL to answer business user stories around reporting and analytics..

 

Main Duties

 

  • Responsible for collecting business requirements and design documentation from architects and develop reliable ETL pipelines using Matillion.
  • Leverage monitoring tools to track status of ETL Pipelines for performance and completion.
  • Responsible for the transition of documentation, security, development and testing of all procedures in the EDW.
  • Responsible to train new staff on ETL architecture, ETL standards and ETL documentation.
  • 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.
  • Execute unit tests and validating expected results; iterating until test conditions have passed.
  • Participate in peer code reviews.
  • Utilize test automation tools and frameworks to aid testing at scale, where possible.
  • Participate in routine maintenance, performance tuning and support of ETL and the DW Environment.


Skills & Experience

 

Essential:

 

  • At least 5 years’ experience in ETL that involves the ff
  • Enterprise level ETL development, using 1 to 2 tools like Informatica OR Pentaho Kettle OR Microsoft SSIS OR Talend OR Matillion OR AWS Glue etc (Matillion is highly advantageous
  • Enterprise class relational data warehouse solutions such as Snowflake or Postgres or Microsoft SQL Server or Oracle etc.  (Snowflake is highly advantageous)
  • 2+ years of experience with 1 to 2 Enterprise level Data Visualization Tools such as Power BI OR Tableau OR  MicroStrategy OR Pentaho BI etc.
  • Experience with relational and dimensional data modeling
  • Proficient with SQL and stored procedures.
  • Experience building DataWarehouse, data marts with various source systems like SAP, SFDC, Eloqua etc.
  • Experience in working under a structured project management framework.
  • Very fast learner – able to assimilate new technical skills/systems in a very short time.
  • Ability to deliver work to schedule (capable to self-manage workload and priority effectively).
  • Ability to work in a cross-functional team environment.
  • Excellent problem-solving skills
  • Good leadership capabilities

 

Desirable:

 

  • Team Lead experience
  • Experience implementing Master Data Management(MDM) solutions for contact, products, partners etc
  • Experience using and implementing Data quality framework & solutions
  • Atlassian tools: Jira, Wiki
  • Working with GIT based Source Control.


Equal Opportunities


Sophos is committed to equality opportunity in all areas of its work. All qualified applicants will be treated in a fair and equal manner and in accordance with the law regardless of gender, marital status, race, religion, colour, age, disability or sexual orientation. 
If you choose to explore this 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: Database, ERP, Oracle, SQL, SAP, Technology