Sonepar
Business Data Analyst I
Sonepar, Salt Lake City, Utah, United States, 84193
Be part of something bigger.
At Codale Electric, we're proud of the role we've played in projects like the new Salt Lake Airport, the Las Vegas Raiders stadium and Soleil Lofts, as well as our role in housing, commercial, and industrial projects of every size throughout the Intermountain West. We strive to be the best wholesale distributor in the area and invite you to be part of building the future.
Job Summary:
The Sales Analyst is responsible for creating and analyzing sales performance documents to aid management in the decision-making process and drive a customer centric organization. Supports sales managers in reporting, forecasting and analysis; sales analyst must be able to translate significant data into actionable information that describes what has happened in the past, what is happening now and what could occur based on current trends. The ideal candidate will have a sales mindset, be disciplined, have a sense of urgency, a strong work ethic and set high standards for data integrity.
What You'll Do:
Preparation of gap analysis for sales territories, product groups, etc.
Prepare Power BI reports and analyze data for trends and impact on the business
Prepare sales reports for monthly review meetings, executive meetings, presentations, and for parent company
Present and interpret sales data to facilitate decision making by sales leaders
Prepare and report sales and gross profit reports, communicate with branch teams to understand trends and/or transactional issues driving unusual results
Research and analyze fluctuations in sales segments and product mixes
Participates in Company planning and forecasting
Identifies, develops and executes opportunities for improvement and best practices
Perform Ad hoc report analysis, other duties and/or projects as assigned
Develops solutions to a variety of complex problems. May refer to established precedents and policies.
Performs complex tasks and participates in determining objectives of assignment. Plans schedules and arranges own activities to accomplish objectives. Work is reviewed upon completion for adequacy in meeting objectives.
Exerts some influence on the overall objectives and long-range goals of the organization. Erroneous decisions or failure to achieve objectives would normally have a serious effect upon the administration of the organization.
Assist sales leaders in planning, forecasting and setting sales goals
Data collection and reporting of key metrics to track performance on strategic initiatives
Query, analyze and report data for trends and impact on the business
What You'll Bring:
Advanced skills with the Microsoft Office Suite of products, including macros, queries, PowerPoint
Power BI report development, analysis, and reporting
Proficient skills with database query management and various forms of ELT tools and/or applications
Excellent written and verbal communication skills across multiple levels of the organization
Experience with ERP systems; Eclipse ERP a plus
Energetic, curious, and motivated; thrives in a changing, deadline-oriented environment where the ability to prioritize is a must
Maintain confidentiality of proprietary business information
Highly detail-oriented, curious, independent critical thinker
Bachelor's degree (B.A or B.S.) from a 4-year college or University in Data/Analytics, Accounting or Finance
1 - 3 years' as a data Analyst
Electrical, Industrial and/or distribution experience preferred but not required.
Work Environment and Hours:
It's a full-time job in the office, typical work schedule is Monday to Friday
Long and varied hours required occasionally
Standard office environment as well as occasionally in a warehouse environment, with standard office equipment.
Work is sedentary but may require standing and walking for 5-10% of the time
Work Location: Salt Lake City, Utah
Pay Range: $55K-$86K
Why work for Codale Electric Supply?
It feels good to drive down the road and say, "I played a part in that." You can be part of a wide array of projects, no matter your role at Codale. Successful team members at Codale demonstrate integrity, a commitment to excellence and a desire to be the best warehouse employee, delivery driver, office support staff or salesperson. Each day presents opportunities to strive for improvement, to build customer relationships and to build your skills and accomplishments. You can build a long-term career at Codale.
Our Competitive Benefits?
401K Plan, Competitive Medical Plans (medical, dental, and vision), Paid Vacation, Paid Sick, Paid Personal, Paid Holidays, Flexible Spending Accounts (Health and Dependent Care), Employee Assistance Program, Tuition Reimbursement, Employee Discounts, Long-term and Short-term Disability, Life Insurance and a Definitive Career Path.
About Codale Electric and Sonepar USA
Founded in 1975 by Dale P. Holt, Codale Electric Supply started with only five employees before becoming one of the most innovative and fastest-growing electrical supply distributors in the nation. Today, we are headquartered in Salt Lake City, Utah and currently have branch locations in the western United States. Even though we have quite a presence in Utah, Nevada, and Wyoming, we've declared that we will not rest until we can help provide contractors throughout the nation with the supplies that they need. www.codale.com
Sonepar is an independent family-owned company with global market leadership in B-to-B distribution of electrical products, solutions and related services. Sonepar entered the US in 1998 and continues to grow due to strategic acquisitions and organic growth. Today, Sonepar serves the market through a network of companies with over 400 locations nationwide. For more information, visitsoneparusa.com.
Equal Employment Opportunity Statement
Sonepar is an Equal Opportunity and Affirmative Action Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to their race, color, creed, religion, national origin, citizenship status, ancestry, sex, age, physical or mental disability unrelated to ability, marital status, family responsibilities, pregnancy, genetic information, sexual orientation, gender expression, gender identity, transgender, sex stereotyping, order of protection status, protected veteran or military status, or an unfavorable discharge from military service, and other categories protected by federal, state or local law.
Sonepar and our family of brands are committed to the full inclusion of all qualified individuals. In keeping with our commitment, we will take the steps to assure that people with disabilities are provided reasonable accommodations. Accordingly, if a reasonable accommodation is required to fully participate in the job application or interview process, to perform the essential functions of the position, and/or to receive all other benefits and privileges of employment, please call 843-745-2420 or email recruiting@sonepar-us.com.
EEO is the Law
Applicants and employees are protected under Federal law from discrimination. To learn more, Click here.
Pay Transparency Non-Discrimination Provision
Sonepar follows Executive Order 11246, including the Pay Transparency Nondiscrimination Provision. To learn more, Click here.
At Codale Electric, we're proud of the role we've played in projects like the new Salt Lake Airport, the Las Vegas Raiders stadium and Soleil Lofts, as well as our role in housing, commercial, and industrial projects of every size throughout the Intermountain West. We strive to be the best wholesale distributor in the area and invite you to be part of building the future.
Job Summary:
The Sales Analyst is responsible for creating and analyzing sales performance documents to aid management in the decision-making process and drive a customer centric organization. Supports sales managers in reporting, forecasting and analysis; sales analyst must be able to translate significant data into actionable information that describes what has happened in the past, what is happening now and what could occur based on current trends. The ideal candidate will have a sales mindset, be disciplined, have a sense of urgency, a strong work ethic and set high standards for data integrity.
What You'll Do:
Preparation of gap analysis for sales territories, product groups, etc.
Prepare Power BI reports and analyze data for trends and impact on the business
Prepare sales reports for monthly review meetings, executive meetings, presentations, and for parent company
Present and interpret sales data to facilitate decision making by sales leaders
Prepare and report sales and gross profit reports, communicate with branch teams to understand trends and/or transactional issues driving unusual results
Research and analyze fluctuations in sales segments and product mixes
Participates in Company planning and forecasting
Identifies, develops and executes opportunities for improvement and best practices
Perform Ad hoc report analysis, other duties and/or projects as assigned
Develops solutions to a variety of complex problems. May refer to established precedents and policies.
Performs complex tasks and participates in determining objectives of assignment. Plans schedules and arranges own activities to accomplish objectives. Work is reviewed upon completion for adequacy in meeting objectives.
Exerts some influence on the overall objectives and long-range goals of the organization. Erroneous decisions or failure to achieve objectives would normally have a serious effect upon the administration of the organization.
Assist sales leaders in planning, forecasting and setting sales goals
Data collection and reporting of key metrics to track performance on strategic initiatives
Query, analyze and report data for trends and impact on the business
What You'll Bring:
Advanced skills with the Microsoft Office Suite of products, including macros, queries, PowerPoint
Power BI report development, analysis, and reporting
Proficient skills with database query management and various forms of ELT tools and/or applications
Excellent written and verbal communication skills across multiple levels of the organization
Experience with ERP systems; Eclipse ERP a plus
Energetic, curious, and motivated; thrives in a changing, deadline-oriented environment where the ability to prioritize is a must
Maintain confidentiality of proprietary business information
Highly detail-oriented, curious, independent critical thinker
Bachelor's degree (B.A or B.S.) from a 4-year college or University in Data/Analytics, Accounting or Finance
1 - 3 years' as a data Analyst
Electrical, Industrial and/or distribution experience preferred but not required.
Work Environment and Hours:
It's a full-time job in the office, typical work schedule is Monday to Friday
Long and varied hours required occasionally
Standard office environment as well as occasionally in a warehouse environment, with standard office equipment.
Work is sedentary but may require standing and walking for 5-10% of the time
Work Location: Salt Lake City, Utah
Pay Range: $55K-$86K
Why work for Codale Electric Supply?
It feels good to drive down the road and say, "I played a part in that." You can be part of a wide array of projects, no matter your role at Codale. Successful team members at Codale demonstrate integrity, a commitment to excellence and a desire to be the best warehouse employee, delivery driver, office support staff or salesperson. Each day presents opportunities to strive for improvement, to build customer relationships and to build your skills and accomplishments. You can build a long-term career at Codale.
Our Competitive Benefits?
401K Plan, Competitive Medical Plans (medical, dental, and vision), Paid Vacation, Paid Sick, Paid Personal, Paid Holidays, Flexible Spending Accounts (Health and Dependent Care), Employee Assistance Program, Tuition Reimbursement, Employee Discounts, Long-term and Short-term Disability, Life Insurance and a Definitive Career Path.
About Codale Electric and Sonepar USA
Founded in 1975 by Dale P. Holt, Codale Electric Supply started with only five employees before becoming one of the most innovative and fastest-growing electrical supply distributors in the nation. Today, we are headquartered in Salt Lake City, Utah and currently have branch locations in the western United States. Even though we have quite a presence in Utah, Nevada, and Wyoming, we've declared that we will not rest until we can help provide contractors throughout the nation with the supplies that they need. www.codale.com
Sonepar is an independent family-owned company with global market leadership in B-to-B distribution of electrical products, solutions and related services. Sonepar entered the US in 1998 and continues to grow due to strategic acquisitions and organic growth. Today, Sonepar serves the market through a network of companies with over 400 locations nationwide. For more information, visitsoneparusa.com.
Equal Employment Opportunity Statement
Sonepar is an Equal Opportunity and Affirmative Action Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to their race, color, creed, religion, national origin, citizenship status, ancestry, sex, age, physical or mental disability unrelated to ability, marital status, family responsibilities, pregnancy, genetic information, sexual orientation, gender expression, gender identity, transgender, sex stereotyping, order of protection status, protected veteran or military status, or an unfavorable discharge from military service, and other categories protected by federal, state or local law.
Sonepar and our family of brands are committed to the full inclusion of all qualified individuals. In keeping with our commitment, we will take the steps to assure that people with disabilities are provided reasonable accommodations. Accordingly, if a reasonable accommodation is required to fully participate in the job application or interview process, to perform the essential functions of the position, and/or to receive all other benefits and privileges of employment, please call 843-745-2420 or email recruiting@sonepar-us.com.
EEO is the Law
Applicants and employees are protected under Federal law from discrimination. To learn more, Click here.
Pay Transparency Non-Discrimination Provision
Sonepar follows Executive Order 11246, including the Pay Transparency Nondiscrimination Provision. To learn more, Click here.