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
Click
here to apply!
|