Data Integration Engineer/Analyst - Columbus-OH - Diverse Lynx

Role: Data Integration Engineer/Analyst
Location: Columbus-OH, ( open to nearby state)
Experience: 8+ Years
In-person Interview Mandatory
Interview Mode: L1 Interview a` L2 Interview a` Client Interview (L2/Client In person interview)
Job description:
Seeking a skilled and motivated Data Integration Engineers to be part of existing dynamic team. The primary responsibility of this role is to lead the end-end process of acquiring, cleansing, transforming, and storing data from external vendors to AWS. The successful candidates will leverage internal tools and SDKs, utilize AWS services such as S3, Athena, and Glue, and integrate with our internal Archival Service Platform for efficient data purging.

Responsibilities:

1. Collaborate with cross-functional teams to understand data requirements and establish seamless connections with external vendors
2. Develop and implement robust data acquisition strategies, ensuring data quality, integrity, and security.
3. Lead the design and implementation of data cleansing and transformation process to align vendor data with internal standards and structures
4. Utilize internal tools and SDKs for efficient data integration and processing, focusing on scalability and performance optimization
5. Implement and manage agents for monitoring, logging, and automation within AWS environments
6. Work with Amazon SNS for efficient notification and communication workflows
7. Work with other AWS services, including S3, Athena, and Glue, to optimize data storage, querying, and processing.
8. Lead the integration efforts with the internal Archival Service Platform for seamless data purging and lifecycle management
9. Collaborate with the data engineering team to continuously improve data integration pipelines, ensuring adaptability to evolving business needs.

Skills and Qualifications:

1. Bachelor s degree in Computer Science, Information Technology, or related filed.
2. In-depth knowledge and hands-on experience with ASW services, including SNS, S3, Athena, Glue, and Lambda
3. Expertise in data cleansing, transformation, and enrichment techniques
4. Experience in deploying and managing Apache Kafka
5. Proficient in programing language Java
6. Excellent communication and collaboration skills
7. Strong problem-solving skills and meticulous attention to detail.

Preferred Qualifications:
1. AWS Certification.
2. Advance expertise in Athena queries and optimization.
3. Knowledge of data governance and compliance standards.






Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.