Match score not available

Data Engineer/ BI

Remote: 
Full Remote
Contract: 
Experience: 
Mid-level (2-5 years)
Work from: 

Offer summary

Qualifications:

Proficient in DAX and T-SQL, Experience with Snowflake, Fabric, Databricks, Understanding of Business Intelligence concepts, Experience in creating dimensions and metrics, Familiarity with Power BI is a plus.

Key responsabilities:

  • Translate DAX calculations for new semantic layer
  • Create dimensions, hierarchies and metrics
  • Convert dataset population in PowerBI to new technology
Allata logo
Allata Scaleup https://allata.com/
201 - 500 Employees
See more Allata offers

Job description

Allata is an IT company dedicated to strategy, architecture, and enterprise-level application development with offices in the US, India, and Argentina. We aim to be strategic advisors for our clients, focusing on helping them enhance or scale business opportunities, create efficiencies, automate processes through custom technologies, and find elegant solutions to inefficient problems.

We provide Data Analytics, Advanced Integrations, Product Launch, Experience Design, Support, Cloud, DevOps, Software Development, among other services. Our agile centralized development teams powered by our on-site senior leadership allow us to work with you as a stand-alone group be it integrating into your in-house dev teams or providing external architectural guidance.



We are helping our client to improve their loyalty program by migrating and upgrading their data analysis capabilities. 
The project involves migrating the existing SQL Server backend and Microsoft Analysis Services (SSAS) to Databricks. We aim to replace SSAS with a new semantic layer by conducting a proof of concept (POC) for three different platforms: Microsoft Fabric, AtScale, and Cube.dev.  

Role & Responsibilities:
  • Understand DAX and translate existing calculations into the technology of the new semantic layer.
  • Create dimensions, hierarchies and metrics in conformity to a star schema.
  • Convert the dataset population in PowerBI from AAS to the new technology of the semantic layer platform.

  • Hard Skills - Must have:
  • DAX
  • T-SQL
  • Data Engineering (Snowflake, Fabric, Databricks, or similar)
  • Business Intelligence concepts and experience (Star Schema, Hierarchies, Dimensions, Facts, Metrics, Calculations)

  • Hard Skills - Nice to have/It's a plus:
  • PowerBI
  • Databricks
  • MS Fabric
  • AtScale
  • cube.dev

  • Soft Skills / Business Specific Skills:
  • Strong english communication skills.
  • Analytical and problem-solving abilities with a keen eye for detail. 
  • Ability to work effectively in a team and communicate complex concepts clearly. 
  • Required profile

    Experience

    Level of experience: Mid-level (2-5 years)
    Spoken language(s):
    EnglishEnglish
    Check out the description to know which languages are mandatory.

    Other Skills

    • Problem Solving
    • Teamwork
    • Analytical Thinking
    • Verbal Communication Skills

    Data Engineer Related jobs