Data Integration Specialist

Vintti is a specialized staffing agency that believes diversity is the catalyst for innovation. We connect US-based SMBs, startups, and firms with exceptional talent from Latin America, fostering a rich tapestry of cultural perspectives within American businesses. Our unique position allows us to handpick professionals who not only possess the required skills but also bring fresh ideas and global insights to the table. Vintti's services go beyond filling positions; we enrich company cultures and expand business horizons on an international scale.

A Data Integration Specialist plays a crucial role in managing and orchestrating the seamless flow of data across multiple systems and platforms. They are responsible for designing, developing, and implementing data integration solutions that ensure data consistency and integrity throughout an organization’s IT ecosystem. By utilizing various tools and technologies, they enable the synchronization of data, facilitate communication between disparate systems, and support business intelligence initiatives. Their expertise in data mapping, transformation, and ETL processes helps optimize data workflows, thereby enhancing the overall efficiency and data-driven decision-making capabilities of the organization.

- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Minimum of 3-5 years of experience in data integration or a similar role.
- Proficiency with ETL tools and platforms such as Informatica, Talend, or SSIS.
- Strong knowledge of SQL and experience with database management systems such as SQL Server, Oracle, or MySQL.
- Experience with data mapping, data migration, and data transformation processes.
- Familiarity with data warehousing concepts and technologies.
- Understanding of data governance, data quality, and data security best practices.
- Excellent problem-solving skills and ability to troubleshoot data integration issues.
- Strong analytical skills and attention to detail.
- Ability to work independently and collaboratively in a team environment.
- Effective communication skills, both written and verbal.
- Experience working with APIs and web services for data exchange.
- Familiarity with cloud platforms such as AWS, Azure, or GCP.
- Knowledge of programming languages such as Python, Java, or .NET.
- Experience with data modeling and data architecture design.
- Ability to manage multiple projects and priorities in a fast-paced environment.
- Demonstrated ability in conducting data validation and verification checks.
- Experience with data integration tools and platforms maintenance and upgrades.
- Familiarity with business intelligence and data visualization tools such as Tableau or Power BI.
- Ability to coordinate and collaborate with external vendors and partners.
- Experience providing technical support and training to end-users.
- Strong understanding of enterprise data strategies and integration methodologies.
- Commitment to staying updated with new data integration technologies and industry best practices.
- Ability to create and maintain detailed technical documentation.
- Proven track record of identifying and implementing process improvements and automation within data workflows.

- Design and develop data integration solutions to meet business operations needs.
- Perform data mapping, migration, and transformation between different systems and platforms.
- Monitor, optimize, and maintain ETL processes for efficient data flow.
- Collaborate with cross-functional teams to gather and translate business requirements into technical specifications.
- Troubleshoot and resolve data integration issues to minimize business disruption.
- Document data integration processes, workflows, and system configurations.
- Conduct data quality assessments and implement measures to ensure data integrity.
- Develop and maintain SQL queries, scripts, and stored procedures for data management.
- Manage and support data integration tools and platforms.
- Perform regular data validation and verification checks.
- Work with data analysts and business intelligence teams to ensure data supports reporting and analytics.
- Provide technical support and training on data integration systems and tools.
- Coordinate data exchange and integration initiatives with external vendors and partners.
- Evaluate and recommend new data integration technologies and tools.
- Participate in data architecture and design discussions.
- Ensure compliance with data governance policies and security standards.
- Create and maintain data integration test plans and conduct thorough validation.
- Identify and implement opportunities for process improvements and automation in data integration workflows.

