Senior Market Data Analyst

City: Chicago

State/Province: IL

Country: United States

Division: Corporate

Job ID: 12205

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.

Are you a data whiz with a marketing flair who's ready for a new challenge? Check out this exciting opportunity to showcase your marketing/lead generation support and data analysis skills to help execute targeted marketing and sales programs in a fast-paced environment. Join our team and help expand opportunities in the maintenance, repair and operations industry. Become our in-house subject matter expert for developing targeted prospect lists, enriching customer information, and analyzing / reporting on omnichannel marketing programs. Collaborate with our Manager of Customer Engagement & Insights, Market Segment Managers and others to support new initiatives and strategic opportunities.

Our corporate headquarters is located in Chicago, IL. This role operates on a hybrid work model; employees spend two days working in the office and three days working remotely. We offer a competitive benefits package that includes medical, dental, and vision benefits, plus retirement benefits and a paid holiday and PTO package.

Responsibilities:

• Put your creativity and initiative to work and take your data analysis skills to the next level with Lawson Products!

• Help generate ROI by developing marketing and sales lists for our field sales, phone sales, and strategic sales teams. This includes sourcing and prioritizing / scoring leads using internal databases and external portals. Analyze list effectiveness and make recommendations to optimize sales within the purchase funnel.

• Develop and release "bots" to crawl the web and scrape relevant sales leads.

• Manage lead generation services and data append services; manage data append, custom industry classification, etc. for customer and lead records.

• Conduct product and market basket analysis to figure out the optimum product combinations.

• Merge data from multiple sources to create interactive dashboards and reports that help us propel the company into new industries and channels.

• Gauge the effectiveness of new, front-line programs and initiatives and provide insights based on real-time data to help us gain a fresh perspective.

• Develop and track new KPIs focused on omnichannel marketing, coordinating with colleagues the digital, print marketing, and telemarketing.

• Support secondary research / competitive analysis, including ongoing tracking/reporting and ad-hoc alerts, as needed.

• Other duties as assigned.

Qualifications & Requirements:

• Bachelor's degree required, MBA preferred, with at least 3-5 years of lead generation and related data analysis experience, or an equivalent combination of education and experience. Knowledge and experience with government data sources (e.g., Census Bureau, BLS, SIC / NAICS, etc.) a huge plus.

• Working knowledge of list service portals, such as ZoomInfo, LeadSpace, D&B / Hoover's, etc.

• Experience/knowledge of working with bots to crawl the web and scrape relevant information from selected web sites.

• Experience working with a CRM system to import prospects/leads pull/merge data with other sources and build reports.

• Strong knowledge and proven experience merging data from multiple tables in a complex data warehouse environment.

• Experience with B2B data compilation, prep, cleaning, and analysis, preferably in industrial products or the MRO (maintenance and repair operations) industry.

• Proven expertise in Excel, including pivot tables, macros, and complex / nested functions. Ability to pull and merge data using Power Query. Experience writing queries in SQL from scratch to merge/link data tables, create datasets, and analyze data. Proficiency in Power Query and SQL a plus!

• Proficient in basic statistical analysis and A/B test analysis. Proficiency in SPSS, SAS, R, etc. a huge plus!

• Working knowledge of Tableau, Power BI, and other interactive dashboard/visualization tools. Ability to create data models in Power BI a huge plus!

• Innate creativity and persistence; a self-starter with ability to quickly brainstorm solutions and dive deep into complicated and ambiguous data environments to merge and analyze data.

• High energy and strong communication skills. Able to deftly collaborate with others at all levels on a cross-functional team. Ability to converse on both technical and business levels.

• Strong organization and project management skills, with the ability to manage multiple initiatives with speed and agility. Proven ability to meet deadlines with high-quality output.

• Strong basic computer skills including Microsoft Outlook, Word, Excel, PowerPoint.

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