Hybrid Data Engineer III

at Sierra Nevada Corporation

• Job title: Data Engineer III
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: Amazon Redshift, AWS, Azure, Cloud, ETL, Python, SQL, Terraform
• Location requirements: Hybrid, Sparks, United States

About the role

• Data Engineer III designing, developing, and optimizing cloud-based data pipelines for SNC. Collaborating with stakeholders to implement data integration and management processes across the organization.

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.

Requirements

• Bachelor's Degree in a related field with at least 6 years of relevant experience
• Higher education may substitute for relevant experience
• Relevant experience may be considered in lieu of required education
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL), and familiarity with a variety of databases
• Experience with AWS cloud services: S3, Redshift, Glue
• Experience building and optimizing 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: Python
• Source system integration patterns (SQL, APIs)
• Operational responsibilities (schedules, monitoring, logging, alerting, error handling, etc.)
• DevOps experience
• Understanding of data modeling approaches and their applications (Preferred)
• Proficiency with SQL, Power Automate, IaC (Terraform), and DevOps (Preferred)
• Understanding of machine learning techniques, LLMs, and Azure Foundry (Preferred)
• Familiarity with ArchiMate modeling semantics (Preferred)
• Strong knowledge of project planning/execution and solid understanding of analysis and software development lifecycle methodologies (Preferred)

Benefits

• medical, dental, and vision plans
• 401(k) with 150% match up to 6%
• life insurance
• 3 weeks paid time off
• tuition reimbursement
• more