Business Intelligence Data Engineer

Company: Milgard Manufacturing, Inc.
Location: Tacoma
Posted on: August 5, 2022

Job Description:

Description A Business Intelligence Data Engineer job is available in Fife, WA, at Milgard Windows and Doors. You will be responsible for creating reports per company needs and performing data validation by writing SQL queries on the source and target databases. You will spend 80% of your time on ETL and the remaining 20% on front-end reporting. A bachelor---s degree and four years of experience working with Data warehouse and BI technologies are required. The salary for this role is dependent on experience. Milgard Windows & Doors is the leading manufacturer of windows and doors in the Western United States with operations in Washington, Oregon, and California. Milgard was recently acquired by MI Windows, creating additional opportunities for growth and synergies between these two industry leaders. Business Intelligence Data Engineer job responsibilities include: You will be part of requirement analysis, understand the source data structure, and create ETL packages to process and load data into target tables. Perform problem analysis, reverse engineer existing data models to understand data, and resolve ETL/Data issues. Create BI reports per company needs and perform data validation by writing SQL queries on the source and target databases. Monitor existing ETL/Reporting job schedules, investigate, and resolve issues. Work with the team to gain data and enterprise knowledge, understand the data flow between various systems, and step in to provide requested data/reports for company needs. Hands-on with data warehouse system and implement necessary changes to the database, ETL/ELT packages, and schedules. Conduct thorough testing for the solutions developed, assist onsite owners with acceptance testing of final results, enhance the existing applications, or introduce new functionality in a project. Monitor daily data refresh jobs and reports and take necessary actions to deliver key corporate reports on time. Internal Customer support working with on-site, off-shore India, and other internal teams. Requirements Experience in creating models and reports using Azure Synapse Analytics platform and Power BI Hands-on in developing SSIS Packages, and Synapse Pipelines using various types of data sources. (Database, CSV, XML & JSON) Have experience in understanding data models, writing SQL queries in SQL Server, Oracle & DB2. Good understanding of On-prem and Azure cloud Data Warehouse Best Practices Should have a formal education background in Engineering Experience in working Manufacturing data models. Accustomed to working with aggressive project timelines Experience with ETL and ELT using SSIS & Azure Synapse Analytics (Pipelines, Data Lake Gen2, Notebooks, Tabular Azure, Azure analysis services). Experience in working with Power BI and/or IBM Cognos Experience in writing performance-optimized SQL statements in SQL Server, Oracle and DB2 Exposure to Cloud and Big Data Technologies. Exposure to dot net/ windows programming languages or Prior experience with Manufacturing and Sales data models is a plus but not must have Strong analytical, excellent troubleshooting, and programming skills. Prior experience with Manufacturing and Sales data models is a plus but not a must-have Four plus years of experience working with Data warehouse and BI technologies. Experience working on Support Projects onsite and offshore (flexibility in schedule is needed). Knowledge of two-plus reporting tools and two ETL Tools. Good understanding of Data Warehouse Best Practices Good oral and written communication skills. Promotes a cooperative and productive team environment. Minimum of bachelor---s degree in Engineering Milgard is growing with a track record of strong financial performance, which creates opportunities for team members. A great opportunity to learn about our business and show what you can do to build a great team and organization. We have a robust total reward offering, including: Vacation and Sick pay Medical/Dental/Vision --- Milgard picks up the majority cost of these important benefits Tuition assistance --- continue your education; we will help Career growth opportunities --- take on more responsibility and grow If you are interested in this Business Intelligence Data Engineer job in Fife, WA, please apply now. To learn more about Milgard---s products, services, and culture, visit our website at www.milgard.com/careers. We have built our success on our foundational philosophy of Respect, Service, and Excellence. Milgard Windows & Doors is a great place to grow your career as we continue to build an even greater organization CB MONSTER

Keywords: Milgard Manufacturing, Inc., Tacoma , Business Intelligence Data Engineer, Engineering , Tacoma, Washington