Business Analyst I - KGP Telecommunications, LLC
Lenexa, KS 66219
About the Job
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!
Responsibilities:SUMMARY
Responsible for serving as an expert in data analysis for the purposes of ship and debit reporting, negative margin analysis, and other ad hoc pricing analysis. Responsibilities will include identifying process challenges that create a negative impact to KGPCo while determining root cause and working with the appropriate department to implement corrective actions.
ESSENTIAL DUTIES & RESPONSIBILITIES
- Responsible for analysis, reporting and measurements related to KGP’s successful execution of strategy
- Creates and maintains monthly ship and debit and negative margin tracker.
- Analyze OEM ship and debit performance to recommend any required program changes.
- Analyze negative margin transactions to identify root cause and work with appropriate department to make any necessary process adjustments.
Other ad hoc reporting as needed
Qualifications:
EDUCATION and/or EXPERIENCE
- Bachelor’s degree in business, logistics, mathematics, statistics, or related field
- 1-3years of data analytics or related experience. Pricing Operations experience is a 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
- Requirements include 3 or more years of related experience and Associates degree or equivalent.
LANGUAGE SKILLS:
- Ability to read and comprehend simple instructions, short correspondence, and memos; ability to write simple correspondence; ability to effectively present information in one-on-one and small group situations to customers, clients, and other employees of the Company.
MATHEMATICAL SKILLS:
- Ability to add and subtract 10-digit numbers, to multiply and divide with tens and hundreds; ability to perform these operations using units of American money and weight measurement, volume and distance.
REASONING ABILITY:
- Work follows established job aids and business rules. Ability to apply commonsense understanding to carry out instructions furnished in written, oral or diagram form; ability to deal with problems involving several 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 accommodations 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 talk and hear. The employee frequently is required to sit, use hands to finger, handle or feel objects, tools or controls and reach with hands and arms.
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
KGPCo is an Equal Opportunity Employer – M/F/Veteran/Disability/Sexual Orientation/Gender Identity