The ideal candidate for the Data Integration Specialist role is a highly skilled professional with a bachelor's degree in Computer Science, Information Technology, or a related field and possesses 3-5 years of experience in data integration or a similar capacity. They demonstrate proficiency with ETL tools and platforms such as Informatica, Talend, or SSIS, and have a strong command of SQL along with experience in managing database systems like SQL Server, Oracle, or MySQL. An expert in data mapping, migration, and transformation processes, they exhibit a deep understanding of data warehousing concepts and data governance, security, and quality practices. The perfect candidate is an analytical thinker with excellent problem-solving skills and a keen eye for detail, capable of troubleshooting complex data integration issues efficiently. They possess effective communication abilities, both written and verbal, and can work independently while also being a collaborative team player. In addition to technical acumen, they demonstrate facility with APIs and web services for data exchange and have experience with cloud platforms such as AWS, Azure, or GCP along with programming knowledge in languages like Python, Java, or .NET. With a track record of managing multiple projects in fast-paced environments, they excel in data validation, verification, and maintaining data integration tools. Familiarity with business intelligence tools such as Tableau or Power BI is expected, and the ability to provide technical support and training is crucial. Ultimately, the ideal candidate is proactive, self-motivated, organized, and dedicated to continuous professional development, maintaining up-to-date technical documentation, and adhering to data governance and security standards. Their strategic mindset focuses on process improvement and automation, making them the perfect fit for enhancing our data integration workflows and ensuring data integrity across the organization.

- Design, develop, and manage data integration solutions to support business operations.
- Perform data mapping, data migration, and data transformation between various systems and platforms.
- Monitor and optimize ETL (Extract, Transform, Load) processes to ensure efficient and accurate data flow.
- Collaborate with cross-functional teams to understand business requirements and translate them into technical specifications.
- Troubleshoot and resolve data integration issues promptly to minimize disruption to business processes.
- Maintain and update documentation related to data integration processes, workflows, and system configurations.
- Conduct data quality assessments and implement measures to improve data integrity and reliability.
- Develop and maintain SQL queries, scripts, and stored procedures for data extraction and manipulation.
- Manage and support data integration tools and platforms, ensuring they are up-to-date and functioning optimally.
- Perform regular data validation and verification checks to ensure the accuracy and completeness of integrated data.
- Work with data analysts and business intelligence teams to ensure integrated data supports reporting and analytics needs.
- Provide technical support and training to end-users on data integration systems and tools.
- Coordinate with external vendors and partners on data exchange and integration initiatives.
- Evaluate new data integration technologies and tools to enhance current systems and processes.
- Participate in data architecture and design discussions to ensure integration solutions align with enterprise data strategy.
- Ensure compliance with data governance policies and data security standards throughout integration processes.
- Create and maintain data integration test plans and conduct thorough testing to validate solution performance.
- Proactively identify opportunities for process improvements and automation within data integration workflows.

- Strong analytical and problem-solving skills
- High attention to detail and accuracy
- Excellent communication and interpersonal skills
- Ability to work independently and collaboratively
- Proactive and self-motivated attitude
- Strong organizational and time-management skills
- Ability to manage and prioritize multiple tasks and projects
- Adaptability and flexibility in a fast-paced environment
- Strong technical aptitude and willingness to learn new technologies
- Effective troubleshooting and issue resolution capabilities
- Strong understanding of data integration and ETL processes
- Commitment to data integrity and quality
- Strategic thinker with a focus on process improvement and automation
- Collaborative mindset to work effectively with cross-functional teams
- Capacity to handle complex technical challenges
- Dedication to maintaining up-to-date technical documentation
- Focus on compliance with data governance and security standards
- Ability to provide clear technical support and training to end-users
- Experience coordinating with external vendors and partners
- Enthusiasm for continuous professional development and staying current with industry advancements

- Competitive salary range based on experience and expertise
- Comprehensive health, dental, and vision insurance coverage
- Retirement savings plan with employer match
- Paid time off (PTO) including holidays, vacation, and sick leave
- Flexible work schedule and remote work options
- Professional development opportunities and continuing education support
- Employee wellness programs, including access to fitness facilities or wellness stipends
- Work-life balance programs to support family and personal commitments
- Performance-based bonuses and incentives
- Opportunities for career advancement and internal promotions
- Company-sponsored social events and team-building activities
- Access to cutting-edge technology and tools
- Supportive and collaborative work environment
- Tuition reimbursement programs for further education
- Life and disability insurance
- Employee assistance programs (EAP) for personal and professional support
- Access to company resources for skill-building and career growth
- Subsidized transportation or commuting benefits
- Recognition and reward programs for outstanding performance