Transform Your Career with Us At AspenView Technology Partners, we're passionate about empowering organizations to achieve their goals through innovative technology solutions. Our team specializes in creating high-performing IT teams that help North American clients innovate faster and more efficiently. Why Choose This Opportunity? This role offers a unique chance to work on cutting-edge data engineering projects, leveraging your expertise in Business Intelligence (BI) data modeling, data marts design and development in Snowflake, and managing slowly changing dimensions and historical data structures. You'll collaborate with cross-functional teams to deliver robust analytics and reporting capabilities. What We're Looking For: - 4+ years of hands-on experience in data engineering or BI data modeling. - Proficiency with Snowflake, 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, Apache Airflow, Fivetran, Talend, or similar). - Familiarity with streaming platforms and near-real-time ingestion frameworks (e.g., Kafka, Snowpipe, AWS Kinesis). - Knowledge of data quality frameworks, CI/CD for data pipelines, and version control systems (e.g., Git). What's Next? As a key member of our team, you'll have the opportunity to: - Design and implement scalable data marts and BI data models in Snowflake using dimensional modeling principles. - 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 effectively. - Collaborate with data analysts, BI developers, and business stakeholders to translate business requirements into data solutions. - Optimize Snowflake 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. Let's Grow Together! AspenView is an equal opportunity employer committed to fostering a culture of inclusion and diversity. We welcome applicants from all walks of life and offer a dynamic work environment where everyone can thrive and make a lasting impact. ],