About the role
We are seeking an experienced Data Engineer with a strong background in Business Intelligence (BI) data modeling, data marts design and development in Power BI, and deep knowledge of managing slowly changing dimensions and historical data structures. The ideal candidate will have demonstrated expertise in integrating batch and near-real-time data pipelines from various source systems to power robust analytics and reporting capabilities.
What you will do:
- Design and implement scalable data marts and BI data models in Azure Data Factory/Fabric using dimensional modeling principles (star/snowflake schema).
- Develop and manage ETL/ELT pipelines supporting both batch processing and near-real-time data ingestion.
- Implement strategies to manage historical data and slowly changing dimensions (SCD Types 1, 2, 3) effectively.
- Collaborate with data analysts, BI developers, and business stakeholders to translate business requirements into data solutions.
- Optimize Azure Data Factory objects (tables, views, warehouses) for performance and cost-efficiency.
- Design and document data lineage, transformations, and architecture components.
- Monitor, troubleshoot, and ensure reliability and accuracy of data pipelines and models.
- Implement best practices for data governance, security, and compliance.
What you bring:
- Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field.
- 5-8 years of hands-on experience in data engineering or BI data modeling.
- Proficiency with Power BI, including experience in data warehousing, virtual warehouses, and cost optimization.
- Strong SQL skills and experience with dimensional modeling, data marts, and historical dimensions.
- Experience working with data integration tools (e.g., dbt, SSIS, Apache Airflow, Fivetran, Talend, or similar).
Nice if you have:
- Familiarity with streaming platforms and near-real-time ingestion frameworks (Fabric Link).
- Knowledge of data quality frameworks, CI/CD for data pipelines, and version control systems (e.g., Git).
Equal Opportunity Employer:
AspenView is proud to be an equal opportunity employer. We believe in creating an environment where all employees feel welcome, valued, and empowered to succeed. We celebrate diversity and strive to build a culture of inclusion where all individuals, regardless of their race, color, gender, gender identity or expression, sexual orientation, disability, age, or any other characteristic, can thrive. We encourage applicants from all walks of life to join our team and make a lasting impact.