New

Data Engineer

Ampcus, Inc
United States, Washington, Seattle
Jun 12, 2025
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: Data Engineer Location(s): Seattle, WA Job Description: Come build the future of entertainment with us. Are you interested in shaping the future of movies and television? Do you want to define the next generation of how and what client customers are watching? Prime Video is a premium streaming service that offers customers a vast collection of TV shows and movies - all with the ease of finding what they love to watch in one place. We offer customers thousands of popular movies and TV shows from Originals and Exclusive content to exciting live sports events. We also offer our members the opportunity to subscribe to add-on channels which they can cancel at anytime and to rent or buy new release movies and TV box sets on the Prime Video Store. Prime Video is a fast-paced, growth business - available in over 240 countries and territories worldwide. The team works in a dynamic environment where innovating on behalf of our customers is at the heart of everything we do. If this sounds exciting to you, please read on. The team presents opportunities to work on very large data sets in one of the world's largest and most complex data warehouse environments. Our data warehouse is built on cloud technologies like Redshift, Kinesis, Lambda, S3, MWAA, performing ETL processing on multi terabytes of relational data in a matter of hours. Our team is serious about great design and redefining best practices with a cloud-based approach to scale, resilience and automation. Key job responsibilities You'll solve data warehousing problems on a massive scale and apply cloud-based services to solve challenging problems around: big data processing, data warehouse design, self-service data access, automated data quality detection and building infrastructure as a code. You'll be part of the team that focuses on automation and optimization for all areas of DW/ETL maintenance and deployment. You'll work closely with global business partners and technical teams on many non-standard and unique business problems and use creative problem solving to deliver data products that underpin Prime Video strategic decision making, from content selection to on-platform customer experience. You'll develop efficient systems and tools to process data, using technologies than can scale to seasonal spikes and easily accommodate future growth. Your work will have a direct impact on the day-to-day decision making across Prime Video. Basic qualifications Experience with data modeling, warehousing and building ETL pipelines. Experience with one or more query language (e.g., SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, Scala). Experience with one or more scripting language (e.g., Python, KornShell). Experience with SQL. Experience as a Data Engineer or in a similar role. Preferred qualifications Experience with big data technologies such as: Hadoop, Hive, Spark, EMR. Experience with any ETL tool like, Informatica, ODI, SSIS, BODI, Datastage, etc. Database Experience: Specifically mentioned Redshift or Snowflake as ideal. experience with MPP (Massively Parallel Processing) RDBMS. be able to write SQL on top of databases. 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.