Senior BI / Analytics Engineer

Build the Future with AspenView Technology Partners At AspenView, we are passionate about transforming the way organizations approach technology. We specialize in creating high-performing, nearshore IT teams to help North American clients innovate faster and more efficiently. As we continue to grow, we’re looking for exceptional people to join our team and help drive impactful change across industries. Why Join AspenView? At AspenView, we’re more than a nearshore IT partner—we’re a people-first, purpose-driven company that believes great culture drives great outcomes. We’re passionate about connecting talent and technology to deliver measurable value for clients—and meaningful career paths for our people. Here’s what you can expect: Competitive base Comprehensive benefits and wellness support Flexible work model: hybrid, remote, or in-office Real growth opportunities and leadership visibility Inclusive, respectful culture that blends U.S. innovation with Colombian heart A company that listens, invests in you, and celebrates wins together 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.