About Shamrock Trading Corporation
Shamrock Trading Corporation is a family of brands that has been serving the transportation and logistics industries since 1986. Shamrock offers factoring solutions, export financing, third-party logistics, a fuel card program and trucking technology.
Shamrock’s mission since the start has been to create value and success for our customers, our partners and our people. Strong ethics, dedication to our customers and close attention to the marketplace are critical to the success and growth of the Shamrock brands. Shamrock is headquartered in Overland Park, Kansas, with multiple offices throughout the U.S. Overland Park is a great place to live, work and play, being conveniently located within driving distance of everything Kansas City has to offer. Housed within the heart of Overland Park, our offices include 4 gorgeous towers on the East and West sides of Metcalf Ave. With a heavy community presence and a winning culture, Shamrock is a great place to work in Overland Park!
Why You’ll Love Working Here
Our award-winning culture is a testament to our commitment to growth, recognition and empowerment. From day one, we prioritize employees first, encouraging them to think and act like owners and providing endless opportunities for growth and self-development, both personally and professionally. Shamrock has been recognized as one of America’s 2025 “Most Loved Workplaces” by Newsweek.
At Shamrock, we hire bright, ambitious people and give them the tools they need for a successful, long-term career here. Shamrock also offers a premier set of benefits for employees and their families:
- Training and Development: Ongoing training and professional development opportunities
- Medical: Fully paid healthcare, dental and vision premiums for employees and eligible dependents, and gym benefits
- Financial: Generous company 401(k) contributions and employee stock ownership after one year
- Work-Life Balance: Competitive PTO and fully paid time off opportunities to volunteer within your community
Regular onsite attendance is an essential function of this position. The role requires direct collaboration with cross-functional teams, real-time problem-solving, and timely responses to customer and operational needs. As a customer-facing position, onsite presence facilitates efficient communication with colleagues and subject matter experts, enabling effective service delivery and faster resolution of customer inquiries and issues. The role also requires participation in team meetings, operational processes, and occasional onsite trainings that are critical to achieving customer service objectives.
About the Role
Shamrock Trading Corporation is looking for an Analytics Engineer II to join the Operational BI team. Shamrock runs more than 600 Power BI reports today alongside a small but growing set of Databricks dashboards, and the company is consolidating its reporting and semantic logic onto the Databricks platform. This role works in both environments: supporting and improving the existing Power BI estate while helping build the gold tables, metric views, and dashboard patterns the team will use to migrate it. The Analytics Engineer II will also own the reporting relationship for one Shamrock division, partnering directly with divisional stakeholders to understand their business, translate operational questions into governed metric definitions, and deliver reporting they trust. Success in the first year looks like a division whose core metrics are defined once in Databricks and consumed everywhere, and a set of migration patterns other analysts can follow without starting from scratch.
What You’ll Do
- Design, build, and maintain gold tables in Databricks that serve as the source of truth for business metrics and KPIs
- Migrate business logic from Power BI semantic models into Databricks metric views, reverse-engineering existing DAX measures and validating results against current reporting
- Build and maintain reporting in both Databricks AI/BI dashboards and Power BI, supporting the existing Power BI estate through the transition
- Contribute to the reusable modeling and migration patterns the Operational BI team uses to move reporting onto Databricks, and document them so teammates can adopt them
- Partner with stakeholders in an assigned Shamrock division to prioritize reporting needs and deliver accurate, intuitive reporting that earns end user confidence in the numbers
- Develop in-depth expertise in one Shamrock division and familiarity with data from the Shamrock family of brands
- Collaborate with data engineers, data modelers, and BI analysts on strategic data initiatives and shared data assets
- Monitor and test data sets and reporting for accuracy and reliability, and apply version control and code review practices to analytics code
- Be a resource to BI analysts adopting Databricks, sharing technical and data source knowledge as the team's skill set shifts
What You’ll Bring
- 3+ years as an Analytics Engineer, Data Engineer, BI Developer, or similar role with a strong technical background
- Advanced SQL skills, writing performant queries that are easy to read and troubleshoot for data modeling and analytics
- Experience designing and building curated or gold layer data sets in a medallion or similar layered warehouse architecture
- Hands-on experience with Databricks, including building and publishing AI/BI dashboards
- Experience building a governed semantic layer or centralized metric definitions, such as Databricks metric views, dbt metrics, or LookML. At Shamrock this is implemented in Databricks metric views
- Strong Power BI experience, including semantic model design and the ability to read and reverse-engineer existing DAX measures
- Familiarity with relational databases (Postgres, Redshift, MS SQL) and data warehousing concepts
- Experience with GitHub and software engineering best practices such as version control and code reviews
- Strong written and verbal communication skills, with the ability to clearly present complex concepts and analytical findings to business leaders
- Bachelor's degree in Computer Science, Data Analytics, Finance, Economics, or a related field, or equivalent experience
What Will Set You Apart
- Experience developing Databricks Apps
- Experience with a development language such as Python
- Experience migrating reporting or semantic models from one BI platform to another
- Experience in transportation, logistics, financial services, or a similar operations-heavy industry
Apply Today!
We’re so excited to connect with you! If you want to work with forward-thinking people in an award-winning culture, submit your application today.
#LI-Onsite #LI-MB1
Having trouble submitting your application? Contact us at [email protected] for support.
Skills Required
- 3+ years of experience as an Analytics Engineer, Data Engineer, BI Developer, or in a similar technical role
- Advanced SQL skills for performant, readable, and maintainable data modeling and analytics queries
- Experience designing and building curated or gold-layer datasets in a medallion or similar layered warehouse architecture
- Hands-on Databricks experience, including building and publishing AI/BI dashboards
- Experience building a governed semantic layer or centralized metric definitions, such as Databricks metric views, dbt metrics, or LookML
- Strong Power BI experience, including semantic model design and reverse-engineering DAX measures
- Familiarity with relational databases such as PostgreSQL, Amazon Redshift, or Microsoft SQL Server
- Experience with GitHub, version control, and code review practices
- Strong written and verbal communication skills for presenting complex concepts and analytical findings to business leaders
- Bachelor's degree in Computer Science, Data Analytics, Finance, Economics, or a related field, or equivalent experience
- Experience developing Databricks Apps
- Experience with a development language such as Python
- Experience migrating reporting or semantic models between BI platforms
- Experience in transportation, logistics, financial services, or a similar operations-heavy industry
Shamrock Trading Corporation Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Shamrock Trading Corporation and has not been reviewed or approved by Shamrock Trading Corporation.
-
Affordable Benefits — Medical, dental, and vision premiums are fully paid for employees and eligible dependents, with spouse coverage available when no other employer plan exists. This structure meaningfully lowers the cost of coverage for families.
-
Retirement Support — A 3% safe-harbor 401(k) contribution is provided regardless of employee deferral, with additional company contributions historically noted. This employer funding bolsters retirement savings even for newer hires.
-
Equity Value & Accessibility — An Employee Stock Ownership Plan is company-funded after one year, enabling employees to build ownership value over time. Materials highlight ESOP contributions alongside the 401(k) program.
Shamrock Trading Corporation Insights
What We Do
Shamrock Trading Corporation is the parent company for a family of brands in transportation services, finance and technology. Our brands include Ryan Transportation, RTS Financial, RTS International, RTS Carrier Services and ProTransport. Headquartered in Overland Park, KS with 9 offices across the U.S., Shamrock has been regularly named “Best Places to Work” by the Kansas City Business Journal
