Data Engineer (Atscale + Kimball)

Remote: 
Full Remote
Contract: 
Work from: 

Offer summary

Qualifications:

Deep knowledge of AtScale and MDX calculations., Strong proficiency in SQL, data modeling, and performance tuning., Expertise in SQL warehousing and Kimball methodologies., Experience with Microsoft SQL Server, SSAS, and data migration in enterprise environments..

Key responsibilities:

  • Conduct proof of concept (POC) for AtScale.
  • Evaluate and recommend the best semantic layer platform.
  • Transform data from the curated to the refined layer, applying business logic.
  • Define measures, dimensions, hierarchies, and relationships for the semantic layer.

Allata logo
Allata Scaleup https://allata.com/
201 - 500 Employees
See all jobs

Job description

Allata is a global consulting and technology services firm with offices in the US, India, and Argentina. We help organizations accelerate growth, drive innovation, and solve complex challenges by combining strategy, design, and advanced technology. Our expertise covers defining business vision, optimizing processes, and creating engaging digital experiences. We architect and modernize secure, scalable solutions using cloud platforms and top engineering practices.

Allata also empowers clients to unlock data value through analytics and visualization and leverages artificial intelligence to automate processes and enhance decision-making. Our agile, cross-functional teams work closely with clients, either integrating with their teams or providing independent guidance—to deliver measurable results and build lasting partnerships.



We are seeking a skilled Data Engineer with expertise in AtScale to help our client to improve their loyalty program by migrating and upgrading their data analysis capabilities.  
 
The project will involve transforming data from the curated layer into the refined layer, building the semantic layer, and defining measures, dimensions, hierarchies, and relationships within the data. 

Role & Responsibilities:
  • Conduct POC for AtScale. 
  • Evaluate and recommend the best semantic layer platform for our needs. 
  • Recreate existing SQL Server Analysis Services (SSAS) cubes in the selected platform. 
  • Translate existing DAX (Data Analysis Expressions) code into the new platform 
  • Leverage MDX (Multidimensional Expressions) and SQL as needed based on the selected platform. 
  • Define measures, dimensions, hierarchies, and relationships to build the semantic layer 
  • Transform data from the curated to the refined layer, ensuring proper business logic is applied. 

  • Hard Skills - Must Have:
  • Deep knowledge of AtScale and MDX calculations. 
  • Strong proficiency in SQL, data modeling, and performance tuning. 
  • Expertise in SQL warehousing and using modeling methodologies such as Kimball. 
  • Hands-on experience with Microsoft SQL Server, SSAS, and SSRS. 
  • Experience with data migration and transformation in enterprise environments. 
  • Familiarity with Power BI and data visualization techniques. 
  • Ability to define business logic within the context of the data model. 
  • Comfortable working with cloud-based data platforms (e.g. Databricks). 

  • Hard Skills - Nice to Have/It's a Plus:
  • Experience with automation and CI/CD pipelines (e.g., Azure DevOps, Jenkins, Octopus) and trunk-based development. 
  • Exposure to loyalty or customer rewards systems. 
  • Industry experience in retail or restaurant analytics. 

  • Soft Skills / Business-Specific Skills:
  • Ability to identify, troubleshoot, and resolve complex data issues effectively.
  • Proven ability to communicate clearly in English and work collaboratively with cross-functional teams.
  • Dedication to delivering high-quality, accurate, and reliable data product solutions.
  • Willingness to embrace new tools, technologies, and methodologies, with a proactive and innovative approach to overcoming challenges.
  • Required profile

    Experience

    Spoken language(s):
    English
    Check out the description to know which languages are mandatory.

    Other Skills

    • Collaboration
    • Communication
    • Proactivity
    • Quality Assurance
    • Troubleshooting (Problem Solving)
    • Innovation

    Data Engineer Related jobs