Aaron K

About Aaron K

Looking for Remote Opportunities.• US Citizen• Solid expertise in Data Engineering, SQL, ETL processes, and end-to-end data solutions.• In-depth knowledge of Data Warehousing (requirements gathering, schema design, development, implementation, testing, and performance tuning of queries).• Extensive experience in Data Modeling (Star Schema, Snowflake Schema for FACT and Dimension tables), Data Processing, and Data Acquisition.• Proficient in designing and implementing scalable and efficient ETL pipelines using a variety of tools and technologies.• Expertise in cloud-based solutions (AWS, Azure, GCP) and a wide range of cloud data services such as Amazon S3, Redshift, Glue, Lambda, Athena, and QuickSight.• Strong background in implementing and optimizing data pipelines for both batch and real-time data processing using Python, PySpark, and Bash scripting.• Skilled in integrating and working with multiple data storage systems (AWS S3, Redshift, Snowflake, MySQL, PostgreSQL, MongoDB).• Experienced in working with data processing frameworks like Apache Spark, Apache Airflow, and AWS Step Functions.• Proficient in event-driven architecture and cloud-native solutions for automated, scalable data processing.• Experienced in data wrangling, data transformation, and cleaning for accurate, reliable insights.• Knowledgeable in data visualization using tools such as Amazon QuickSight, Power BI, and Tableau.• Solid experience with monitoring, maintaining, and optimizing data pipelines and ensuring data integrity.Skill Summary:Cloud & AWS Services: S3, Glue, Redshift, Lambda, Athena, CloudWatch, QuickSight, EC2, RDS, Step FunctionsETL & Data Processing Tools: PySpark, Spark, Pandas, AWS Data Pipeline, BashLanguages: Python, SQL, Java, R, TypeScript, JavaScript, Ruby, Perl, Shell Scripting (Bash, Tcsh, Csh)Data Warehousing & Databases: Snowflake, Amazon Redshift, PostgreSQL, MySQL, MongoDBData Workflow & Orchestration: Apache Airflow, AWS Step Functions, AWS LambdaData Visualization: Amazon QuickSight, Power BI, TableauVersion Control & CI/CD: GitLab, Git, Jenkins, BitbucketMachine Learning: Scikit-learn, TensorFlow, Keras

Experience

1. Data Engineer Business Intelligence Engineer

   Amazon

   Jan 2024 — Present

   Developed and optimized complex SQL queries to troubleshoot and resolve customer bug tickets, ensuring data integrity and enhancing overall system performance.• Spearheaded the migration of large data tables between clusters, improving data accessibility and streamlining data management processes.• Designed and implemented ETL processes using AWS Data Pipeline, setting up automated job profiles that enhanced data processing efficiency.• Automated backfilling of tables with updated logic through Linux scripting, reducing task completion time from two weeks to just one day.• Leveraged Python and Bash scripting to automate updates to table dependencies, improving data flow and reducing manual intervention.• Collaborated with cross-functional teams to identify data requirements and deliver actionable insights, driving informed business decisions.

Education

• University of Houston-Clear Lake

  Master of Engineering - MEng, Computer Engineering

Skills

• Photoshop
• Graphics
• New Media
• Email Marketing
• Mobile Applications
• App Development
• Graphic Design
• Web Design
• Audio Editing
• Video Editing
• Photography
• Video Production
• Music Production
• Website Design