Shamrock Trading Corporation

BI Enterprise Data Architect

US-KS-Overland Park
Information Technology

Company Overview

Recognized as one of the Kansas City area’s best places to work, Shamrock Trading Corporation is a rapidly-growing provider of transportation logistics, financial services and international trade finance for businesses in the United States and other parts of the world. Shamrock’s subsidiaries include Ryan Transportation, RTS Financial, RTS International and RTS Carrier Services.


Based in Kansas City, Shamrock has recently expanded to office locations in Nashville and greater Chicago.  


Founded in 1986, Shamrock has posted an average of 25% sales growth for each year it has been in business. Based in a newly-opened office complex in Overland Park, Shamrock has more than doubled its workforce since 2013. All 500-plus Shamrock employees receive competitive salaries, a great benefits package and exciting career opportunities.


In 2015, 2016 and 2017, The Kansas City Business Journal named Shamrock one of its “Best Places to Work.”



Shamrock Trading Corporations Business Intelligence team is in the process of building out an enterprise data solution and is searching for an Enterprise Data Architect to build and maintain a single source of truth for all analytical and reporting requirements. The Enterprise Data Architect will be a key part of Shamrock’s Business Intelligence team, reporting to the BI Manager and will have significant interaction with Shamrock’s Infrastructure team. This person’s main responsibility will be creating a consistent, efficient, and secure enterprise data solution to feed Business Reporting Analyst data requirements. The ideal candidate for this position will have experience building data warehouses that incorporate diverse data sources with a strong cloud based emphasis, can lead an enterprise data strategy and can work through unforeseen roadblocks.


The BI team is results oriented and prides itself on quickly generating actionable products (reports/sales tools) that drive revenue and mitigate risk throughout all business units of Shamrock.  Along with all other positions on the BI Team, the BI Enterprise Data Architect needs to exhibit an extreme amount of pride in their work, thrive off being challenged by complex problems and think/act as if they were an owner of the company with every decision they make.




 Required Qualifications:

  • Degree in Data Analytics, Data Science, Computer Science or another related field
  • Expertise in extracting and manipulating data from a variety of sources, primarily cloud based, and loading/indexing into data warehouses
  • Proven experience with relational databases such as Postgress SQL and MS SQL that utilize SQL queries
  • Experience creating large transactional database structures indexed to optimize storage and performance
  • Flexible with technical talents to meet our customers’ needs
  • Understanding of non-relational data stores such as MongoDB
  • Solid understanding of web services and JSON protocol
  • Experience with MS Data Integration Suite or related technologies

Desired Skills/Qualifications:

  • Experience with Big Query, AWS, DAX, M Query, Python and/or R
  • Experience with front-end BI tools such as Power BI


Benefits Package

People have always been the key to the success of Shamrock Trading Corporation. They give our companies an edge in the marketplace and help build long-term relationships with our customers. To make sure we attract and retain the best people, Shamrock provides a premier set of benefits for our employees and their families.


  • Medical: Fully-paid health care, dental and vision premiums for employees and eligible dependents.
  • Financial: Generous company 401(k) contributions and employee stock ownership after one year of service.
  • Fitness: On-site fitness center and company-sponsored Fitbit® program.
  • Additional Benefits:
    • Company-paid long-term disability insurance.
    • Company-paid life insurance coverage.
    • Tax-saving flexible spending plan.
    • Annual accrual for vacation, personal days and holiday pay.
    • Complimentary AAA membership.



Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!

Not ready to apply? Connect with us for general consideration.