Enterprise Data Integration Specialist

Job Title: Data Integration Specialist

You will be responsible for delivering and supporting data integrations from internal and external sources into the 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 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)

We operate a remote-first working model. 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.

Data Protection: 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 at our company.