Job Description
Job Description
Symmetrio is actively recruiting for a Data Integration Specialist for our customer, a large government organization in Philadelphia, PA.
As a Data Integration Specialist, you will play a crucial role in the seamless migration, integration, and management of large-scale data across Amazon S3 and Redshift environments.
This role demands not only technical expertise but also an in-depth understanding of data architecture, data security, and integration strategies to ensure robust data infrastructure.
This is a full-time, hybrid position requiring on-site presence in Philadelphia 2 days per week.
Responsibilities
- Design, develop, and deploy ETL / ELT data pipelines to facilitate the transfer of complex datasets into Amazon S3, using tools such as Azure Data Factory, optimized for performance, resilience, and scalability
- Implement automated workflows to streamline the continuous data migration process, ensuring that data ingestion and processing run smoothly with minimal manual intervention
- Set up and manage Amazon S3 buckets for optimized data storage solutions, and configure data schemas and tables within Amazon Redshift to accommodate evolving business needs
- Migrate cleaned and preprocessed data efficiently into Amazon S3 and Redshift, ensuring data consistency and integrity throughout the process
- Proactively monitor data pipelines for performance, identifying potential bottlenecks or failures, and implementing solutions to maintain optimal data flow
- Regularly assess and refine data integration processes to enhance system efficiency and scalability, leveraging best practices in cloud and data engineering
- Maintain meticulous documentation for all data integration processes and ensure all activities comply with data governance standards, security protocols, and company policies
Requirements
- Minimum of 3 years of experience working as a Data Integration Specialist
- Proficiency with cloud platforms, particularly AWS (S3, Redshift, Lambda) and Azure Data Factory
- Strong skills in SQL and experience with ETL tools
- Demonstrated expertise in data security and integrity measures, including encryption and secure data transfer
- Excellent problem-solving and analytical abilities for troubleshooting data integration challenges
- Effective communication and documentation skills, with the ability to clearly document technical processes
- Preferred experience with AWS Glue, Python, C#, and SparkSQL
Benefits
- Health Care Plan (Medical, Dental & Vision)
- Retirement Plan (401k, IRA)
- Paid Time Off (Vacation, Sick & Public Holidays)
Data Integration Specialist (Hybrid)
As a Data Integration Specialist, you will play a crucial role in the seamless migration, integration, and management of large-scale data across Amazon S3 and Redshift environments. This role demands not only technical expertise but also an in-depth understanding of data architecture, data security,...
Data Migration & Integration Specialist
Responsible for the creation and ownership of an integration data strategy, providing essential technical and procedural support for the data, including oversight of data migration and integration. This role will be responsible for ensuring seamless migration and integration of data between systems ...
Data Integration Specialist In Philadelphia, PA
Proficient with Azure Data Factory. Expertise in data security and integrity measures. ...
Data Integration Specialist
A Data Integration Specialist is needed for a temporary role to support data migration, integration, and maintenance in Amazon S3 and Amazon Redshift environments. This role will involve designing, implementing, and securing data pipelines while ensuring data integrity and optimizing processes. Desi...
Data Integration Specialist
Brooksource is currently seeking a Data Integration Specialist! This individual will be responsible for managing the technical delivery of data solutions across a Payer organization. Additionally, the lead will oversee a team of MuleSoft developers to ensure seamless integration of data and applicat...
Data Integration Specialist (Hybrid)
As a Data Integration Specialist, you will play a crucial role in the seamless migration, integration, and management of large-scale data across Amazon S3 and Redshift environments. This role demands not only technical expertise but also an in-depth understanding of data architecture, data security,...
Data Integration Specialist
Position Info:</b></p> <ul> <li><b>Title:</b> Data Integration Specialist</li> <li><b>Client:</b> Office of Innovation & Technology</li> <li><b>Duration:</b> 6 Months </li> <li><b>Location:</...
TAMR Data Integration Specialist
My client is on the lookout for a talented TAMR Data Integration Specialist to join their tech-savvy team as they expand. If you've got a background in data development, a passion for data integration, and a solid track record of success, this opportunity is tailor-made for you. Data Warehouse/Data ...
Data Integration Specialist
A Data Integration Specialist is needed for a temporary role to support data migration, integration, and maintenance in Amazon S3 and Amazon Redshift environments. This role will involve designing, implementing, and securing data pipelines while ensuring data integrity and optimizing processes. Desi...
Work from Home AI Math Educator
Are you an experienced </strong><strong> Math Expert</strong><strong> </strong><strong>who would like to lend your expertise to train AI models?</strong></p><p><strong> </strong></p><p><stron...