Reporting Analyst - Strategic Data

Information Technology Overland Park, Kansas


Company Overview

Shamrock Trading Corporation is the parent company for a family of brands in transportation services, finance and technology. Headquartered in Overland Park, KS, Shamrock has consistently been named “Best Places to Work” by the Kansas City Business Journal. We also have offices in Chicago, Dallas, Laredo, Midland, Nashville, and Atlanta.

With an average annual revenue growth of 25% since 1986, Shamrock’s success is attributed to three key factors: hiring the best people, cultivating long-term relationships with our customers and continually evolving in the marketplace.


The Strategic Reporting Analyst will use their analytical skills to deliver data-driven solutions and insights to key stakeholders throughout Shamrock Trading Corp. They must demonstrate effective communication skills to understand business needs and the ability to effectively communicate complex solutions to non-technical users. They must exhibit time-management and prioritization skills and be able to work with autonomy. The Strategic Reporting Analyst will be responsible for maintaining and improving current BI reporting and analytical solutions and developing new solutions as needed. Responsibilities include but are not limited to:

  • Research current business reporting/analytical solutions and determine what improvements and additions are necessary to meet the needs of the business unit
  • Continuously seek feedback from upper management and the executive team to aid in driving top and bottom-line growth
  • Develop and execute management reports, dashboards, and ad-hoc analysis requests
  • Perform routine educational demonstrations of new reports and analytical tools for both end users and senior management of all Shamrock subsidiaries
  • Utilize project management skills to ensure responsibilities are properly identified and prioritized, timelines are met, and consistent status updates are communicated to stake holders

  • Bachelor’s degree in Business, Economics, Data Analytics, or a related field
  • 2+ years of experience in an analytical role.
  • Strong analytical skills, with the ability to derive insights from large data sets, exceptional attention to detail, and a desire to creatively solve challenging problems
  • Strong written and verbal communication skills, with the ability to clearly present complex concepts and analytical findings to a wide variety of audiences
  • General business acumen, with the ability to analyze the transportation industry and recommend business improvements
  • Fluency in Microsoft Excel and Microsoft Power BI
  • Ability to work autonomously while maintaining several tasks and can cross- functionally perform jobs when needed
  • Experience with relational databases such as MS SQL
  • Experience with Business Intelligence software, such as Microsoft Power BI
  • Experience writing scripts/code

Benefits Package

At Shamrock we hire bright, ambitious people and give them the tools they need to be successful. By investing in training and development, we hope to become a long-term career for employees, where there are always opportunities for advancement. Shamrock also offers a premier set of benefits for employees and their families:  
  • Medical: Fully-paid healthcare, dental and vision premiums for employees and eligible dependents 
  • Financial: Generous company 401(k) contributions and employee stock ownership after one year 
  • Wellness: Onsite gym, jogging trail and discounted membership to nearby fitness center 
  • Work-Life Balance: Competitive PTO and paid leave options