Client Solutions Business Analyst I

KGPCo is the go-to partner to Communications Service Providers. Our customers rely on our extensive range of network solutions and services to help them build, maintain, and transform networks that connect the world.

The communications industry is evolving every day and we are at the frontline of these innovations. From ground to cloud, the work we do is transforming networks and impacting communities nationwide. It's work that happens because of our motivated teams of doers and problem solvers.

Our Core Values define how we do business:
* The Customer is Everything.
* Relationships Matter. All of Them.
* Question Things. Take Action.
* Work Hard. Work Smart. Enjoy the Experience.
* Growth Mindset.

It's not just a job - it's a step in your career!

SUMMARY

Responsible for serving as an expert in data analysis and reporting, development of tools/reports for use by the business areas as well as to identify areas of opportunity to drive improved performance and efficiency while reducing cost. Create and implement solutions while coordinating with multiple departments and KGPCo leadership throughout the organization to drive change. Provides financial analysis in support of after action reviews for programs / customer accounts for the business to ensure that overall program performance targets and results are achieved.

ESSENTIAL DUTIES & RESPONSIBILITIES

Responsible for analysis, reporting and measurements related to KGP's successful execution of strategy
• Creates and maintains monthly and quarterly dashboards to track sales and general financial program performance
• Analyzes programs and services as identified by senior leadership to identify trends and performance improvement opportunities
• Partners with Finance and IT to develop modeling scenarios
• Develops predictive models to help drive decision making
• Design, develop and implement cross functional/cross organization data gathering and reporting methods and procedures to combine many inputs into single outputs for management or customer distribution
• Design and create models and reports that identify operational improvements
• Analyzes data and summarizes performance using Microsoft Excel, Power Query, Power BI, SSRS Report Services, and other reporting and analysis software and tools
• Other ad hoc reporting as needed

QUALIFICATION REQUIREMENTS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

EDUCATION and/or EXPERIENCE

• Bachelor's degree in business, logistics, mathematics, statistics, or related field
• 1-3years of data analytics or related experience. Distribution or Advanced Supply Chain experience is plus.
• Ability to manipulate large sets of data
• Excellent working knowledge of Microsoft Office products, specifically Microsoft Excel, Excel Macros, Power Query
• Experience with relational databases and knowledge of query tools and statistical software required
• Working knowledge of Microsoft BI or other business intelligence solutions
• Strong analytical, organizational problem-solving skills
• Ability to manipulate large sets of data
• Excellent working knowledge of Microsoft Office products, specifically Microsoft Excel, Excel Macros, Power Query
• Experience with relational databases and knowledge of query tools and statistical software required
• Working knowledge of Microsoft BI or other business intelligence solutions
• Strong analytical, organizational problem-solving skills
• Requirements include 3 or more years of related experience and Associates degree or equivalent.
• Must have ability to learn to read and understand technical drawings, schematics and documentation.
• Requires demonstrated ability to learn and understand basic electromechanical processes.

REQUIRED SKILLS

• Ability to read and understand basic instructions, short communications, and memos; draft simple written correspondence; and effectively communicate in one-on-one or small group settings with customers, clients, and colleagues.
• Proficiency in adding, subtracting, multiplying and dividing. Capable of performing calculations involving American currency and standard units of weight, volume, and distance.
• The ability to follow written, verbal, or diagram-based instructions and solve problems involving concrete variables in standardized situations.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of this position.

While performing the duties of this position, the employee is regularly required to listen and speak. The employee frequently is required to sit, use their hands to handle, touch, or feel objects, tools, or controls, and reach with their arms and hands.

Specific vision abilities required by this position include close vision, color vision, peripheral vision and the ability to adjust focus.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The noise level in the work environment is usually moderate.

BENEFITS

• Medical, Dental, Vision and Supplemental insurance plans
• Flexible Spending Accounts
• 401(k) with Company match
• Generous vacation, holiday, and sick/safe time
• Pet insurance for our non-human family members

Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status or other characteristics protected by law.