Data Integration Specialist

ETL Developer Job Description

Pinnacle Group Inc is a leader in providing innovative workforce solutions, dedicated to optimizing talent acquisition and management processes.

Job Summary :

The ideal candidate will be responsible for designing, developing, and maintaining ETL processes, as well as data warehouse design and modeling, to support our data integration and business intelligence initiatives.

• Design, develop, and maintain ETL processes to support data integration and business intelligence initiatives.
• Utilize T-SQL to write complex queries and stored procedures for data extraction and transformation.
• Implement and manage ETL processes using SSIS (SQL Server Integration Services).
• Design and model data warehouses to support reporting and analytics needs.
• Ensure data accuracy, quality, and integrity through effective testing and validation procedures.
• Collaborate with business analysts and stakeholders to understand data requirements and deliver solutions that meet their needs.
• Monitor and troubleshoot ETL processes to ensure optimal performance and resolve any issues promptly.
• Document ETL processes, workflows, and data mappings to ensure clarity and maintainability.
• Stay current with industry trends and best practices in ETL development, data integration, and data warehousing.

Required Skills and Qualifications