Senior Power BI Analytics Engineer - Fully 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

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.