Description:

Allata is a global consulting and technology services firm with offices in the US, India, and Argentina.
The company helps organizations accelerate growth, drive innovation, and solve complex challenges by combining strategy, design, and advanced technology.
The Data Engineer position is focused on improving a client's loyalty program by migrating and upgrading their data analysis capabilities.
The project involves transforming data from the curated layer into the refined layer, building the semantic layer, and defining measures, dimensions, hierarchies, and relationships within the data.
Responsibilities include conducting POC for AtScale, evaluating and recommending the best semantic layer platform, recreating existing SQL Server Analysis Services (SSAS) cubes, translating existing DAX code, leveraging MDX and SQL, and ensuring proper business logic is applied during data transformation.

Requirements:

Candidates must have deep knowledge of AtScale and MDX calculations.
Strong proficiency in SQL, data modeling, and performance tuning is required.
Expertise in SQL warehousing and using modeling methodologies such as Kimball is essential.
Hands-on experience with Microsoft SQL Server, SSAS, and SSRS is necessary.
Experience with data migration and transformation in enterprise environments is required.
Familiarity with Power BI and data visualization techniques is important.
Candidates should be able to define business logic within the context of the data model.
Comfort with cloud-based data platforms, such as Databricks, is expected.
Nice to have skills include experience with automation and CI/CD pipelines, exposure to loyalty or customer rewards systems, and industry experience in retail or restaurant analytics.
Soft skills required include the ability to identify, troubleshoot, and resolve complex data issues, clear communication in English, collaboration with cross-functional teams, dedication to high-quality data solutions, and a proactive approach to embracing new tools and methodologies.

The position offers the opportunity to work in a global consulting and technology services firm.
Employees will be part of agile, cross-functional teams that work closely with clients to deliver measurable results.
The role allows for remote work flexibility.
There is an emphasis on professional growth and the chance to work with advanced technologies and methodologies.
Employees will have the opportunity to contribute to meaningful projects that drive innovation and improve client outcomes.