Senior Power BI Analytics Engineer – Remote (US)

aspenviewtech; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

AspenViewTech seeks an experienced Data Engineer/BI Modeler to own reporting and data modelling for enterprise teams. You will build pipelines, data models, and Power BI reports, clarifying business needs and delivering scalable solutions in a largely remote setup.

Responsibilities include designing dimensional models, managing ETL/ELT in Azure, ensuring performance and data quality, and collaborating with analysts and stakeholders to raise risks and improve delivery practices.

Qualifications

• Experience in data modelling and BI modelling
• Strong SQL and dimensional modelling skills
• Excellent communication in English and stakeholder management
• Ability to gather requirements and translate them into data solutions

Responsibilities

• Gather requirements and translate business rules into data models, marts, and Power BI reports using Power Query and DAX.
• Design scalable dimensional models, including star and snowflake schemas, and manage historical data with slowly changing dimensions.
• Build and maintain batch and near real-time ETL/ELT pipelines in the Azure environment.
• Improve data platform performance, reliability, and cost efficiency; monitor pipelines and resolve data quality issues.
• Document lineage, transformations, and architecture, while applying appropriate governance, security, and compliance practices.
• Work with analysts, developers, and business stakeholders to challenge assumptions and strengthen delivery practices.

Job description

Role overview

Own the reporting and data modelling layer that enterprise teams use to make decisions, from clarifying business needs through building pipelines, data models, and Power BI reports. The role calls for an experienced individual contributor who can improve existing practices, raise risks early, and work directly with technical and business stakeholders.

Responsibilities

• Gather requirements and translate business rules into data models, marts, and Power BI reports using Power Query and DAX.
• Design scalable dimensional models, including star and snowflake schemas, and manage historical data with slowly changing dimensions.
• Build and maintain batch and near real-time ETL/ELT pipelines in the Azure environment.
• Improve data platform performance, reliability, and cost efficiency; monitor pipelines and resolve data quality issues.
• Document lineage, transformations, and architecture, while applying appropriate governance, security, and compliance practices.
• Work with analysts, developers, and business stakeholders to challenge assumptions and strengthen delivery practices.

Requirements

• Bachelor’s or Master’s degree in computer science, information systems, or a related field.
• At least six years of hands‑on data engineering or BI modelling experience, including substantial Power BI and data warehousing work.
• Required experience with Azure Data Factory and Synapse Link, plus strong SQL and dimensional modelling skills.
• Familiarity with data integration tools such as dbt, SSIS, Apache Airflow, Fivetran, or Talend.
• Working knowledge of Azure DevOps and Agile or Scrum delivery; able to communicate clearly in English and work independently.
• Based in the United States and eligible to access export‑controlled information, or able to obtain the required authorization.

Nice to have

• Experience with AX or D365 Finance and Operations data entities and manufacturing processes.

Benefits and work setup

Fully remote within the United States, with work aligned to U.S. business hours. Employment visa sponsorship is not available.