Data Integration Specialist

Job Overview

NeenOpal Canada Inc. is looking for an experienced Data Integration Specialist to design, develop, and maintain scalable data pipelines and ETL processes. The successful candidate will collaborate closely with our global Business Analytics teams to support the implementation of data warehouse solutions tailored to client needs. This role offers the opportunity to work in a hybrid environment, with 1-2 days per week in our Fredericton office.

Key Responsibilities

• Data Pipeline Development : Design, implement, and manage robust data pipelines that ensure efficient data flow from various sources into data warehouses. This includes automating ETL processes using Python and advanced data architecture tools.
• Data Integration : Utilize industry-standard tools and technologies to integrate and transform data. This includes working with platforms such as :
• AWS Services : AWS Glue, AWS Data Pipeline, Amazon Redshift, and Amazon S3.
• Azure Services : Azure Data Factory, Azure Synapse Analytics, and Azure Blob Storage.
• Data Warehousing : Implement and optimize data warehousing solutions using Snowflake and Amazon Redshift.
• Database Management : Develop, optimize, and manage relational databases, including SQL Server, MySQL, and PostgreSQL, ensuring data integrity and performance.
• Performance Optimization : Continuously monitor and improve the performance of data processing workflows. Apply best practices for query optimization and data processing efficiency.
• Collaboration : Work closely with cross-functional teams in the US, India, and Canada to deliver high-quality data solutions. Ensure effective communication and collaboration across different time zones.
• Data Governance : Document data pipelines, ETL processes, and data mappings in line with established data governance standards. Ensure compliance with data quality and security protocols.
• Troubleshooting & Support : Diagnose and resolve data-related issues promptly, providing ongoing support to ensure the reliability of data solutions.

Required Skills and Experience

Preferred Qualifications

What We Offer

Note : You are expected to have a valid work authorization in Canada to apply for this role.

#J-18808-Ljbffr