← Back to jobs

Avance Consulting Logo
Data Modelling and Analytics Engineer

Avance Consulting

 

Washington,United States

Posted On: 1 day ago
Experience: 5+ years
Availability: Hybrid
Openings: 2
Category: Data modelling and Analytics engineer
Tenure: Full-time Only
Related Jobs

No related jobs found

Description

You will design, implement, and maintain semantic models and data transformation workflows to drive business analytics.

Responsibilities

  • Design and maintain scalable Power BI semantic models using star schema design.
  • Develop and optimize complex DAX queries, including measures, calculated columns, and tables.
  • Build and manage ETL pipelines and data processing workflows using Databricks Lakehouse and Azure Databricks.
  • Implement modular and reusable data transformation models using DBT.
  • Configure advanced Power BI features such as row-level security, incremental refreshes, and Power Query transformations.
  • Required Skills

    • 5+ years of experience in data modelling and analytics engineering.
    • Expertise in Power BI semantic model development and DAX.
    • Proficiency in SQL query development and optimization.
    • Hands-on experience with Databricks Lakehouse and Azure Databricks.
    • Experience implementing data transformations using DBT.
    • Strong understanding of data warehousing concepts and ETL processes.
    • Experience with star schema design and data visualization best practices.
    • Ability to implement row-level security and incremental data refreshes.
    • Preferred Skills

      • Experience integrating APIs to extend Power BI functionality.
      • Experience developing analytical solutions using AI capabilities, predictive analytics, or machine learning models within Power BI.

Key Skills
Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs