Senior Data Engineer

Overview

Senior Data Engineer role driving the design, delivery, support and continuous improvement of enterprise data integrations and data warehouse solutions, acting as technical subject matter expert and mentoring other engineers.

What you'll do

• Own the technical design and end-to-end delivery of complex data engineering epics, from requirements analysis and solution design through implementation, testing, release, and production support.
• Act as a technical subject matter expert for the data platforms, integrations, and warehouse areas owned by the team.
• Design scalable ETL/ELT solutions and produce supporting technical documentation, including data flows, dimensional models, interface specifications, operational runbooks, and support procedures.
• Develop and optimize Matillion ETL components and orchestrations, complex SQL, stored procedures, and reusable data transformation frameworks.
• Own and continuously improve the data engineering codebase, development practices, coding standards, observability, quality controls, and maintainability.
• Lead technical analysis, build-design sessions, code reviews, and solution reviews with Business Analysts, Technical Architects, business stakeholders, and cross-functional engineering teams.
• Assess dependencies across connected systems and perform impact, scalability, operational, security, and delivery risk analysis for proposed changes.
• Ensure testing coverage is appropriate across unit, system, regression, integration, performance, and user acceptance testing; identify gaps and drive corrective actions.
• Provide advanced troubleshooting and root-cause analysis for complex data pipeline, warehouse, integration, data quality, and performance issues.
• Coordinate releases across development, sandbox, test, and production environments in partnership with DevOps and relevant application teams.
• Use monitoring and alerting capabilities to ensure pipelines complete accurately and within required service expectations; drive preventative improvements based on operational trends.
• Represent Data Engineering in cross-functional enhancements and projects, coordinating technical dependencies and supporting issue resolution.
• Communicate technical approaches, trade-offs, risks, and outcomes clearly to engineering teams, business stakeholders, and cross-functional forums.
• Conduct technical presentations and knowledge-sharing sessions on delivered solutions, standards, and engineering practices.
• Mentor and coach engineers, strengthening the team's technical capability and promoting consistent engineering practices.
• Provide out-of-hours support as requested for critical incidents and contribute to incident reviews and permanent remediation.

What you'll need

• Strong professional experience designing, building, and supporting enterprise ETL/ELT and data warehouse solutions.
• Advanced SQL skills, including complex transformations, performance tuning, stored procedures, and troubleshooting.
• Hands-on experience with at least one enterprise ETL/ELT platform such as Matillion, Informatica, SSIS, Talend, or a comparable technology.
• Experience with cloud or enterprise data warehouse platforms such as Snowflake, Amazon Redshift, or SQL-based warehouse technologies.
• Strong knowledge of relational and dimensional data modelling, including the ability to communicate designs through ER diagrams, data flow diagrams, process models, and dimensional models.
• Demonstrated ability to design scalable, extensible solutions without introducing avoidable technical debt.
• Experience leading the technical delivery of significant features or epics and coordinating work across multiple systems or teams.
• Experience establishing or improving engineering standards for code quality, testing, deployment, monitoring, documentation, and supportability.
• Advanced troubleshooting and root-cause analysis skills across pipelines, databases, integrations, and production environments.
• Ability to assess solution impacts, dependencies, risks, and trade-offs across connected systems.
• Experience partnering directly with business stakeholders, Business Analysts, Technical Architects, DevOps, QA, and other engineering teams.
• Ability to mentor engineers and provide clear, constructive technical guidance through design and code reviews.
• Excellent written and verbal English communication skills, including the ability to present technical topics to different audiences.
• Ability to independently plan and prioritize work, manage competing commitments, and deliver to agreed quality and timelines.

Nice to have

• Advanced experience with Snowflake and Matillion.
• Experience with Python and developing or integrating REST APIs.
• Experience with Power BI, Tableau, or other analytics and reporting platforms.
• Experience with CI/CD, source control, automated testing, infrastructure or configuration automation, and modern DevOps practices.
• Experience implementing data quality, metadata management, master data management, data governance, security, or access-control patterns.
• Experience designing end-to-end reporting and analytics solutions from source mapping through curated data products and consumption layers.
• Experience supporting highly visible business domains such as sales, finance, customer, product, or operational analytics.

Details

• Remote role; Sophos is remote-first, though some roles may be hybrid.
• Applicants must have legal authorization to work in the jurisdiction where the position is posted, without requiring employer sponsorship.
• Provide out-of-hours support as requested for critical incidents.