5 AWS Data Engineer Jobs in Harrisburg, PA
HatchPros Inc is Hiring an AWS Data Engineer Near Harrisburg, PA
No OPT/CPT/F1/H1HybridAWS Database knowledge
redshift
etl
oracle database
As an AWS Redshift Data Engineer, the primary responsibility is to design, implement, and maintain data solutions using Amazon Redshift. Your role involves working 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 Glue, 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. Ensure compliance with data privacy regulations and industry standards, such as GDPR and HIPAA. 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. Collaborate with cross-functional teams, including data scientists, analysts, and software engineers, to understand data requirements and provide data solutions that meet their needs.
- Scalability and Capacity Planning: Plan and execute strategies for scaling Redshift clusters to handle increasing data volumes and user demands. Monitor resource utilization, track data growth, and make recommendations for capacity planning and infrastructure scaling.
- Knowledge or previous experience in oracle PLSQL will be added advantage
Job Summary
Contractor
$109k-136k (estimate)
06/13/2024
12/08/2024
The job skills required for AWS Data Engineer include AWS, Troubleshooting, Collaboration, etc. Having related job skills and expertise will give you an advantage when applying to be an AWS Data Engineer. That makes you unique and can impact how much salary you can get paid. Below are job openings related to skills required by AWS Data Engineer. Select any job title you are interested in and start to search job requirements.
The following is the career advancement route for AWS Data Engineer positions, which can be used as a reference in future career path planning. As an AWS Data Engineer, it can be promoted into senior positions as a DevOps Engineer IV that are expected to handle more key tasks, people in this role will get a higher salary paid than an ordinary AWS Data Engineer. You can explore the career advancement for an AWS Data Engineer below and select your interested title to get hiring information.
Similar Jobs
Popular Articles
