Data Engineer II

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.

Responsibilities:

• You are a smart, collaborative person who takes ownership and gets things done, curious about cloud-based tools, architectures, and languages, capable of breaking technical requests into manageable tasks, and comfortable asking for help and raising concerns as needed.
• You have foundational, hands-on experience with at least one cloud platform (AWS, Azure, GCP), at least one programming language (e.g. Python, Java), and demonstrated experience with SQL data modeling.
• You will leverage strong technical skills to build, implement, and improve cloud-based data pipelines, design and implement data models that ensure data accuracy, completeness, and consistency, develop maintainable infrastructure, DevOps, and standards for a robust EDW, troubleshoot and resolve issues related to production cloud resources, and learn and adapt to new tools and techniques.
• You will leverage strong communication skills to consult with business clients to gather technical requirements for data ingestions and models, communicate solution design pros and cons to the team technical lead, explain technical problems to leadership, business, and other developers, and document processes and standards.

Qualifications You Must Have:

• Bachelor's Degree in a related field with at least 2 years of relevant experience
  • Higher education may substitute for relevant experience
  • Relevant experience may be considered in lieu of required education
• Working SQL knowledge and experience working with relational databases
• Experience with AWS cloud services: S3, Redshift, Glue
• Experience building data pipelines, architectures, 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
• Operational responsibilities (schedules, monitoring, logging, alerting, error handling, etc.)

Qualifications We Prefer:

• Experience performing root cause analysis on data to answer specific business questions or issues
• Experience with AWS cloud services: EC2, RDS, Lambda, Step Functions, Athena, CloudWatch, ECS, IAM
• Experience with AWS security: best practices, AWS KMS, AWS Secrets Manager
• Experience with object-oriented scripting languages and frameworks: Python (BOT03), PySpark, Java, etc
• Source system integration patterns (SQL, APIs)
• Master Data Management (MDM) Solution experience
• DevOps experience

Estimated Starting Salary Range: $108,496.89 - $149,183.22. Compensation varies depending on a wide array of factors, such as candidates' key skills, relevant work experience, and education/training/certifications. The disclosed range estimate may be adjusted for any applicable geographic differential associated with the location at which the position may be filled.

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!

SNC is an Equal Opportunity Employer committed to an environment free of discrimination. Employment decisions are made based on merit without regard to race, color, age, religion, sex, national origin, disability, status as a protected veteran or other characteristics protected by law.