Mid-Level Data Engineer

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.

The Data Engineer 2 will join a fun, dynamic team to help solve integration and data problems relating to sports and entertainment. This role will design, build, and maintain data pipelines using a modern data stack — combining data from cloud and on-premises systems, transforming it with dbt, and orchestrating workflows end to end. The position is responsible for ETL/ELT from many disparate systems into the data warehouse and offers the opportunity to own projects from beginning to end.

The team is finalizing its target data architecture between two directions — a balanced on-prem/cloud modernization and a best-in-class cloud-native platform — so the right candidate will bring strong fundamentals that apply to both, along with depth in at least one. Architectural guidance will be available, but this engineer must be able to implement data models effectively and independently. The right candidate will be motivated to learn, contribute to the team and organization, and grow along with the business.

• →Monitor and maintain production ADF integrations, dbt job schedules, and Snowflake warehouse health.
• →Manage multiple data projects concurrently while consistently meeting sprint and delivery milestones.
• →Maintain role-based access controls (RBAC), data masking, and governance in Snowflake to protect Personally Identifiable Information (PII) and ensure regulatory compliance (e.g., HIPAA).

• Design, build, and maintain automated data ingestion pipelines from cloud and on-premises sources into Snowflake using Azure Data Factory (ADF).
• Translate business requirements into efficient ELT workflows using ADF for orchestration/ingestion and dbt (Core or Cloud) for in-warehouse transformations.
• Build, test, and document scalable data models and transformations in dbt layered directly on Snowflake.
• Monitor, schedule, and optimize ADF pipelines, dataset triggers, and dbt runs to ensure high pipeline reliability and data freshness.
• Implement dimensional data models (Star/Snowflake schemas) optimized for Snowflake performance and cost efficiency.
• Perform data cleansing, standardization, and staging using ADLS Gen2/Blob storage landing zones.
• Write Python code (or Azure Functions/Snowpark routines) to handle complex API extractions, custom transformations, and automated utility tasks.

• Apply CI/CD practices (e.g., Azure DevOps, GitHub Actions) for dbt model deployment, ADF ARM templates, and version control.
• Implement automated data quality testing via dbt tests, custom Snowflake alerts, and ADF error handling.
• Optimize Snowflake compute/storage costs, virtual warehouse configurations, query performance, and dbt execution times.
• Proactively identify pipeline bottlenecks, data drift, or failures and resolve unexpected data quality issues.

• Prepare, structure, and expose semantic data layers and data marts in Snowflake for BI reporting tools (e.g., Power BI, Tableau).
• Identify new internal and external data sources, integrating them into the Snowflake ecosystem via ADF based on business demand.
• Collaborate with data analysts and business stakeholders to turn complex data requests into performant technical solutions.

• Bachelor's degree in Information Systems, Computer Science, or a related field.
• 3–5 years of hands-on data engineering or analytics engineering experience.
• Snowflake: Strong hands-on experience with Snowflake architecture (virtual warehouses, staging, zero-copy cloning, tasks/streams, and performance tuning).
• dbt: Demonstrated proficiency with dbt (Core or Cloud) for modular transformation, macro development, testing, and documentation.
• Azure Data Factory: Hands-on experience creating, configuring, monitoring, and troubleshooting ADF pipelines, linked services, integration runtimes, and parameterization.
• SQL & Modeling: Advanced SQL expertise and proven experience with dimensional data modeling concepts.
• Python & Cloud Storage: Proficient in Python scripting and familiar with Azure cloud storage patterns (ADLS Gen2, Azure Blob Storage).
• Analytics Engineering / DevOps: Practical experience with Git, CI/CD pipeline automation for data code, and automated testing patterns.
• Experience integrating data layers with modern BI visualization tools (e.g., Power BI, Tableau).

• Snowflake SnowPro Core Certification or Azure Data Engineer Associate (DP-203) certification.
• Experience with Snowpark, Python UDFs, or Snowflake Native Apps.
• Advanced Azure ecosystem knowledge (Azure Key Vault, Managed Identities, Azure Functions, Azure DevOps).

• Exceptional attention to detail and strong commitment to data quality.
• Clear verbal and written communication skills across technical and non-technical audiences.
• Strong organizational skills with the ability to prioritize and self-manage in a fast-paced environment.

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.