Data Analyst

Skills

Designing developing and maintaining robust data integration workflows that ensure accurate and seamless data flow between EQUIP and Microsoft Dynamics Collaborate with business analysts system architects and other stakeholders to understand data integration requirements and design efficient ETL workflows that facilitate the movement of data Develop extraction processes to retrieve data including sales inventory finance and customer information while ensuring data accuracy and integrity Apply data transformation logic to standardize cleanse and enrich data as needed for optimal compatibility and usability Implement robust data loading mechanisms to efficiently load transformed data into Microsoft Dynamics ensuring adherence to data quality standards and best practices Create error handling mechanisms to identify and address data inconsistencies or errors during the ETL process Develop monitoring and alerting systems to proactively manage data integration issues Fine-tune ETL processes for optimal performance considering factors such as data volume load frequency and resource utilization Implement techniques to enhance overall efficiency Maintain comprehensive documentation of ETL processes data mappings transformations and integration workflows Collaborate with cross-functional teams including database administrators software developers and business analysts to ensure alignment between data integration processes and organizational goals

Description

Proven ETL experience moving large sets of data
Strong expertise in SQL for data manipulation and transformation tasks
Experience with data cleansing, validation, and enrichment techniques
Strong problem-solving skills and attention to detail
Excellent communication and teamwork abilities