Analytics Engineer

Shamrock Trading Corporation

Shamrock Trading Corporation, headquartered in Overland Park, KS, leads a family of brands in transportation services, finance, and technology across the US. Recognized as a top workplace, their extraordinary growth is fueled by exceptional talent and customer relationships. This role will enhance the data capabilities of the team by designing and maintaining data sets for the Business Intelligence and Data Science teams.

In this role you can expect to have the responsibilities:

• Collaborate with stakeholders to design data sets of key metrics.
• Leverage SQL skills to prepare metrics for analysis by intelligence teams.
• Maintain documentation and version control for business metrics data sets.
• Monitor data sets to ensure accuracy and reliability.
• Develop data warehouse assets for efficiency and quality optimization.
• Recommend SQL improvements for data consistency.
• Curate a data catalog to support analytics and reporting.

This role comes with the following benefits:

• Fully paid healthcare, dental, and vision premiums.
• Competitive PTO and work-from-home eligibility.
• Generous 401(k) contributions and stock ownership.
• Onsite gym, jogging trail, and fitness center discounts.

This role requires you to have:

• 2+ years experience in a technical role such as Data Engineer or BI Developer.
• Proficient in writing and optimizing SQL for data modeling.
• Familiarity with relational databases and data warehousing.
• Experience using DBT or similar data transformation tools.
• Experience with analytics tools like Power BI.
• Bachelor’s Degree in Computer Science, Data Analytics, or related field.

You would benefit from having:

• Experience with a development language such as Python.
• Understanding of software engineering practices including version control and code reviews.

Shamrock Trading Corporation offers training and development opportunities to foster long-term careers. They also prioritize work-life balance and comprehensive benefits for employees and their families.