Data Engineer II

Crane Aerospace & Electronics; Lynnwood (WA); On-site; USD 100,000 - 129,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision care

Life and disability insurance

15 days paid time off

401k with company match

Education reimbursement

Job summary

Crane Aerospace & Electronics is seeking a Data Engineer II to join the Lynnwood IT team onsite. You will help build a data lake/warehouse architecture leveraging ERP sources such as Oracle EBS and Fusion Cloud, while delivering Azure-based analytics solutions to drive decision making.

The role requires 3–4 years in data warehousing, strong SQL/ETL skills, and collaborative work with data architects and analysts to deliver scalable data workflows and KPI reporting using Power BI.

Qualifications

• Experience in building Data Warehouses and dimensional models with ETL development.
• Experience with Azure cloud services and data analytics tools.
• Strong SQL skills and data modeling capabilities.
• Ability to extract, transform and load data across ERP sources.

Responsibilities

• Develop and maintain data lake/warehouse solutions on Azure.
• Create data workflows and KPIs to support business decisions.
• Collaborate with IT and business teams on analytics projects.
• Perform data quality checks and troubleshooting.
• Assist with POCs using ML/AI technologies.

Skills

SQL

Azure

Power BI

Python

ETL

Data Warehousing

Oracle EBS

Fusion Cloud

Education

Bachelor's degree in CS/Engineering/IS

Tools

Azure Synapse

Databricks

Oracle EBS

Fusion Cloud

Power BI

Job description

Onsite

Lynnwood, Washington

Full time

JR102419

Crane Aerospace and Electronics has an exciting opportunity for a Data Engineer II at our Lynnwood, WA location. This is an on-site position.

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. 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!

We are seeking a Data Engineer **** II to join ourIT team to build a data lake based on ERP systems. TheData Engineer will be responsible for supporting enhancing existing D ata Analytics Platform Solutions using data platform such as but not limited to Oracle EBS, Oracle Fusion cloud & Microsoft Azure . This role will partner with Senior team members and business teams to identify data integration opportunities, define functional and non-functional requirements, and develop data workflows and processes to deliver an analytics solution.

The candidate should be knowledgeable of a variety of techniques to provide actionable insights while familiar with manipulating, cleaning, and analyzing large datasets. The candidate must also be trained in one or more programming languages and must have familiarity with software development tools and life cycle. The candidate must be comfortable with ambiguity and able to converse with Data Architect/Business analyst to better understand data and business problems.

Essential Functions:

• Possess knowledge and technical expertise in developing complex SQL queries, stored procedures, and views to perform 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.

• Job monitoring and troubleshooting.

• Support Business Analysts by understanding their requirements and reporting tools.

• Perform POCs using various machine learning and AI technologies.

• Implement appropriate Azure services related to data and analytics to build Enterprise Data warehouse/Data Lake.

• Help support day to day activities of the 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 IT 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.

Minimum Qualifications:

Experience: 3-4 years of demonstrated experience building Data Warehouses and dimensional models with ETL development.

• 1-2 years of experience building reports, and dashboards using tools such as Tableau, Power BI, QLIK.T-SQL Programming, PL/SQL.

Knowledge/Skills: Understanding of Relational Databases, dimensional data warehouse, ETL processes.

• Experience with Cloud services such as Azure/AWS/GCP/OIC;

• Strong problem-solving skills with an emphasis on analysis and resolution of complex functional areas and technical issues across teams

• Python, Py-Spark or similar scripting languages.

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).

Preferred Qualifications:

• Knowledge of Oracle EBS and Fusion cloud data structure, OIC

• Knowledge about Azure Services, Databricks, Synapse

• Data analysis training or experience working with structured and/or unstructured datasets.

• Knowledge of machine learning tools

• Experience with Azure

Working Conditions:

• Standard office environment

• 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, gowning, 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

• Requires work with small to medium size hand and power tools

• Occasional travel to customer and outside test lab facilities for technical interchange meetings, design reviews, product testing support, and attend technical seminars

• May need to travel domestically and internationally (up to 10%)

• Standing: 10% *percentage is approximate and may vary depending on work task

• Sitting:90% *percentage is approximate and may vary depending on work task

• Lifting (in pounds): up to 20 pounds

• Pushing (in pounds): up to 20 pounds

Top Benefits:

As a team member at Crane Aerospace and Electronics, you’ll enjoy:

• Benefits: Health care, dental, vision, life and disability 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 6 months of employment

You can see a list of our benefits at https://www.craneae.com/company/careers or visit our website at www.CraneAE.com for more information on our company and great opportunities.

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.

#LI-JJ1 #CAE

Annual Salary: $100,411 - $128,604 USD Annual

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 program.

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. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, gender, sexual orientation, general identity, national origin, disability or veteran status.

At Crane, we believe that attracting and retaining the highest quality people is the best insurance of success. Our goal is to recruit talented people and train them within a culture that calls for performance with trust and respect. Join us.

The unique backgrounds and differences of our associates make us stronger, more capable, and more successful. Beyond an associate’s base compensation, we reward and reinforce wellbeing with a compelling package of both cash and non-cash benefits, including comprehensive health, wellness incentives, assistance with retirement savings, paid time off, paid holidays, and tuition reimbursement — as well as performance-based bonus programs for certain positions. Crane prioritizes career development for our associates. All associates receive an annual development plan that includes a mixture of on-the-job coaching and formal training experiences to support individual development needs. We firmly believe in associate growth that supports career progression and we will proactively support your ongoing career development.