July 20, 2024
Apply Now
Lynnwood, WA, United States
July 20, 2024
Apply NowJob description
Job Brief
This position is eligible for our Crane Flex Hybrid schedule which allows for the option of up to 2 days/week of work-from-home.
Crane Aerospace & Electronics is hiring for a Data Engineer I to join our IT team to build a data lake based on ERP systems located in Lynnwood, WA.
This is a hybrid position at our location in Lynnwood, WA.
About Crane:
Crane Aerospace & Electronics supplies critical systems and components to the aerospace and defense markets. You’ll find Crane Aerospace & Electronics in some of the toughest environments: from engines to landing gear; from satellites to medical implants and from missiles to unmanned aerial systems (UAS).
Located in the epicenter of United States aviation manufacturing, our Crane Aerospace & Electronics Lynnwood, Wash., facility delivers industry-leading aerospace & defense power and fluid solutions. Our products are rugged enough to fly 5 billion miles from Earth on NASA’s New Horizons spacecraft and innovative enough to be featured on Eviation’s Alice all-electric aircraft. You’ll join a group of aerospace professionals committed to engineering excellence and work in a community tucked between the idyllic Puget Sound and Cascade Mountains. Start the next chapter of your career with Crane Aerospace & Electronics!
Job Summary:
The Data Engineer I will be responsible for supporting and updating existing data warehouse solutions based on ERP system as well as creating new analytics & data solution using combination of Oracle Fusion cloud & Microsoft Azure BI stack. The Data Engineer I will partner with Senior Data Architect and our business teams to identify data integration opportunities, define functional and non-functional requirements for technology or process solutions, and develop data workflows and processes to achieve an analytics solution.
To find success in this role, you should be familiar with relational databases, dimensional warehouse and scripting languages such as Python/R/SQL, knowledgeable of a variety of techniques to provide actionable insights while familiar with manipulating, cleaning, and analyzing large datasets. Successful candidates will be comfortable with ambiguity and able to converse with Data Architect/Business analyst to better understand data and business problems.
Essential Functions:
Salary range: $76,400 - $91,600. Several factors contribute to actual salary, including experience in a similar role or performing comparable job responsibilities, skills, training, and other qualifications. Some roles may be eligible for participation in performance-based bonus programs.
As a team member at Crane Aerospace and Electronics, you’ll enjoy:
We are committed to operational excellence and world class processes. We employ Lean manufacturing techniques to optimize manufacturing efficiency and accuracy on all product lines. Our products are known for their technical strength, proven reliability and overall value.
In our efforts to maintain a safe and drug-free workplace, Crane Aerospace & Electronics requires that candidates complete a satisfactory background check. FAA sensitive positions require employees to participate in a random drug test pool.
This description has been designed to indicate the general nature and level of work being performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.
Crane Company is an Equal Opportunity Employer and does not discriminate on the basis of race, color, creed, religion, sex, national origin, marital status, age, sexual orientation, gender identity, disability, pregnancy, medical condition, genetic information, protected veteran status or any other characteristic protected under federal, state, or applicable local law.
This position is eligible for our Crane Flex Hybrid schedule which allows for the option of up to 2 days/week of work-from-home.
Crane Aerospace & Electronics is hiring for a Data Engineer I to join our IT team to build a data lake based on ERP systems located in Lynnwood, WA.
This is a hybrid position at our location in Lynnwood, WA.
About Crane:
Crane Aerospace & Electronics supplies critical systems and components to the aerospace and defense markets. You’ll find Crane Aerospace & Electronics in some of the toughest environments: from engines to landing gear; from satellites to medical implants and from missiles to unmanned aerial systems (UAS).
Located in the epicenter of United States aviation manufacturing, our Crane Aerospace & Electronics Lynnwood, Wash., facility delivers industry-leading aerospace & defense power and fluid solutions. Our products are rugged enough to fly 5 billion miles from Earth on NASA’s New Horizons spacecraft and innovative enough to be featured on Eviation’s Alice all-electric aircraft. You’ll join a group of aerospace professionals committed to engineering excellence and work in a community tucked between the idyllic Puget Sound and Cascade Mountains. Start the next chapter of your career with Crane Aerospace & Electronics!
Job Summary:
The Data Engineer I will be responsible for supporting and updating existing data warehouse solutions based on ERP system as well as creating new analytics & data solution using combination of Oracle Fusion cloud & Microsoft Azure BI stack. The Data Engineer I will partner with Senior Data Architect and our business teams to identify data integration opportunities, define functional and non-functional requirements for technology or process solutions, and develop data workflows and processes to achieve an analytics solution.
To find success in this role, you should be familiar with relational databases, dimensional warehouse and scripting languages such as Python/R/SQL, knowledgeable of a variety of techniques to provide actionable insights while familiar with manipulating, cleaning, and analyzing large datasets. Successful candidates will be comfortable with ambiguity and able to converse with Data Architect/Business analyst to better understand data and business problems.
Essential Functions:
- SQL Programming, PL/SQL, Data Analysis and Data Modeling.
- Maintain/Update existing data platform solutions and data models created using Azure platform/Power BI.
- Build Data Integrations to provide quality data.
- Build KPIs and metrics to support business.
- Understand user requirements for how data is used to make decisions. Includes process mapping, optimization, and technology enablement.
- Extract data from various data sources; perform exploratory data analysis, cleanse, massage, and aggregate data to develop end to end data and analytics solutions.
- Help support day to day activities of the Modern Analytics team; this may include creating knowledge base articles, updates to platform manuals and documentation, best practices and guidance, and diagnostics of issues that are raised as well as promoting and advocating for the value of advanced modeling techniques.
- Participate in demos and user acceptance reviews while working with the technical team on the creation of design documents and artifacts.
- Collaborate with others on the team and business teams to deliver new, innovative solutions to Crane Aerospace & Electronics users.
- Desire to learn new areas and tools required to enable BI solutions.
- Interact with infrastructure teams to coordinate technology deployment.
- Experience: 0-2 years of experience working on Data Extract, Load and Transform, data Warehouses and dimensional modelling.
- Knowledge: Understanding of Relational Databases, dimensional data warehouse, ETL processes .
- Skills/Abilities: Strong problem-solving skills with an emphasis on analysis and resolution of complex functional areas and technical issues across teams.
- Education/Certification: Bachelor or higher degree in computer science, Engineering, Information Systems, or other quantitative fields.
- Eligibility Requirement: This position may require access to Controlled Data or Information. Where the position requires such access only US Persons will be considered. As a US Department of Defense contractor, we are bound by International Traffic in Arms Regulations (ITAR).
- Knowledge about Azure Services, Databricks, Synapse.
- Data science training or experience working with structured and/or unstructured datasets.
- Python, Py-Spark or similar technologies.
- Knowledge of machine learning tools.
- Familiarity with custom development, open-source products implementation, systems integration.
- Standard office environment.
- Work requires substantial visual concentration on detail.
- Working conditions are normal for a manufacturing environment.
- Manufacturing operations may require the use of safety equipment to include but not limited to: eye safety glasses, gowns, masks, hearing protectors, heel/wrist straps and any other required PPE.
- May be exposed to unusual environmental conditions such as loud noises, cold temperatures, confined spaces, dust, or fumes.
- Ability to carry laptops and other equipment weighing up to 25 lbs.
- Ability to travel to various Crane Co locations, if and as required for projects.
Salary range: $76,400 - $91,600. Several factors contribute to actual salary, including experience in a similar role or performing comparable job responsibilities, skills, training, and other qualifications. Some roles may be eligible for participation in performance-based bonus programs.
As a team member at Crane Aerospace and Electronics, you’ll enjoy:
- Benefits: Health care, dental or life insurance starting the first day of the month
- Time Off: 15 days of paid time off that start accruing your first day at Crane and 12 paid holidays per year.
- 401k Retirement Plan: 401k plan with company match
- Education Reimbursement: eligible after 90 days of employment
- Flexible work schedule: This position is eligible for our Crane Flex Hybrid schedule which allows for the option of up to 2 days/week of work-from-home. Some conditions apply which will be discussed during the interview process. Full policy to be provided after hire.
We are committed to operational excellence and world class processes. We employ Lean manufacturing techniques to optimize manufacturing efficiency and accuracy on all product lines. Our products are known for their technical strength, proven reliability and overall value.
In our efforts to maintain a safe and drug-free workplace, Crane Aerospace & Electronics requires that candidates complete a satisfactory background check. FAA sensitive positions require employees to participate in a random drug test pool.
This description has been designed to indicate the general nature and level of work being performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.
Crane Company is an Equal Opportunity Employer and does not discriminate on the basis of race, color, creed, religion, sex, national origin, marital status, age, sexual orientation, gender identity, disability, pregnancy, medical condition, genetic information, protected veteran status or any other characteristic protected under federal, state, or applicable local law.
