Transforming Technology with AspenView We're a passionate team dedicated to revolutionizing the way organizations approach technology. Our mission is to create high-performing, nearshore IT teams that help North American clients innovate faster and more efficiently. Why Choose AspenView? At AspenView, we're more than just a nearshore IT partner – we're a people-first, purpose-driven company that believes great culture drives great outcomes. We're committed to connecting talent and technology to deliver measurable value for clients and meaningful career paths for our people. What You Can Expect: - Competitive base with a strong, uncapped commission structure. - 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're seeking an experienced Data Engineer with a strong background in Business Intelligence (BI) data modeling, data marts design and development in Snowflake, 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. Key Responsibilities: - Design and implement scalable data marts and BI data models in Snowflake 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 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. Requirements: - Bachelor's or Master's degree in Computer Science, Information Systems, or related field. - 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). Nice-to-Have Skills: - Experience with cloud platforms (AWS, GCP, or Azure). - Familiarity with BI platforms such as Tableau, Looker, or Power BI. - Working knowledge of scripting languages (Python, Bash). - Experience in an Agile/Scrum development environment. 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.