Shamrock Trading Corporation

BI ETL Specialist

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 Corporation is in the process of building out a Business Intelligence Team and is searching for a ETL Specialist. The BI ETL Specialist will be a key part of Shamrock’s BI team and will report to the BI Manager. Much of this role will involve extracting data from a wide array of sources, collaborating with BI Reporting Analysts to transform data, and then work with the BI Specialist to build out a data warehouse that supports all BI deliverables. This role will also require building strong relationships with the Shamrock Infrastructure Team, as they will be a key resource in the success of this role and the team as a whole.


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 ETL Specialist 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. The optimal person for this role will exhibit all previously stated characteristics and have a strong desire for continued education/professional growth.




Required Qualifications

  • Degree in Data Analytics, Data Science, Computer Science or another related field
  • Proven experience with relational databases such as Postgress SQL and MS SQL that utilize SQL queries
  • Expertise in extracting and manipulating data from a variety of sources and loading/indexing into Azure SQL data warehouses
  • Experience creating large transactional database structures indexed to optimize storage and performance
  • Experience with Microsoft Power BI or clearly exhibits the ability to quickly adapt to working with new business intelligence tools
  • 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


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.