Senior Data Integration Specialist

You will be part of a team that is responsible for delivering and supporting data integrations from internal and external sources into the technical stack, ensuring accurate data delivery to systems. This role involves building new data integrations (ETL components) and making changes to existing software, as well as contributing to designing and building a strong Enterprise Data Warehouse.

• Understand business and data requirements, define solution approach, design and implement ETL components.
• Have 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 follows 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).

We operate a remote-first working model. Some roles may require a hybrid approach. 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.

We innovate and create, with a sense of fun and team spirit. Our people are passionate about diverse perspectives to fuel innovation. We build community and provide education and advocacy through employee-led diversity and inclusion networks. We support local communities through annual charity and fundraising initiatives and volunteer days. We reduce our environmental footprint through global employee sustainability initiatives. We keep our bodies and minds sharp through global fitness and trivia competitions. We support employee health and wellbeing through global wellbeing days and monthly wellbeing webinars and training.

If you share your CV or other personal details with us, 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. You can request deletion or updates at any time per the Privacy Policy.