Senior Data Engineer - TS/SCI+

Job summary
Amazon Web Services (AWS), Worldwide Public Sector (WWPS), MVP Analytics & Data Engineering Team (MADE) is seeking a Data Engineer who will be responsible for developing and managing big data systems. The ideal candidate will possess a deep understanding of data engineering fundamentals and best practices, with the skills and experience to develop autonomous, scalable programs. Familiarity and exposure to data warehousing and cloud-based service offerings are also requirements to raise the bar in this role. The Data Engineer will be responsible for scaling existing infrastructure, incorporating new data sources, and building robust data pipelines for production level systems. In partnership with business intelligence engineers and analysts, the Data Engineer will work backwards from the customer to build reliable and scalable data solutions to meet the business needs. Finally, this individual will work closely with project management teams to ensure proper guidance, use cases, and documentation is available to our Sales and Operations teams.

***This position requires that the candidate selected be a US Citizen and must currently possess and maintain an active TS/SCI security clearance with polygraph.

Responsibilities include:
• Understand existing databases and warehouse structures in order best determine how to consolidate and aggregate data in an efficient and scalable way.
• Design and code all aspects of data solutions using Amazon Redshift, SQL Server, and/or Aurora to build out an Operations data warehouse.
• Create and propose technical design documentation, which includes current and future ETL functionality, database objects affected, specifications, and flows and diagrams to detail the proposed implementation.
• Design, develop, implement, test, document, and operate large-scale, high-volume, high-performance data structures for business intelligence analytics.
• Implementing data structures using best practices in data modeling to provide on-line reporting and analysis using business intelligence tools and a logical abstraction layer against large, multi-dimensional datasets and multiple sources.
• Evaluating and making decisions around dataset implementations designed and proposed by peer data engineers.
• Manage AWS resources including Aurora, EC2, Redshift, S3, Lambda etc. Explore and learn the latest AWS technologies to provide new capabilities and increase efficiency.
• Participating in the full development life cycle, end-to-end, from design, implementation and testing, to documentation, delivery, support, and maintenance to produce comprehensive, usable dataset documentation and metadata

Basic qualifications
• Degree in Computer Science, Engineering, Mathematics, or a related field and 5+ years industry experience
• Must have one year of experience in the following skill(s): (1) Developing and operating large-scale ETL/ELT processes; database technologies; data modeling (2) Experience with at least one relational database technology such as Redshift, RDS, Oracle, Postgres
• Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets
• 4+ year of coding experience with modern programming or scripting language (Python, Scala, Java, C# etc.).
• Advanced SQL and query performance tuning skills
• Experience with at least one massively parallel processing data technology such as Redshift, Spark or Hadoop based big data solutions

Preferred qualifications
• Master's/PhD degree in or Computer Science, Engineering, Mathematics or related discipline
• Experience building data products incrementally and integrating and managing datasets from multiple sources
• Experience operating a very large data environment that may include data lake, lakehouse, data warehouse, etc.
• Query performance tuning skills using Unix/Linux profiling tools and SQL
• Experience with AWS Tools and Technologies (Aurora, Redshift, S3, EC2, Glue, Lambda, Sage Maker)
• Experience creating visual data representations, such as Tableau, PowerBI, QuickSight or other BI platforms
• Meets/exceeds Amazon’s leadership principles requirements for this role
• Meets/exceeds Amazon’s functional/technical depth and complexity

Amazon Terms:
Amazon Web Services (AWS) is the leading cloud provider, providing virtualized infrastructure, storage, networking, messaging, and many other services to customers all over the world. AWS runs a globally distributed environment, operating at massive levels of scale. Businesses, educational institutions and governments depend on AWS for secure cloud services and solutions.

Here at AWS, we embrace our differences. We are committed to furthering our culture of inclusion. We have ten employee-led affinity groups, reaching 40,000 employees in over 190 chapters globally. We have innovative benefit offerings, and we host annual and ongoing learning experiences, including our Conversations on Race and Ethnicity (CORE) and AmazeCon (gender diversity) conferences. Amazon’s culture of inclusion is reinforced within our 14 Leadership Principles, which remind team members to seek diverse perspectives, learn and be curious, and earn trust.

Our team puts a high value on work-life balance. It isn’t about how many hours you spend at home or at work; it’s about the flow you establish that brings energy to both parts of your life. We believe striking the right balance between your personal and professional life is critical to life-long happiness and fulfillment. We offer flexibility in working hours and encourage you to find your own balance between your work and personal lives.

Our team is dedicated to supporting new members. We have a broad mix of experience levels and tenures, and we’re building an environment that celebrates knowledge sharing and mentorship. We care about your career growth and strive to assign projects based on what will help each team member develop into a better-rounded professional and enable them to take on more complex tasks in the future.

By working together on behalf of our customers, we are building the future one innovative product, service, and idea at a time. Are you ready to embrace the challenge? Come build the future with us.

Basic Qualifications

• At least 5+ years of Redshift/MySQL/Amazon Aurora/Postgres Database experience
• At least 5+ years of work experience writing and debugging advanced SQL queries (ETL, data modeling, data mining, database design, business intelligence architectures, etc) with large-scale, complex data sets in a business setting
• At least 2+ years of experience in data guard, data replication, application scalability and high-availability architecture
• Bachelor's degree in Computer Science or related field
• Design and code all aspects of data solutions using Amazon Redshift to build out an Operations data warehouse
• Create and propose technical design documentation, which includes current and future ETL functionality, database objects affected, specifications, and flows and diagrams to detail the proposed implementation
• Use PL/SQL or any shell scripting language to perform archiving, statistics collection and other database related tasks
• On-call support required

Have questions? Want to Apply? Contact Bilal Malik directly - btmalik@amazon.com

Preferred Qualifications

• Become a subject matter expert in database best practices and be able to produce ad-hoc analysis quickly
• Manage backup and recovery functions for data warehouse environment.
• Become a subject matter expert in database best practices and be able to produce ad-hoc analysis quickly
• Manage backup and recovery functions for data warehouse environment.
• Understand existing databases and warehouse structures in order to best determine how to consolidate and aggregate data in an efficient and scalable way.
• Working knowledge of DBA best practices (e.g., schema management, index optimization, OS-level tuning, Network management, etc.)
• Query and database tuning skills
• Capacity monitoring and management capabilities
• Experience with terabyte databases
• Experience with high-volume database systems
• Working knowledge of one of scripting languages (Python, Ruby, Perl)
• Knowledge and experience with AWS persistence offerings (DynamoDB, Redshift, EC2, S3, etc.)
• Experience with NOSQL solutions
• Ability to manage multiple tasks with shifting priorities
• Ability to build and maintain strong working relationships with DBA and application teams
• Experience with database security configurations, administration, and access management for a large organization (500+ employees)
• Experience performing advanced predictive analytics including regression analyses, statistics-based forecasting, and econometric modeling
• Meets/exceeds Amazon’s leadership principles requirements for this role
• Meets/exceeds Amazon’s functional/technical depth and complexity

Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit https://www.amazon.jobs/en/disability/us.