Analytics Engineer II

Shamrock Trading Corporation; Overland Park (KS); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Training and Development

Medical: healthcare premiums for you

401(k) contributions

Paid time off

Job summary

Shamrock Trading Corporation is seeking 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.

The role emphasizes building gold tables, refining semantic layers, and delivering trusted dashboards across Databricks and Power BI during a transition period.

Qualifications

• 3+ years in Analytics Engineer, Data Engineer, BI Developer, or similar role with strong technical background.
• Advanced SQL skills for performant, readable queries.
• Experience creating gold layer datasets in a medallion-like warehouse.
• Hands-on Databricks experience including AI/BI dashboards.

Responsibilities

• Design, build, and maintain gold tables in Databricks as the source of truth for metrics and KPIs.
• Migrate business logic from Power BI semantic models into Databricks metric views.
• Develop and maintain dashboards in Databricks AI/BI dashboards and Power BI.
• Create reusable modeling and migration patterns and document them for team adoption.
• Collaborate with data engineers, modelers, and BI analysts on strategic data initiatives.
• Monitor datasets for accuracy and reliability; apply version control and code reviews.

Skills

Advanced SQL

Power BI

Databricks

DAX

Python

GitHub

Version control

Code reviews

Strong communication

Education

Bachelor's degree (CS, Data Analytics, Finance, Economics)

Tools

Databricks

Databricks metric views

dbt metrics

LookML

Power BI

DAX

Postgres

Redshift

MS SQL

GitHub

Job description

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