Match score not available

Data Engineer 1

extra holidays - fully flexible
Remote: 
Full Remote
Contract: 
Experience: 
Junior (1-2 years)
Work from: 

Offer summary

Qualifications:

B.S. degree in Computer Science or related field, 1-2 years of IT experience with ETL tools, Proficient in SQL and industry databases, Familiarity with system modeling tools, Ability to work in a cross-functional environment.

Key responsabilities:

  • Develop and orchestrate ETL transformations using Matillion
  • Write complex SQL queries for data manipulation
  • Coordinate between Production, Development, and Sandbox environments
  • Collaborate with the DevOps team for releases and documentation
  • Provide support for incidents and bug fixes
Sophos logo
Sophos Large https://www.sophos.com/
1001 - 5000 Employees
See more Sophos offers

Job description

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.

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

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

    Required profile

    Experience

    Level of experience: Junior (1-2 years)
    Spoken language(s):
    EnglishEnglish
    Check out the description to know which languages are mandatory.

    Other Skills

    • Problem Solving
    • Time Management
    • Teamwork
    • Verbal Communication Skills

    Data Engineer Related jobs