Data Engineer II

Crane Company; Lynnwood (WA); On-site; USD 110,000 - 140,000; Full time

Job summary

Crane Aerospace & Electronics in Lynnwood, WA is seeking a Data Engineer II for an on-site role to design and implement data warehousing solutions and ETL processes, and to build dashboards that enable data-driven decisions.

The role requires strong SQL, Azure data services, and scripting with Python or PySpark; collaboration with IT and analytics teams; and a bachelor’s degree in a quantitative field.

Qualifications

• Bachelor's degree in computer science, engineering, information systems, or related quantitative field.
• 3-4 years of experience building data warehouses and dimensional models with ETL development.
• 1-2 years of experience building reports/dashboards with Tableau, Power BI, or QLIK., including T-SQL/PL-SQL.
• Strong understanding of relational databases, data warehousing concepts, and ETL processes.
• Experience with cloud services such as Azure, AWS, or GCP.

Responsibilities

• Develop complex SQL queries, stored procedures, and views for data analysis and modeling.
• Maintain and update data platform solutions and data models on Azure and Power BI.
• Build data integrations and KPIs to support business decisions.
• Collaborate with IT and analytics teams to deliver data solutions and analytics.
• Perform POCs using ML and AI techniques and deploy Azure data services.
• Create documentation, best practices, and knowledge base materials.

Skills

Data warehousing

ETL development

SQL & data querying

Python / Py-Spark

Data modeling

Problem solving

Education

Bachelor's degree in CS or related field

Tools

Tableau

Power BI

Qlik

T-SQL

PL/SQL

Job description

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!

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