Data Engineer 2

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.

• 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
• Coordinate production, development and sandbox environments
• Coordinate 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 recommendations 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

• 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 processes when working on pre-release environments, moving changes between environments
• Ability to deliver work to schedule (self-manage workload and priorities)
• 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)

• 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

At Sophos, we believe in the power of diverse perspectives to fuel innovation. We encourage you to apply, even if you don't match every box in a job description. Your unique experiences and skills might be exactly what we need to enhance our team.

• Sophos operates a remote-first working model. Some roles may require a hybrid approach. Applicants must have legal authorization to work in the jurisdiction where the position is posted, without requiring employer sponsorship.

• Our people – we innovate and create, with a 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 and monthly wellbeing webinars and training to support employee health and wellbeing

If you share your CV or other personal details with Sophos, these details will be held for 12 months in accordance with our Privacy Policy and used by our recruitment team to contact you regarding this or other opportunities at Sophos. You can request deletion or updates at any time per the Privacy Policy.