Senior Data Analyst

Kake Group; United States; Remote; USD 120,000 - 160,000; Full time

Job summary

Kake Group is seeking a Senior Data Analyst to lead enterprise analytics. You will own Power BI semantic models end to end, leverage Snowflake and dbt, and partner with Finance, Sales, and Operations to deliver trusted, reconciled reporting.

You will translate business needs into technical specifications, design data models, and ensure accuracy and governance while migrating legacy reports to Power BI. This role supports a remote, fast-paced environment.

Qualifications

• 5+ years of BI development or analytics experience.
• Expert Power BI skills, including DAX, semantic modeling, and star schema.
• Advanced SQL proficiency.
• Hands-on experience with Snowflake and dbt.
• Experience writing technical specifications and reviewing work from data engineering teams.
• Experience partnering with business stakeholders to define metrics and KPIs.
• Excellent written and verbal communication in English.
• Ability to work independently in a remote, fast-paced environment.

Responsibilities

• Design, build, and maintain enterprise Power BI semantic models (star schema).
• Define and own data modeling standards, documentation, and best practices.
• Coordinate with an external data engineering partner working in Snowflake and dbt; write specifications and review deliveries.
• Build financial reporting based on ERP data, reconciled to the general ledger.
• Support migration from Tableau to Power BI, turning legacy reports into governed metrics.
• Partner with Finance, Sales, and Operations to align metric definitions and train users.

Skills

BI development

Power BI

DAX

semantic modeling

SQL

Snowflake

dbt

spec writing

KPIs

stakeholder comms

Tools

Power BI

Snowflake

dbt

Job description

We’re looking for a Senior Data Analyst to lead the design and delivery of enterprise analytics. You’ll own Power BI semantic models end to end, working on a modern data stack built on Snowflake and dbt, and partner closely with Finance, Sales, and Operations to deliver trusted, reconcilable reporting. This role calls for deep expertise in DAX, data modeling, and SQL, along with the ability to translate business needs into clear technical specifications. It’s a great fit for someone who enjoys both hands‑on development and owning the standards behind it.

Key Responsibilities

• Design, build, and maintain enterprise Power BI semantic models (star schema), including DAX and SQL logic
• Define and own data modeling standards, documentation, and best practices
• Coordinate with an external data engineering partner working in Snowflake and dbt: write technical specifications, run requirements sessions, and review deliveries against acceptance criteria
• Build financial reporting based on ERP data, reconciled to the general ledger
• Support the migration from Tableau to Power BI, turning legacy reports and Excel logic into governed business metrics
• Partner with Finance, Sales, and Operations to align metric definitions, and train users through workshops and documentation

Core Requirements

• 5+ years of experience in BI development, data analytics, or similar roles
• Expert-level Power BI skills, including DAX, semantic modeling, and star schema design
• Advanced proficiency in SQL
• Hands‑on experience with Snowflake and dbt
• Experience writing technical specifications and reviewing work from data engineering teams or vendors
• Experience partnering with business stakeholders to define metrics and KPIs
• Excellent written and verbal communication skills in English.
• Ability to work independently in a remote, fast‑paced environment.

Nice-to-Have

• Experience with financial or ERP data (e.g. Microsoft Dynamics GP, SAP Business One)
• Experience migrating reports from Tableau to Power BI
• Experience with Microsoft Fabric or Azure ecosystem tools (e.g. Synapse, Data Factory)
• Familiarity with scripting languages such as Python or R

Additional

• US Timezone Overlap: 6–7 hours with GMT-5
• Self‑starter with strong ownership and attention to detail