Business Reporting Analyst - Carrier Services

Information TechnologyHybrid Remote, 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 regularly been named one of the Kansas City Business Journal's "Best Places to Work." We also have offices in Chicago, Dallas, Laredo, Midland, Nashville, Atlanta and Fort Lauderdale.

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 Business Reporting Analyst will use their strong analytical skills to deliver data-driven solutions and insights to key stakeholders. Candidates should demonstrate effective communication skills, be capable of understanding business requirements and effectively communicate complex solutions to non-technical users. The Business Reporting Analyst will be responsible for maintaining/improving current BI reporting and analytical solutions and developing new solutions as needed.  

  • Work with business unit stakeholders and technical teams to identify valuable data points generated by our business units and their customers.
  • Transform, analyze, and interpret data generated from customers, partners and other 3rd party data sources
  • Create/provide ongoing reporting and analysis to steer business decisions
  • Collaborate with business stakeholders, data engineers and other analysts on strategic direction initiatives
  • Work closely with our Data Services team to develop and implement data warehouses, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
  • Recommend acquisition of data from primary or secondary data sources and maintain integrity of internal and external sources
  • Identify, analyze, and interpret trends or patterns in complex data sets
  • Ensure a high-quality level of data reporting, accuracy is essential
  • Filter and “clean” data by reviewing performance indicators to locate and correct data collection problems
  • Work with management to prioritize business and information needs
  • Locate and define new process improvement opportunities including marketing effectiveness


  • Experience writing queries and analyzing data from databases such as MS SQL, Redshift, Postgres, MongoDB, or similar
  • Ability to author and maintain both reports and datasets in a Power BI, or similar front end analytics tool, service environment
  • Understanding of Data Warehousing concepts
  • Able to use data to tell a story and create visual interpretations of correlation and causation
  • Bachelor’s Degree in Business Administration, Information Technology, or a related field

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