Data Analyst

Company: Rust-Oleum Corporation
Location: Vernon Hills
Posted on: November 18, 2021

Job Description:

Vernon Hills, IL, United States

As our Data Analyst you will collaborate with business departments to identify data requirements and develop data pipelines for extracting and loading data into an enterprise data warehouse. By centralizing data in our enterprise data warehouse our group is able to build automatic, scalable, reports that allow us to better understand our supply chain, market, customers, and identify growth/savings opportunities for Rust-Oleum. Solving challenges is the very foundation of who we are. After all, in the beginning, our founder, sea captain Robert Fergusson, didn't particularly care about paint. When he founded our company in 1921, he just wanted to keep his ship intact and stumbled upon a valuable solution. Today, that discovery is Rust-Oleum Corporation. The same passion that drove the Captain to spend his next few years creating the world's first rust-preventative paint still drives us today. When we see a problem, we work diligently until we've perfected a solution, which has led to some of the most cutting edge, durable and innovative products in the industry. Our creative and talented team of over 2000 people across every corner of the world, help us remain the global leader in protective paints and coatings for both home and industry. Here's what you can expect every day:

• Extract data from external/internal data source(s), transform the data, and load the data into our target Enterprise Data Warehouse (EDW) database.
• Communicate and collaborate with business departments throughout Rust-Oleum for the purpose of assessing data needs.
• Develop Source-to-Target documents as a reference to how a data pipeline should be developed.
• Develop stored procedures and views in SQL Server for reporting and analysis.
• Provide reporting and analysis for customers, internal employees, and inner department.
• Verify that the data sources and EDW are in sync and balanced.
• Maintain integrity of dimensional data in Enterprise Data Warehouse. Rust-Oleum is an equal opportunity employer. Employment selection and related decisions are made without regard to sex, race, age, disability, religion, national origin, color, or any other protected class. Required Skills:
  • Bachelors Degree
  • Communication Skills
  • Database Structure/Design
  • Analytical Reasoning
  • SQL
  • Microsoft Access
  • Microsoft Excel (Pivot Tables, vLookups, Aggregation Types) Preferred Skill Exposure:
    • Microsoft SQL Server
    • Python
    • Informatica
    • SSRS (SQL Server Reporting Services)
    • Microsoft Power BI LI19Job Identification: 1120Job Category: Logistics & DistributionPosting Date: 2021-10-26Job Schedule: Full timePosting Date: 2021-10-26
      
      PI

Keywords: Rust-Oleum Corporation, Arlington Heights , Data Analyst, Professions , Vernon Hills, Illinois