Data Engineer II

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 our IT team to build a data lake based on ERP systems.  The Data Engineer will be responsible for  supporting and  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.

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: