Data Engineer / Business Intelligence Engineer

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.
Phase I of this project is to POC three different semantic layer alternatives to their existing Azure Analysis Services Tabular models. These will be AtScale, Cube.dev, and Microsoft Fabric. After they have selected which semantic layer will reside in front of their new Databricks warehouse, a pre-defined selection of Dimensions, Facts, and Metrics will be implemented in the new semantic layer. Finally, existing PowerBI front-ends will be pointed to the new semantic layer. This will not require reworking the front end, but will require adjusting the data model and how it is loaded to adjust to the model of the new semantic layer. This will require knowing how to read, understand and translate documented DAX code into the new semantic layer in either DAX, MDX, or SQL.

Role & Responsibilities:Understand DAX and translate existing calculations into the technology of the new semantic layer.Create dimensions, hierarchies, and metrics in conformity with a star schema.Convert the dataset population in PowerBI from AAS to the new technology of the semantic layer platform.Hard Skills - Must have:DAXT-SQLData 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:PowerBIDatabricksMS FabricAtScalecube.devSoft Skills / Business Specific Skills:Communication in English

#J-18808-Ljbffr