Lawson Products Business Intelligence Developer - Senior in Chicago, Illinois

Business Intelligence Developer - Senior

Location IL - Chicago

Apply Now

Business Intelligence Developer - Senior

This position will analyze and develop reporting, analysis and dashboard solutions using Microsoft's full BI suite supporting corporate and customer information systems' requirements. Applies configuration changes and administration of the Microsoft BI suite.

Essential Duties and Responsibilities:

  • Designs, develops and supports BI solutions, including debugging, monitoring, and troubleshooting within the following toolsets:

  • Microsoft SQL Server 2017, SSAS, PBIRS (SSRS), and Power BI.

  • Microsoft Excel, Power Pivot, Power Query, and Power View.

  • Create and deploy reports. Applies data mining algorithms, writing relational and multidimensional database queries using data aggregated from multiple sources.

  • Works with all levels of development from analysis through implementation and support.

  • Interacts with report owners to establish/clarify requirements and develop the report specifications.

  • Resolves end-user reporting problems through collaboration with IT and Operations.

  • Work as part of the Business Intelligence Team, providing support to other team members and processes teams as needed.

  • Must be self-motivated, organized and comfortable with aggressive goals and timelines.

Other Skills and Abilities:

  • Hands-on development experience using Microsoft SSDT, SSRS, SSAS, and Power BI.

  • Proficient using DAX functions throughout the Microsoft suite.

  • Demonstrated experience developing sophisticated reporting, analysis, and dashboarding solutions.

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

  • Familiar with multi-dimensional database concepts and business intelligence best practices.

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

  • Leverages Active Directory as the solution driving object and data level security throughout the BI landscape.

  • Distribution industry experience a plus.


  • Requires a bachelor's degree plus 7 - 10 years of experience in developing BI solutions within an enterprise reporting solution preferably Microsoft SQL Server, or an equivalent combination of education and experience.

  • Analytical mind with a problem-solving aptitude.

  • Strong SQL/SPL development skills.

  • Experience with SAP Business Objects - WEBI, Universe, and Crystal Reports

  • Experience with Microsoft SSIS and IIS

  • Tableau experience a plus.

Lawson Products is an Equal Opportunity Employer of Minorities, Females, Protected Veterans and Individuals with Disabilities.