Design and implement data ingestion and transformation processes to load data from disparate source systems into Snowflake and downstream data platforms
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
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

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
Working knowledge of cloud-based data platforms and modern data pipeline design principles
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

Competitive pay
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

SQLSnowflakeAzure Data FactoryETLELTdata pipeline designdata integrationCI/CDquery optimizationstored procedures

Soft Skills

attention to detailcommunicationcollaborationmentoringtechnical guidancecode reviewsproblem-solvingtime managementknowledge sharingstakeholder engagement