Data Integration Specialist

We are seeking a skilled Data Engineer to join our team. As a key member of our data warehouse technical stack, you will be responsible for delivering and supporting data integrations from internal and external sources into our system, ensuring accurate data delivery to our platform. You will also be required to build new data integrations (ETL components) and make changes to existing software.

Some of the key responsibilities of this role include:

• 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
• Developing Matillion ETL scripts and ETL orchestrations as required
• Ensuring the team is following best practices of ETL development
• Leveraging monitoring tools to track status of ETL Pipelines for performance and completion
• Developing and writing complex SQL queries and stored procedures to extract and insert data into and from the Datawarehouse
• Engaging with Business Analyst & Technical Architects to clarify business requirements and offer recommendations for improvements
• Contributing to defining a scalable data warehouse architecture
• Coordinating production, development and sandbox environments
• Coordinating releases with DevOps team and preparing the required documentation related to release
• Participating in peer code reviews
• Providing coaching and guidance to junior team members on technologies and processes
• Providing support and recommendations for testing and UAT for work being delivered
• Providing out-of-hours support as requested for incidents
• Participating in routine maintenance, performance tuning and support of ETL and the DW Environment

To be successful in this role, you will need to possess the following skills and qualifications:

• At least 2 years of IT experience 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 offer a range of benefits to support your career growth and well-being, including:

• Opportunities to develop your skills and expertise through training and professional development programs
• A collaborative and dynamic work environment that encourages innovation and creativity
• Flexible working arrangements to suit your needs, including remote work options
• A comprehensive benefits package, including health insurance, retirement savings plan, and paid time off
• Access to cutting-edge technology and tools to help you do your job effectively
• Regular feedback and coaching to support your career growth and success

We are committed to creating a diverse and inclusive workplace culture that values different perspectives and experiences. We believe that diversity and inclusion are essential to driving innovation and success, and we strive to create a workplace that reflects this commitment.