Design and implement data ingestion and transformation processes to load data from disparate source systems into Snowflake and downstream data platforms to enable reliable enterprise reporting and analytics
Migrate existing on-premises SQL Server data processes and datasets to Azure-based solutions to improve scalability, performance, and long-term maintainability
Integrate Azure Data Factory with Snowflake for automated data extraction, transformation, and loading processes
Develop, test, and maintain SQL scripts, stored procedures, and data pipelines to ensure accurate, timely, and efficient data processing
Ensure data is created, structured, and maintained according to established standards and documentation requirements to support data governance and usability
Build and configure end-to-end telemetry, alerting, and self-healing capabilities to proactively identify and resolve data pipeline issues
Collaborate with business stakeholders to understand requirements and translate them into effective data integration and MDM solutions
Implement CI/CD pipelines for data engineering projects to enhance deployment and automation capabilities
Ensure thorough documentation and compliance with data standards across all processes
Mentor and support junior team members through knowledge sharing, technical guidance, and code reviews to strengthen team capability and consistency
Strive for continuous improvement of code quality and development practices
Participate as part of a Tier-3 on-call rotation to support team-built software

Requirements

1+ year of experience in analytics or data engineering
2+ years of experience in SQL Server development or equivalent SQL-based data engineering environments
Proficiency in Snowflake development, including stored procedures, UDFs, query performance tuning, and Snowpipe configuration
Strong SQL development skills, including query optimization and stored procedure design
Solid understanding of ETL/ELT processes, data integration patterns, and foundational data warehouse concepts
Experience supporting and troubleshooting data integrations across cross-functional teams
Proficiency with version control systems such as Git or TFS
Knowledge of CI/CD pipelines and best practices for data engineering projects
Strong attention to detail with the ability to manage multiple priorities and deadlines effectively
Excellent communication and collaboration skills.

Benefits

Medical, Dental and Vision Plans
Paid Holidays & PTO
Short and Long-Term Disability
Paid Life Insurance
401(k) Retirement Plan
Employee Stock Purchase Plan
Lithia Learning Center
Vehicle Purchase Discounts
Wellness Programs

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data ingestiondata transformationSQL ServerAzureSnowflakeSQL scriptsstored proceduresdata pipelinesETLCI/CD

Soft Skills

communicationcollaborationattention to detailmentoringtechnical guidancecontinuous improvementproblem-solvingtime managementteamworkknowledge sharing