Senior Data Engineer

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team. Job Title: Senior Data Engineer Location: Seattle, WA Job Summary AWS Infrastructure Services owns the design, planning, delivery, and operation of all AWS global infrastructure. We’re the people who keep the cloud running. We support all AWS data centers and all of the servers, storage, networking, power, and cooling equipment that ensure our customers have continual access to the innovation they rely on. We work on the most challenging problems, with thousands of variables impacting the supply chain, and we’re looking for talented people who want to help. You’ll join a diverse team of software, hardware, and network engineers, supply chain specialists, security experts, operations managers, and other vital roles. You’ll collaborate with people across AWS to deliver the highest standards for safety and security while providing scalable capacity at the lowest possible cost for our customers. You’ll experience an inclusive culture that welcomes bold ideas and empowers you to own them to completion. We’re looking for a Senior Data Engineer to help grow our Data Lake and Data Warehouse Systems, built using a serverless architecture with 100% native AWS components including Redshift Spectrum, Athena, S3, Lambda, Glue, EMR, Kinesis, SNS, CloudWatch and more. We own a world-class data lake used to drive multi-billion dollar decisions and aim to fill the lake quickly with minimal manual intervention and democratized data access. Our Data Engineers build ETL and analytics solutions for internal customers to answer questions with data and drive critical improvements for the business. Our Data Engineers use best practices in software engineering, data management, data storage, data compute, and distributed systems. We are passionate about solving business problems with data. Responsibilities Fixing automation issues daily Quality of Works / Fixes Requirements Develop and maintain automated ETL pipelines (with monitoring) using scripting languages such as Python, Spark, SQL and AWS services such as S3, Glue, Lambda, SNS, SQS, KMS. Implement and support reporting and analytics infrastructure for internal business customers. Develop and maintain data security and permissions solutions for enterprise-scale data warehouse and data lake implementations including data encryption and database user access controls and logging. Develop data objects for business analytics using data modeling techniques. Develop and optimize data warehouse and data lake tables using best practices for DDL, physical and logical tables, data partitioning, compression, and parallelization. Develop and maintain data warehouse and data lake metadata, data catalog, and user documentation for internal business customers. Work with internal business customers and software development teams to gather and document requirements for data publishing and data consumption via data warehouse, data lake, and analytics solutions. Required Qualifications 5 years of data engineering experience Experience with data modeling, warehousing and building ETL pipelines Experience with SQL Experience in at least one modern scripting or programming language, such as Python, Java, Scala, or NodeJS Experience mentoring team members on best practices Preferred Qualifications Past industry preference - data center field Experience with big data technologies such as Hadoop, Hive, Spark, EMR Experience operating large data warehouses Degree or Certification Bachelors required - (Computer Science preferred, but experience in the data field is ok) Leadership Principles Bias for Action Deliver Results Ownership Invent and Simplify Skills Cloud Technologies (e.g., Microsoft AWS) - 3yrs Python - 2yrs SQL - 3yrs Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities. #J-18808-Ljbffr