Are you looking to leverage your technical creativity? Dream, Innovate, Inspire and Empower the next generation to transform humanity through technology and imagination! As a Data Engineer II you’ll design, develop, document, test, and debug new and existing cloud-based data pipelines and transformations. You will participate in design meetings and consult with business clients to develop processes and structures that ingest data from multiple sources into our cloud-based Enterprise Data Warehouse (EDW). Within the EDW, you will use a variety of tools to implement data integration, master data management, data lifecycle management, data security, data quality management, metadata management, and reporting and analytics. Additionally, you will perform defect corrections (analysis, design, code).
As SNC’s corporate team, we provide the company and its business areas with strategic direction and business support spanning executive management, finance and accounting, operations, human resources, legal, IT, information security, facilities, marketing, and communications.
*This role is open to a hybrid schedule or 100% remote work in most states
Responsibilities:
Develop, maintain and optimize data pipelines and workflows on AWS using tools such as AWS Glue, AWS Lambda, and AWS Step Functions.
Design and implement data models that ensure data accuracy, completeness, and consistency.
Collaborate with stakeholders and analysts to identify data requirements and develop solutions that meet their needs.
Troubleshoot and resolve issues related to data pipelines, data quality, and data modeling.
Develop and maintain documentation of data pipelines, data models, and other data-related processes.
Implement security and compliance measures to ensure data is protected and meets regulatory requirements.
Continuously monitor and optimize production data pipelines and data models to improve performance and efficiency.
Keep up-to-date with industry trends and advancements in data engineering and AWS services.
Communicate effectively with stakeholders to provide updates on project progress and escalate issues when necessary.
Must-haves:
Bachelor’s Degree in a related field with at least 3 years of relevant experience
Higher education may substitute for relevant experience
Relevant experience may be considered in lieu of required education
Working knowledge of SQL and experience working with relational databases
Experience with AWS or Azure cloud services
Experience building data pipelines and data sets
Experience performing root cause analysis on data to answer specific business questions or issues
Experience with object-oriented scripting languages and frameworks such as: Python or JAVAScript
Operational responsibilities (schedules, monitoring, logging, alerting, error handling, etc.)
Experience using source control such as git and familiarity with software development lifecycle
Preferred Skills:
Experience with Data Warehouse technologies such as Redshift, Snowflake, or Synapse
Experience using GitHub Actions for orchestrating code deployments
Experience with Infrastructure-as-Code such as Terraform, CloudFormation, Azure Bicep
Experience with common Data Engineering tools such as Pandas, Airflow, and dbt?
Estimated Starting Salary Range: $91,154.71 – $125,337.72. SNC considers several factors when extending job offers, including but not limited to candidates key skills, relevant work experience, and education/training/certifications.
SNC offers a generous benefit package, including medical, dental, and vision plans, 401(k) with 150% match up to 6%, life insurance, 3 weeks paid time off, tuition reimbursement, and more ( .
IMPORTANT NOTICE:
To conform to U.S. Government international trade regulations, applicant must be a U.S. Citizen, lawful permanent resident of the U.S., protected individual as defined by 8 U.S.C. 1324b(a)(3), or eligible to obtain the required authorizations from the U.S. Department of State or U.S. Department of Commerce.
Learn more about the background check process for Security Clearances. (
SNC is a global leader in aerospace and national security committed to moving the American Dream forward. Were known and respected for our mission and execution focus, agility, and disruptive and rapid innovation. We provide leading edge technologies and transformative solutions that support our nations most critical security needs. If you are mission-focused, thrive in collaborative environments, and want to make our country stronger with state-of-the-art technologies that safeguard freedom, join our team!
As an Equal Opportunity Employer, we welcome our employees to bring their whole selves to their work. SNC is committed to fostering an inclusive, accepting, and diverse environment free of discrimination. Employment decisions are made without regarding to race, color, age, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran or other characteristics protected by law. Contributions to SNC come in many shapes and styles, and we believe diversity in our workforce fosters new and greater ways to dream, innovate, and inspire.
Git pandas Python aws-step-functions Terraform Amazon Web Services (AWS) Amazon Redshift aws-lambda GitHub Actions Data Engineering Azure JavaScript snowflake-cloud-data-platform amazon-cloudformation SQL Airflow aws-glue synapse DBT