Job Description:
Title: Data Engineer
Location: Tampa, FL (Onsite 3 days a week)
Day-one W2 with Kyyba.
Visa: & / NO H1B/OPT / CPT
Job Title: Data Engineer
Overview:
We are seeking a skilled Data Engineer to join our team and focus on the development, implementation, and maintenance of our data warehouse using Amazon Redshift. The ideal candidate will have a strong background in data engineering, experience with AWS infrastructure, and expertise in managing data sourced from structured and unstructured data sources. Additionally, you will be responsible for creating insightful reports using Amazon QuickSight.
Key Responsibilities:
· Design, develop, and maintain robust data warehouse solutions utilizing Amazon Redshift.
· Collaborate with cross-functional teams to gather data requirements and ensure seamless data integration from databases, external files, and other structured and unstructured data sources.
· Define, create, and optimize ETL processes to enhance data extraction, transformation, and loading using AWS services.
· Maintain data integrity and ensure high availability and performance of data storage systems.
· Implement data governance practices to ensure compliance and security of data assets.
· Develop and maintain data pipelines and workflows using AWS tools such as Glue, Lambda, Step Functions, Athena, DMS, Redshift, and others.
· Utilize Amazon QuickSight to design, develop, and publish dynamic reports and dashboards for business analytics.
· Perform data analysis and validation to ensure data accuracy and consistency across various data sources.
· Troubleshoot and resolve complex data processing issues in a timely manner.
· Stay current with industry trends and best practices related to data engineering and AWS technologies.
Requirements:
· Bachelor’s degree in Computer Science, Information Technology, or a related field.
· Proven experience as a Data Engineer, with a focus on data warehouse architecture and development.
· Proficiency in SQL and experience with AWS services such as Redshift, S3, and QuickSight.
· Familiarity with data extraction and transformation using MySQL databases and Parquet files.
· Strong understanding of data modeling, database management, and data warehousing concepts.
· Experience with ETL tools and frameworks.
· Ability to work collaboratively in a team environment and communicate effectively.
· Strong problem-solving skills and attention to detail.
Preferred Qualifications:
· AWS Certified Data Analytics or AWS Certified Solutions Architect certification.
· Experience with big data tools and technologies.
· Familiarity with data visualization and reporting tools.