Senior Data Engineer

Alpha Consulting Corp. is seeking an experienced Senior Data Engineer to design, develop, and maintain scalable data solutions using Snowflake, Python, Snowpark, and PySpark. The role focuses on ETL/ELT pipelines, cloud data warehousing, data transformation, automation, production support, and collaboration with cross-functional teams using Agile practices.

Responsibilities

• Design, develop, and implement scalable ETL/ELT pipelines within and outside data warehouses using Python and Snowflake SQL
• Develop and optimize complex SQL queries for Snowflake Cloud Data Warehouse environments
• Perform data analysis, transformation, and integration activities within Snowflake
• Build and maintain Snowflake objects including: Stored Procedures, Views, Streams, Tasks, Snowpark applications
• Develop automation scripts using Python, Unix/Shell scripting, and other scripting technologies for data extraction, loading, and transformation
• Troubleshoot and resolve production issues related to Snowflake tables, data reloads, transformations, and data quality
• Create complex SnowSQL scripts supporting enterprise reporting and analytics requirements
• Work with databases including Oracle and Snowflake for data engineering and analytics solutions
• Explore and implement AWS cloud technologies to improve data processing capabilities and efficiency
• Participate in Agile development processes including sprint planning, stand-ups, and delivery activities
• Collaborate with cross-functional teams including data analysts, business users, and application teams

Skills

• 8+ years of experience in Data Engineering / IT industry
• Strong hands-on experience with:
• Snowflake
• Snowpark
• Python
• PySpark
• Strong programming experience with Python libraries:
• Pandas
• NumPy
• Matplotlib
• Expertise in developing ETL pipelines and data transformation workflows
• Strong SQL skills including complex queries and performance optimization
• Experience with Snowflake features:
• Stored Procedures
• Streams
• Tasks
• Views
• SnowSQL
• Strong knowledge of PL/SQL and database scripting automation
• Experience working with databases such as Oracle and Snowflake
• Experience with GitHub and Jupyter Notebook
• Understanding of CI/CD concepts and tools
• Experience working in Agile/Scrum environments
• Snowflake SnowPro Data Engineer certification
• PySpark and Python certifications
• Experience with AWS cloud services
• Knowledge of Generative AI and GitHub Copilot
• Experience with modern data analytics and cloud data platforms

Benefits

• 06 months duration with possibility of extension
• Remote work option

Company Overview

• Alpha Consulting Corp. has been exceeding expectations in the IT, pharmaceutical, and clinical staffing business since 1994. It was founded in 1994, and is headquartered in East Brunswick, New Jersey, USA, with a workforce of 201-500 employees. Its website is http://alphaconsulting.com.

Company H1B Sponsorship

• Alpha Consulting Corp. has a track record of offering H1B sponsorships, with 2 in 2025, 4 in 2024, 3 in 2023, 4 in 2021, 6 in 2020. Please note that this does not guarantee sponsorship for this specific role.