AWS Cloud Engineer- Data Migrations
REMT - Remote Worker Location
Secure our Nation, Ignite your Future
Become an integral part of a diverse team while working at an Industry Leading Organization, where our employees come first. At ManTech International Corporation, you’ll help protect our national security while working on innovative projects that offer opportunities for advancement.
The Department of the Air Force (DAF) is in the midst of a wholescale transformation effort aimed at delivering a force that is ready to meet the challenges of the 21st century. DAF is transforming elements of all phases of its human resource management (HRM) life cycle to meet their people demands.
ManTech will ensure that the DAF’s business processes and supporting information technology platforms fully empower DAF personnel and Guardians to maximize their abilities. Your work on the DTD team will help transform data and enterprise architectures, consolidate and modernize platforms, and integrate AI into human capital business processes.
Currently, ManTech is seeking a motivated, career and customer-oriented AWS Cloud Engineer- Data Migrations to join our team.
Responsibilities include but are not limited to:
Design, implement, and maintain data solutions using Amazon Redshift
Work with large-scale data sets, optimizing performance, and ensuring the reliability and availability of the Redshift environment
Data Modeling and Design: Develop and maintain data models for Redshift databases, including schema design, table structures, and optimization techniques
Collaborate with data architects and stakeholders to understand requirements and translate them into efficient data structures
ETL Development: Design and implement Extract, Transform, Load (ETL) processes to extract data from various sources, transform it as per business requirements, and load it into Redshift
Develop efficient and scalable ETL workflows, considering data quality, performance, and data governance
Performance Optimization: Optimize query performance by creating appropriate data distribution keys, sort keys, and compression techniques
Identify and resolve performance bottlenecks, fine-tuning queries, and optimizing data processing to enhance Redshift's performance
Data Integration: Integrate Redshift with other AWS services, such as AWS Lambda, Amazon S3, and more, to build end-to-end data pipelines
Ensure seamless data flow between different systems and platforms, maintaining data integrity and consistency
Monitoring and Troubleshooting: Implement monitoring and alerting systems to proactively identify issues and ensure the stability and availability of the Redshift cluster
Perform troubleshooting, diagnose, and resolve data-related issues, and work closely with support teams to resolve any performance or operational problems
Security and Compliance: Implement security best practices to protect data stored in Redshift
Implement encryption, access controls, and data masking techniques to secure sensitive data
Documentation and Collaboration: Maintain documentation of data models, ETL processes, and system configurations
Scalability and Capacity Planning: Plan and execute strategies for scaling Redshift clusters to handle increasing data volumes and user demands
Minimum Qualifications:
Bachelor’s Degree required, preferably in Engineering, Mathematics, or Business.
Associate level AWS cloud certification
Must have 8+ years of Amazon Redshift Architecture experience and 5+ years of experience with AWS Pipeline to develop ETL for data movement to Redshift
Must have 5+ years of experience using databases such as Oracle, SQL Server
Strong knowledge on AWS environment and Service knowledge with S3 storage understanding
Strong knowledge multiple cloud technologies including VPC, EC2, S3, and Amazon API Gateway
Extensive experience with writing, understanding and maintain complex SQL
Experience with RedShift Spectrum and experience building data models to support analytics capabilities, such as facts & dimensions and star schema
Should understand nuances of moving data from RDBMS sources to Columnar DB (Redshift)
Hands on experience in Data Warehouse (DW) and BI tools is mandatory
Clearance Requirements:
Must be a US Citizenship and able to obtain and maintain a Secret Clearance
Physical Requirements:
Must be able to remain in a stationary position 50% of the time with occasional travel.
For all positions requiring access to technology/software source code that is subject to export control laws, employment with the company is contingent on either verifying U.S.-person status or obtaining any necessary license. The applicant will be required to answer certain questions for export control purposes, and that information will be reviewed by compliance personnel to ensure compliance with federal law. ManTech may choose not to apply for a license for such individuals whose access to export-controlled technology or software source code may require authorization and may decline to proceed with an applicant on that basis alone.
ManTech International Corporation, as well as its subsidiaries proactively fulfills its role as an equal opportunity employer. We do not discriminate against any employee or applicant for employment because of race, color, sex, religion, age, sexual orientation, gender identity and expression, national origin, marital status, physical or mental disability, status as a Disabled Veteran, Recently Separated Veteran, Active Duty Wartime or Campaign Badge Veteran, Armed Forces Services Medal, or any other characteristic protected by law.
If you require a reasonable accommodation to apply for a position with ManTech through its online applicant system, please contact ManTech's Corporate EEO Department at (703) 218-6000. ManTech is an affirmative action/equal opportunity employer - minorities, females, disabled and protected veterans are urged to apply. ManTech's utilization of any external recruitment or job placement agency is predicated upon its full compliance with our equal opportunity/affirmative action policies. ManTech does not accept resumes from unsolicited recruiting firms. We pay no fees for unsolicited services.
If you are a qualified individual with a disability or a disabled veteran, you have the right to request an accommodation if you are unable or limited in your ability to use or access http://www.mantech.com/careers/Pages/careers.aspx as a result of your disability. To request an accommodation please click careers@mantech.com and provide your name and contact information.
ApplyJob Profile
Benefits/PerksHealth insurance Holiday Pay Learning and Development Learning and development opportunities Life Insurance Other optional benefit elections Paid Time Off Retirement and Savings Short Term and Long Term Disability Wellness programs
Tasks- Data integration
- Data Modeling and Design
- Design, implement, and maintain data solutions using Amazon Redshift
- Development
- Documentation
- Documentation and Collaboration
- ETL development
- ETL processes
- Integration
- Monitoring
- Monitoring and Troubleshooting
- Performance Optimization
- Scalability and Capacity Planning
- Security and Compliance
- Troubleshooting
Amazon Redshift Amazon S3 API AWS AWS Cloud AWS Lambda Cloud Cloud Technologies Compliance Databases Data documentation Data Governance Data Integration Data Modeling Data Models Data processing Data Quality Development Documentation Encryption Engineering ETL Oracle Software SQL SQL Server Storage
Experience8 years
EducationBachelor's degree in engineering Business Education Engineering Information Technology IT Mathematics
Certifications