Analytics Engineer II

Shamrock Trading Corporation is hiring an Analytics Engineer II for the Operational BI team in Overland Park, KS (onsite) to evolve reporting into Databricks while improving governed metrics and KPI reuse.

Responsibilities

• Design, build, and maintain gold tables in Databricks as the source of truth for business metrics and KPIs
• Move business logic from Power BI semantic models into Databricks metric views by reverse-engineering existing DAX measures and validating results against current reporting
• Develop and maintain dashboards and reporting in both Databricks AI/BI dashboards and Power BI to support the current Power BI reporting estate during the transition
• Build and share reusable modeling and migration patterns used by the Operational BI team, and document them for teammate adoption
• Work with stakeholders for an assigned Shamrock division to prioritize reporting needs and deliver accurate, intuitive reporting that end users trust
• Develop deep expertise in a single division and become familiar with data across 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 datasets and reporting for accuracy and reliability; apply version control and code review practices to analytics code
• Support BI analysts adopting Databricks by sharing technical and data source knowledge as team skills shift

Requirements

• 3+ years in an Analytics Engineer, Data Engineer, BI Developer, or similar role with strong technical background
• Advanced SQL skills, including writing performant queries that are easy to read and troubleshoot for data modeling and analytics
• Experience creating curated or gold layer datasets 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 (examples: Databricks metric views, dbt metrics, or LookML), with implementation at Shamrock using Databricks metric views
• Strong Power BI experience, including semantic model design and the ability to read and reverse-engineer DAX measures
• Familiarity with relational databases and data warehousing concepts: Postgres, Redshift, MS SQL
• Experience with GitHub and software engineering best practices such as version control and code reviews
• Strong written and verbal communication skills, including 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

Technologies

• Power BI
• Databricks
• Databricks AI/BI dashboards
• Databricks metric views
• DAX
• SQL
• dbt metrics
• LookML
• GitHub
• Python
• Postgres
• Redshift
• MS SQL
• Version control
• Code review

Benefits

• 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

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