Sales Analyst/Sales Ops Analyst at Fencing Supply Group

Description

Fencing Supply Group (FSG) was formed in 2021, through the combined acquisition of ten leading fencing distribution companies and is North America’s premiere branch-based distribution and manufacturer of fence and outdoor living products. FSG businesses serve professional fencing contractors who provide new, improvement, and repair fencing services across residential, industrial, commercial, and infrastructure end markets. We are on an exciting path of growth and every day our over 1,100 associates at almost 70 locations in more than 30 states and two countries partner with our customers and suppliers to help ensure their business success.

FSG is built on a cultural foundation of candid communication, empathy, and trust. We recognize that the input and contribution of each of our associates is vital to the overall success of our company, and we are focused on opportunities to develop skills, knowledge, and experience We’re uniquely positioned to help you grow your career if you are willing to learn and are energized by a fast-paced and growing company.

Position Summary:

The role will be responsible for executing the master data strategy for FSG along with providing analytical and technical support across FSG.

Essential Job Functions, Duties, and Responsibilities:

• Create and maintain commercial reporting for FSG Companies using SQL, SSRS, PowerBI and Alteryx
• Become fluent in the organization of data within Fencing Supply Group SQL database and Infor M3 ERP
• Support commercial reporting for all FSG Entities
• Develop ad hoc queries/datasets as needed for both dashboards and commercial
• Analyze existing queries to debug, test and optimize reports and datasets
• Utilize experience in BI Toolsets (SSRS, Tableau, etc..)
• Assist in building Executive Dashboards with metrics and KPIs.
• Assist in building facts and dimensions in EDW 
• Create datasets in Power BI
• Assist in gathering requirements for KPIs as well as functional areas for EDW
• Assist managers in determining/developing accurate time estimates and meet deadlines
• Provide excellent customer service

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice. 

Requirements

• Bachelor’s degree or equivalent in industrial engineering or similar; 
• Atlanta-based;
• Comfortable in office setting M-F;
• Experience in Industry or Consulting, focused on analytics, preferably commercial analytics;
• 1-4 years working with Microsoft SQL (data migration, TSQL, comprehensive analysis, complex query/stored procedure development, indexes/triggers/views, and query optimizations)
• 1-4 years working with advanced T-SQL Stored Procedures and Queries
• 1-4 years working with Microsoft Reporting Services or Equivalent Reporting Software
• 1-4 years working Analytics Toolsets (SQL Analysis and Services, Tableau, or ClickView)
• Technical experience in Salesforce, Alteryx, advanced Excel, PowerBI, Python, OneStream
• Excellent organization skills and attention to detail
• A self-starter with a strong work ethic and sense of ownership
• 1-4 years developing Enterprise Data Warehouse and ETL

PREFERRED EXPERIENCE

• 3 years working with a MDM Tool 
• 3 years working with Web Services/API
• 3 years Microsoft .NET 

We’ve got you covered.

Employees give a lot, and we offer benefits that fit their needs. We provide industry-leading coverage and benefits to our people and their qualified family members, including:

• Medical, Dental and Vision coverage for Employees, Spouses, Dependents &/or entire Family
• Company Paid Life Insurance and Short/Long-Term Disability Insurance
• Convenient 24/7 Doctor Visits through Live Health Online
• Legal Assistance via Legal Shield
• Employee Assistance Program
• Identify Theft Protection
• Access Perks – Discounts on products and services with companies nationwide.
• 401k Retirement Program with strong company match.
• Competitive compensation