BI & Advanced Analytics Project Leader

American Woodmark is one of the nation's largest cabinet manufacturers. By partnering with major home centers, builders, and dealers, we spark the imagination of homeowners and designers and bring their vision to life. Across our service and distribution centers, our corporate office, and manufacturing facilities, you'll always find the same commitment to customer satisfaction, integrity, teamwork, and excellence.

We are on a journey to encourage an inclusive Woodmark and are taking meaningful actions to promote diverse representation across every part of the business. Together, every team member contributes to making American Woodmark a place where people can express who they are through what they do.

POSITION PURPOSE:

Business Intelligence & Advanced Analytics, will partner with business leadership to understand business direction and translate that into information technology needs. This role will create and maintain data pipelines, data warehouses, data models and BI platforms that are interactive and user friendly.

IDEAL CANDIDATE PROFILE:
To perform this job successfully, an individual must be able to excel at the essential functions assigned. The requirements listed below are representative of the knowledge, skill, and ability required.

Experience
Required:

• 5+ years experience in Information Technology, including a minimum of 3 years in complex technology environments.
• 5+ years’ experience using MS SQL, SSIS, SSAS and SSRS in a business environment with large-scale, complex datasets.
• 3+ years in Power BI (Power Query, Data Modeling, Data Visualization, Performance Tuning)
• 3+ years of experience in manufacturing, consumer products, or distribution industries.

Skills:

• SQL Server development and administration (TSQL, Tables, Views, Procedures, functions, etc.)
• ETL processing using SSIS packages with SQL agents
• Power BI report development and administration
• SSAS cube development
• SSRS report development.

Education

• Bachelor’s Degree in Computer Science, Information Systems or other related field or comparable professional experience. 

ESSENTIAL FUNCTIONS:

• Partner with business stakeholders to understand project scope and requirements by defining, prioritizing and organizing initiatives.
• Develop complex SQL queries to capture metrics in sales, finance, marketing, manufacturing, and other business functions.
• Create Power BI dashboards and data models that join disparate datasets across business functions and platforms such as JDE and Oracle.
• Support existing Enterprise Data Warehouse nightly ETL processing.
• Share rotating on call support responsibilities with team.
• Enhance, improve, and debug existing reports as needed.
• Create, update, and modify SSAS cubes when needed.

SCOPE - EXPECTATIONS:

• Reports to Manager, BI & AA
• Supervisory Responsibilities: This position does not have supervisory responsibilities.
• Travel Requirements: Typically, less than 5% travel is required.
• Recruitment process may consist of any combination of phone, video and in person interviews.
• Offers may be contingent upon successful completion of Background Check, Drug Screen, Physical Examination and/or potential Motor Vehicle Check

• Competitive Compensation
• Health Care Benefits
• Paid Holidays
• Paid Vacation Days
• Paid Sick Days
• 401(k) Match
• Tuition Assistance
• Relocation Assistance when available

AN EQUAL OPPORTUNITY EMPLOYER

The American Woodmark Corporation does not discriminate on the basis of race, color, national origin, ancestry, age, religion, military and veteran status, sex, gender, gender identity, gender expression, sexual orientation, genetic information, marital status, medical