Are you ready to apply your advanced technical abilities? Dream, Innovate, Inspire and Empower the next generation to transform humanity through technology and imagination! As a Data Engineer III 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 and continuously improve 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). The Data Engineer III also identifies and creates data management practices and processes to be included in the technical architectural standard.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 :
- Collaborate with stakeholders, business systems analysts, and other project team members to understand their functional and non-functional data requirements and design data models that meet those needs.
- Develop and maintain data dictionaries, data lineage, and other metadata artifacts to ensure that data is well-governed, accurate and supports authoritative data sourcing.
- Document and model existing ETL processes to provide insight into current data integrations, areas of opportunity to consolidate or streamline, and / or removing redundancies.
- Support and help define the data strategy and cleansing activities for AI initiatives.
- Design, build, and maintain RPAs for data ingestion that are scalable and efficient to bolster accuracy in QA and system testing.
- Partner with program management office and business systems analysts to support the elicitation and cultivation of business needs to translate into detailed requirements documentation; focus will be on the data aspects of the needs to support successful delivery of projects including managing the transition to sustainment.
Qualifications You Must Have :
Bachelor's Degree in a related field with at least 6 years of relevant experienceHigher education may substitute for relevant experienceRelevant experience may be considered in lieu of required educationAdvanced working SQL knowledge and experience working with relational databases, query authoring (SQL), and familiarity with a variety of databasesExperience with AWS cloud services : S3, Redshift, GlueExperience building and optimizing data pipelines, architectures and data setsExperience performing root cause analysis on data to answer specific business questions or issuesExperience with object-oriented scripting languages and frameworks : PythonSource system integration patterns (SQL, APIs)Operational responsibilities (schedules, monitoring, logging, alerting, error handling, etc.)DevOps experienceQualifications We Prefer :
Understanding of data modeling approaches and their applicationsProficiency with SQL, Power Automate, IaC (Terraform), and DevOpsExperience building and optimizing data pipelines, architectures and data setsAbility to perform root cause analysis on data to answer specific business questions or issuesDefining source system integration patternsUnderstanding of machine learning techniques, LLMs, and Azure FoundryFamiliarity with ArchiMate modeling semanticsExperience with Azure and AWS cloud servicesStrong knowledge of project planning / execution and solid understanding of analysis and software development lifecycle methodologiesKnowledgeable on the technologies that support day-to-day business execution in addition to business application development, implementation, and sustainmentStrong presentation, facilitation, collaboration, negotiation and influencing skillsExperience performing root cause analysis on data to answer specific business questions or issuesExperience with AWS cloud services : EC2, RDS, Lambda, Step Functions, Athena, CloudWatch, ECS, IAMExperience with AWS security : best practices, AWS KMS, AWS Secrets ManagerExperience with object-oriented scripting languages and frameworks : Python (BOT03), PySpark, Java, etcMaster Data Management (MDM) Solution experienceThis posting will be open for application for a minimum of 5 days and may be extended based on business needs.
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 .
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.
SNC is a global leader in aerospace and national security committed to moving the American Dream forward. We’re 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 nation’s 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.