Senior Power BI Analytics Engineer

AspenView Technology Partners

. Design and build Power BI reports using data modelling, Power Query, and DAX .

Posted 11/7/2026full-timeRemote • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and building Power BI reports, implementing scalable data solutions using Azure Data Factory, and optimizing data pipelines for performance. Proficient in data governance, compliance best practices, and effective communication with stakeholders.

Highest-signal resume keywords

Power BI ReportingAzure Data FactorySQL ProficiencyDimensional ModellingData Governance

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ModellingDAXETL/ELT PipelinesData WarehousingData Integration ToolsHistorical DimensionsSCD Types 1, 2, and 3Performance OptimizationData Lineage DocumentationBusiness Logic Translation

Soft Skills

Strong Communication SkillsIndependent Self-LearningDelivery FocusResilienceFlexibility

Tools & Technologies

Azure DevOpsAgile MethodologiesScrumDbtSSISApache AirflowFivetranTalendMicrosoft FabricSynapse Link

Industry Keywords

Data EngineeringBI Data ModellingGlobal Organisation ArchitectureEnterprise Data SolutionsCost Optimization

Tech Stack

Tools & technologies

AirflowApacheAzureETLSnowflakeSQLSSIS

About the role

Key responsibilities & impact

Design and build Power BI reports using data modelling, Power Query, and DAX
Run analysis and requirements gathering to translate business logic into data solutions
Communicate with data analysts, BI developers, and business stakeholders
Design and implement scalable data marts and BI data models in Azure Data Factory and Microsoft Fabric using dimensional modelling principles, including star and snowflake schemas
Implement strategies for historical data and slowly changing dimensions, including SCD types 1, 2, and 3
Design and document data lineage, transformations, and architecture components
Develop and manage ETL/ELT pipelines for batch processing and near real-time data ingestion
Optimize Azure Data Factory objects, including tables, views, and warehouses, for performance and cost efficiency
Monitor, troubleshoot, and ensure reliability and accuracy of data pipelines and models
Implement data governance, security, and compliance best practices
Work within Azure DevOps and Agile / Scrum methodologies
Challenge incumbent patterns, surface risks early, and improve the team’s practices

Requirements

What you’ll need

Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field
6+ years of hands-on experience in data engineering or BI data modelling
6+ years of proficiency with Power BI, including data warehousing, virtual warehouses, and cost optimization
Experience in complex, detailed environments, including global organisation architecture and enterprise data solutions
Azure Data Factory and Synapse Link experience (required)
Strong SQL skills
Experience with dimensional modelling, data marts, and historical dimensions
Experience with data integration tools such as dbt, SSIS, Apache Airflow, Fivetran, or Talend
Working knowledge of Azure DevOps and Agile / Scrum delivery
Strong written and verbal communication skills in English
Independent self-learning, delivery focus, resilience, and flexibility
Must be eligible to access export-controlled ITAR information, or AspenView must be able to obtain the required government authorization
Must be permanently authorized to work in country of residence and must not require visa sponsorship now or in the future

Benefits

Comp & perks

100% remote work within the United States
Working U.S. business hours
Equal opportunity and inclusive workplace
Visa sponsorship policy: applicants must be permanently authorized to work in their country of residence and not require sponsorship now or in the future