Shamrock Trading Corporation

  • Data Architect

    Job Locations 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 Data Services team is in the process of building an enterprise data solution and searching for a Data Architect to build and maintain a cloud-focused data platform for analytics and business intelligence.

    The Data Services team’s primary responsibility it gathering, centralizing, and analyzing data gathered from a number of internal and external sources. With that goal in mind, the Data Architect’s main responsibility is designing and maintaining flexible data models along with the framework and processes that feed into it.


    • Design, build, and maintain forward-looking data models
    • Design, build, and maintain framework for reliable job execution
    • Act as a lieson to the business, understanding data requirements and assisting our Business Intelegence team with technical solutions



    Required Qualifications:

    • Degree in Computer Science, Data Science, related field or equivalent practical experience.
    • Expertise in extracting and manipulating data from a variety of sources, primarily cloud based, and loading/indexing into relational data structures
    • Proven experience with relational (Postgres, MS SQL, Redshift) and noSQL (MongoDB) Databases
    • Experience modeling and maintaining tradtional relational database schemas for efficient data storage and retrieval
    • Strong customer-facing communication and careful listening skills. Proven success in and genuine enthusiasm for working directly with customer technical teams

    Desired Skills/Qualifications:

    • Experience with data processing and analytics using AWS Glue or Apache Spark
    • Experience building data-lake style infrastructures using streaming data set technologies such as AWS Kinesis/Firehose or Apache Kafka
    • Experience with data processing using Parquet and Avro
    • Development experience delivering analytics processes utilizing Python or Javascript
    • Experience with web UI development (HTML, CSS, JavaScript)
    • Familiarity with NodeJS, Express, Angular.
    • Experience with front-end BI tools such as Power BI using DAX and M Query


    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.