Skip to content
CV Rocket
Get started
How it worksThe enginePricingBlogContactSign in

Open nowPosted 16 days ago

Analytics Engineer II

shamrocktc114 open roles

Where
Overland Park, KS, USA
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowAnalytics Engineer IIshamrocktc · Overland Park, KS, USA

  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on shamrocktc's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

7.8% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 1.6%1 day
  2. 3.4%3 days
  3. 7.8%7 days
  4. 14.3%14 days
  5. 33.7%30 days
This job: posted 16 days ago

The posting

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  

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against shamrocktc's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.

  3. We apply on shamrocktc's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.

  4. Every reply, sorted

    shamrocktc's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.

  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

Get the CV for this job
By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.