On-Site Data Engineer II — Azure Analytics & BI

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