Lawson Products Jobs

kent Logo


Job Information

Lawson Products Data Warehouse Developer in Chicago, Illinois

Data Warehouse Developer

City: Chicago

State/Province: IL

Country: United States

Division: Corporate

Job ID: 12350

Since 1952, Lawson Products has worked hard to make our customers' jobs easier by improving their operational efficiency, productivity and overall performance. As a leader in the MRO industry, we partner with customers to make sure they have the right maintenance and repair parts on hand when needed.

We’re looking for a motivated Data Warehouse Developer responsible for preparing corporate data for reporting and analysis using the relational database and OLAP technologies. This position will analyze and develop complex logical database designs, logical data models and relational data definitions in support of corporate and customer information systems requirements.

Our corporate headquarters is located in Chicago, IL. This role operates on a hybrid work model, spending at least three days per week working in the office. We offer a competitive benefits package that includes 401k plus vision, dental and medical coverage. Employees also receive a paid holiday and PTO package.


  • Develops data models to meet the needs of Lawson's information systems. Responsible for the identification and resolution of information flow, content issues and the transformation of business requirements into logical data models.

  • Designs and develops ETL solutions using SAP Data Services.

  • Manages the flow of information between departments through relational databases.

  • Maintains data integrity by reducing data redundancy, trends in data use and single sources of data.

  • Stays current on the ways Lawson uses its data.

  • Mentors junior development resources.

  • Supports and maintains existing ETL data flows and the data warehouse environment.

  • Other duties, as assigned.

Qualifications & Requirements:

  • Requires a bachelor's degree, plus 5 years of experience in data modeling and development, or an equivalent combination of education and experience

  • Relies on experience and judgment to plan and accomplish goals.

  • Business Objects or other enterprise BI suite experience a plus.

  • 5-7 years of ETL development experience. SAP Data Services experience preferred.

  • In-depth understanding and demonstrated proficiency in data warehousing concepts, best practices, and dimensional database design.

  • Cross-functional experience with sales, human resources, finance or operations.

  • Understands the methodologies and technologies that depict the flow of data within and between technology systems and business functions/operations.

Lawson Products is an Equal Opportunity Employer of women, minorities, protected veterans and individuals with disabilities.