Data Transformation Specialist

About the Role

We are seeking a highly skilled data transformation specialist to support our organization's data integration and business intelligence initiatives. The ideal candidate will be responsible for designing, developing, and maintaining data transformation processes, as well as data warehouse design and modeling.

Responsibilities :

• Design and develop data transformation processes to support data integration and business intelligence initiatives.
• Utilize SQL to write complex queries and stored procedures for data extraction and transformation.
• Implement and manage data transformation processes using ETL tools such as SSIS.
• 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 stakeholders to understand data requirements and deliver solutions that meet their needs.
• Monitor and troubleshoot data transformation processes to ensure optimal performance and resolve any issues promptly.
• Document data transformation processes, workflows, and data mappings to ensure clarity and maintainability.
• Stay current with industry trends and best practices in data transformation, data integration, and data warehousing.

Requirements :