Analytics Engineer II

Shamrock Trading Corporation - Overland Park, KS

Hiring: Analytics Engineer II Company: Shamrock Trading Corporation Location: Overland Park, KS Job Posted Time: 2026-09-16 22:27:25 Target Skills & Keywords : Databricks, GitHub, PostgreSQL, Python, Redshift, SQL, SQL Server, dbt About the job Experience: •3+ years as an Analytics Engineer, Data Engineer, BI Developer, or similar role with a strong technical background Required Skills: •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 •Partner cross-functionally 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 Compensation: •Medical: Fully paid healthcare, dental and vision premiums for employees and eligible dependents, and gym benefits Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!