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.
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.