Data Integration Engineer

At Vintti, we specialize in providing US businesses with staffing solutions that feel local. By connecting companies with Latin American professionals operating in compatible time zones, we ensure that work schedules align naturally with US business hours. This temporal harmony facilitates immediate response times, efficient project management, and a cohesive team dynamic regardless of physical location.

A Data Integration Engineer is responsible for designing, implementing, and managing data integration solutions that ensure seamless data flow between disparate systems within an organization. They play a crucial role in translating business needs into technical solutions, integrating databases, applications, and cloud services to enable data accessibility and accuracy. Utilizing ETL (Extract, Transform, Load) processes, they help in maintaining data integrity, optimizing data pipelines, and supporting data analytics initiatives. Proficiency in various programming languages and integration tools is essential for efficiently handling data synchronization and transformation tasks.

- Bachelor's degree in Computer Science, Information Technology, or related field.
- 3+ years of experience in data integration or ETL development.
- Proficiency with ETL tools such as Informatica, Talend, or SSIS.
- Strong knowledge of SQL and database management systems including Oracle, SQL Server, or MySQL.
- Experience with data modeling and database design.
- Familiarity with cloud-based data services such as AWS, Google Cloud, or Azure.
- Proficiency in scripting languages like Python, Perl, or Bash.
- Strong understanding of data warehousing concepts and methodologies.
- Experience with APIs and web services for data integration.
- Strong problem-solving skills and attention to detail.
- Excellent communication skills, both written and verbal.
- Understanding of data governance and data security practices.
- Ability to manage multiple projects and meet deadlines.
- Experience with data visualization tools like Tableau or Power BI is a plus.
- Strong analytical and organizational skills.
- Ability to work collaboratively in a team environment.
- Experience with version control systems like Git.
- Knowledge of big data technologies such as Hadoop or Spark is a plus.
- Proven track record of delivering high-quality, scalable data integration solutions.
- Experience in Agile development methodologies is preferred.

- Design, develop, and implement efficient data integration solutions using ETL tools.
- Collaborate with data architects to plan and execute data migrations.
- Monitor data integration workflows and troubleshoot issues.
- Optimize performance and reliability of data integration processes.
- Extract, clean, and transform data for accuracy and consistency.
- Document data workflows, mappings, and transformations.
- Perform data quality checks and validate accuracy against source systems.
- Integrate new data sources into the existing data infrastructure.
- Liaise with business analysts to implement data requirements.
- Maintain and update technical documentation and mappings.
- Conduct root cause analysis for data-related issues and correct them.
- Develop and maintain database objects like tables and stored procedures.
- Ensure compliance with data governance and security policies.
- Automate data integration using APIs and other methods.
- Provide support and maintenance for existing data integration solutions.
- Stay updated on emerging data integration technologies and best practices.
- Create and maintain test plans; perform unit and integration testing.
- Develop and enforce data integration standards and best practices.
- Translate business requirements into technical specifications.
- Participate in code reviews and provide feedback to team members.

The ideal candidate for the Data Integration Engineer role possesses a Bachelor's degree in Computer Science, Information Technology, or a related field and has over three years of substantial experience in data integration or ETL development. They exhibit proficiency with ETL tools like Informatica, Talend, or SSIS and have a solid understanding of SQL and database management systems such as Oracle, SQL Server, or MySQL. They show expertise in data modeling, database design, and are familiar with cloud-based data services including AWS, Google Cloud, or Azure. With a strong grasp of scripting languages like Python, Perl, or Bash, and knowledge of data warehousing concepts and methodologies, they excel in extracting, cleaning, and transforming data to ensure accuracy and consistency. Experience with APIs and web services for data integration, coupled with a foundational knowledge in big data technologies such as Hadoop or Spark, further enhance their technical capabilities. Known for their excellent problem-solving skills and keen attention to detail, they possess strong analytical and organizational abilities and can manage multiple projects effectively while meeting tight deadlines. They communicate complex technical concepts clearly to non-technical stakeholders and collaborate seamlessly within cross-functional teams. The ideal candidate is driven, proactive, and adaptable to a fast-paced environment, consistently focused on delivering high-quality, scalable solutions. With a commitment to data governance and security practices, they also demonstrate a customer-focused mindset, an eagerness for continuous learning, and a proactive approach to professional development. This individual showcases a strong sense of accountability, a dedication to achieving excellence, and a genuine passion for advancing their expertise in data integration technologies.

- Design, develop, and implement data integration solutions using ETL (Extract, Transform, Load) tools and technologies.
- Collaborate with data architects and other team members to plan and execute data migrations and transformations.
- Monitor and troubleshoot data integration workflows to ensure scheduled processes run smoothly.
- Optimize and tune data integration processes for performance efficiency and reliability.
- Extract, clean, and transform data from various sources to ensure accuracy and consistency.
- Manage and document data workflows, mappings, and transformations for ongoing projects.
- Perform data quality checks and validate data accuracy against source systems.
- Evaluate and integrate new data sources into existing data infrastructure.
- Liaise with business analysts and stakeholders to understand and implement data requirements.
- Maintain and update data integration documentation, including technical specifications and mappings.
- Conduct root cause analysis for data-related issues and implement corrective actions.
- Develop and maintain database objects such as tables, views, indexes, and stored procedures.
- Ensure compliance with data governance and security policies regarding data integration processes.
- Utilize APIs and other data transfer methods to automate data integration between disparate systems.
- Provide support and maintenance for existing data integration solutions and troubleshoot any issues.
- Stay current with emerging data integration technologies and best practices.
- Create and maintain test plans and perform unit and integration testing.
- Assist in the development and enforcement of data integration standards and best practices.
- Work with cross-functional teams to translate business requirements into technical specifications.
- Participate in code reviews and provide constructive feedback to team members.

- Detail-oriented with a strong focus on accuracy and data integrity
- Excellent problem-solving skills and analytical thinking
- Strong communication abilities to convey technical concepts to non-technical stakeholders
- Ability to work independently and as part of a team
- Self-motivated with a proactive approach to identifying and solving issues
- Adaptable and flexible in a fast-paced and evolving environment
- Proven ability to manage multiple projects and meet deadlines
- Strong organizational skills and ability to prioritize tasks effectively
- A collaborative mindset with a willingness to take initiative
- Quick learner with a keen interest in keeping up with emerging technologies
- Strong sense of accountability and commitment to delivering high-quality work
- Customer-focused with an understanding of how data integration impacts business decisions
- Keen attention to detail to ensure the accuracy and consistency of data
- Commitment to ongoing professional development and skills improvement

- Competitive salary range: $80,000 - $120,000 per year
- Comprehensive health, dental, and vision insurance
- 401(k) retirement plan with company match
- Paid time off (PTO) and holiday pay
- Flexible work hours to promote work-life balance
- Remote work options available
- Professional development and training opportunities
- Tuition reimbursement for advanced education
- Employee wellness programs
- On-site gym and fitness classes (for in-office positions)
- Casual dress code
- Employee assistance program (EAP)
- Life and disability insurance
- Performance bonuses and incentives
- Opportunities for career advancement and growth
- Regular team-building activities and events