Senior Data Engineer, MVP Analytics & Data Engineering

Amazon

Today
Top Secret/SCI
Unspecified
Polygraph
IT - Data Science
Arlington, VA (On-Site/Office)

DESCRIPTION

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.

Key job responsibilities
Analyze existing databases and warehouse structures to determine the most efficient and scalable methods for consolidating and aggregating data.

Design and develop all components of data solutions using Amazon Redshift and Amazon Aurora Postgres to create an Operations data warehouse.

Create and propose technical design documentation, including:
- Current and future ETL functionality
- Affected database objects
- Specifications, data flows, and diagrams detailing the proposed implementation

Design, develop, implement, test, document, and operate large-scale, high-volume, high-performance data structures for business intelligence analytics.

Implement data structures using best practices in data modeling to enable online reporting and analysis, leveraging:
- Business intelligence tools
- A logical abstraction layer for large, multi-dimensional datasets from multiple sources

Evaluate and provide feedback on dataset implementations designed and proposed by peer data engineers.

Manage AWS resources, including EC2, Redshift, S3, and others, while:
- Exploring and adopting the latest AWS technologies to enhance capabilities and efficiency

Participate in the full development lifecycle-from design, implementation, and testing to documentation, delivery, support, and maintenance-to produce comprehensive, usable dataset documentation and metadata.

Translate internal customer business requirements into repeatable, maintainable automated data engineering processes

A day in the life
About AWS
AWS values diverse experiences. Even if you do not meet all of the preferred qualifications and skills listed in the job description, we encourage candidates to apply. If your career is just starting, hasn't followed a traditional path, or includes alternative experiences, don't let it stop you from applying.

Why AWS? Amazon Web Services (AWS) is the world's most comprehensive and broadly adopted cloud platform. We pioneered cloud computing and never stopped innovating - that's why customers from the most successful startups to Global 500 companies trust our robust suite of products and services to power their businesses.

Inclusive Team Culture Here at AWS, it's in our nature to learn and be curious. Our employee-led affinity groups foster a culture of inclusion that empower us to be proud of our differences. Ongoing events and learning experiences, including our Conversations on Race and Ethnicity (CORE) and AmazeCon conferences, inspire us to never stop embracing our uniqueness.

Mentorship & Career Growth We're continuously raising our performance bar as we strive to become Earth's Best Employer. That's why you'll find endless knowledge-sharing, mentorship and other career-advancing resources here to help you develop into a better-rounded professional.

Work/Life Balance We value work-life harmony. Achieving success at work should never come at the expense of sacrifices at home, which is why we strive for flexibility as part of our working culture. When we feel supported in the workplace and at home, there's nothing we can't achieve in the cloud.

BASIC QUALIFICATIONS

- Bachelor's degree in Computer Science, Engineering, Mathematics, or a related field, plus 5+ years of industry experience.
- Minimum of 4 year of experience with the following skills:
- Developing and operating large-scale ETL/ELT processes, database technologies, and data modeling
- Working with at least one relational database technology (e.g., Redshift, Oracle, Postgres, SQL Server)
- Experience building and operating highly available, distributed systems for data extraction, ingestion, and processing of large datasets.
- 4+ years of coding experience with a modern programming or scripting language (e.g., Python, Scala, Java, C#, PowerShell).
- Advanced SQL skills with expertise in query performance tuning.
- Experience with at least one massively parallel processing data technology (e.g., Redshift, Spark, or Hadoop-based big data solutions).
- Experience with one or more Python-based data analysis libraries (i.e. Pandas and/or Polars)
- Current, active US Government Security Clearance of TS/SCI with Polygraph

PREFERRED QUALIFICATIONS

- Master's or PhD in Computer Science, Engineering, Mathematics, or a related discipline.
- Experience building data products incrementally and managing datasets from multiple sources.
- Experience operating very large data environments, such as data lakes, lakehouses, or data warehouses.
- Query performance tuning expertise using Unix/Linux profiling tools and SQL.
- Proficiency with AWS tools and technologies (e.g., SNS, Redshift, RDS, S3, EC2, Athena, Glue, Lambda, SageMaker, EC2 Load Balancing, AWS Diode, EventBridge, Cloudwatch Logs, SQS, Route 53).
- Experience creating visual data representations using BI platforms (e.g., Tableau, Power BI, QuickSight).
- Experience with Tableau Server configuration and administration, and Tableau Site administration.

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.

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you're applying in isn't listed, please contact your Recruiting Partner.

Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $139,100/year in our lowest geographic market up to $240,500/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits . This position will remain posted until filled. Applicants should apply via our internal or external career site.
group id: amazon

AWS Cleared Jobs: Why I Chose AWS

Find Amazon on Social Media
Network Employers (29)
A
Recruiter
L
Recruiter
L
Recruiter
C
Recruiter
A
Recruiter
About Us
AWS cleared jobs bring secure, commercial-cloud technology to U.S. Intelligence Community missions. Our Amazon Dedicated Cloud team develops, deploys, and operates tools on air-gapped networks that enable a full-cloud environment at multiple classification levels. This gives our government clients the technology they need to stay ahead of threats and keep our nation safe. As a cleared professional at AWS, you’ll modernize how we solve problems and ensure our customers’ success by working with emerging technologies like cloud storage, advanced machine learning, and AWS Ground Station. Our team members are the best and brightest from a diverse set of professional, academic, and cultural worlds, giving the team a highly collaborative and dynamic feel. If you’re ready to create new mission-critical solutions for the federal government, we have roles for both cleared and clearable technical professionals.

Amazon Jobs


Job Category
IT - Data Science
Clearance Level
Top Secret/SCI
Employer
Amazon