Senior Power BI Analytics Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Create and develop Power BI reports utilizing data modeling, Power Query, and DAX.

• Conduct analysis and gather requirements to convert business logic into effective data solutions.

• Engage with data analysts, BI developers, and business stakeholders for effective communication.

• Design and execute scalable data marts and BI data models in Azure Data Factory and Microsoft Fabric, applying dimensional modeling principles including star and snowflake schemas.

• Establish strategies for managing historical data and slowly changing dimensions, incorporating SCD types 1, 2, and 3.

• Create and document data lineage, transformations, and architectural components.

• Develop and oversee ETL/ELT pipelines for batch processing as well as near real-time data ingestion.

• Enhance Azure Data Factory objects, such as tables, views, and warehouses, for optimal performance and cost efficiency.

• Monitor, troubleshoot, and maintain the reliability and accuracy of data pipelines and models.

• Enforce data governance, security, and compliance best practices.

• Operate within Azure DevOps and Agile/Scrum methodologies.

• Question existing patterns, identify risks early, and enhance the team’s practices.

⛳️ Requirements

• Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related discipline.

• Over 6 years of practical experience in data engineering or BI data modeling.

• More than 6 years of expertise with Power BI, encompassing data warehousing, virtual warehouses, and cost optimization.

• Experience in complex, detailed environments, including global organizational architecture and enterprise data solutions.

• Required experience with Azure Data Factory and Synapse Link.

• Proficient SQL skills.

• Familiarity with dimensional modeling, data marts, and historical dimensions.

• Experience using data integration tools such as dbt, SSIS, Apache Airflow, Fivetran, or Talend.

• Working knowledge of Azure DevOps and Agile/Scrum delivery methodologies.

• Excellent written and verbal communication skills in English.

• Self-motivated, with a focus on delivery, resilience, and adaptability.

• Must be eligible to access export-controlled ITAR information, or AspenView must obtain the necessary government authorization.

• Must be permanently authorized to work in the country of residence and must not require visa sponsorship now or in the future.

🏝️ Benefits

• Fully remote work available within the United States.

• Working hours align with U.S. business hours.

• Equal opportunity and inclusive work environment.

• Visa sponsorship policy: applicants must be permanently authorized to work in their country of residence and not require sponsorship now or in the future.