Note: The job is a remote job and is open to candidates in USA. Alpha Consulting Corp. is seeking an experienced Data Engineer/Architect with strong expertise in Snowflake, Oracle SQL, and cloud platforms. The role involves designing scalable data architectures, building ELT/ETL pipelines, and enabling enterprise-wide analytics and reporting solutions.
Responsibilities
- Design and implement enterprise-scale data architectures and integration strategies
- Develop conceptual, logical, and physical data models including star and snowflake schemas
- Build, optimize, and maintain scalable ELT/ETL pipelines for batch and real-time processing
- Work extensively with Snowflake, Oracle SQL, and cloud-based data platforms
- Design and manage data lakes, warehouses, and data marts to support analytics and reporting
- Ensure data quality, governance, security, and compliance with standards such as GDPR and HIPAA
- Collaborate with business stakeholders, analysts, and data scientists to translate business requirements into technical solutions
- Optimize SQL queries, database performance, and data processing workflows
- Implement orchestration and workflow automation using tools such as Airflow, dbt, or similar technologies
- Support cloud migration and modernization initiatives across AWS, Azure, or Google Cloud environments
Skills
- 5–10+ years of experience in Data Engineering, Data Architecture, or Software Engineering
- Strong programming skills in Python, Java, or Scala
- Expert-level SQL skills with extensive experience in Oracle SQL
- Hands-on expertise with Snowflake and modern cloud data warehouses
- Experience with cloud platforms: AWS, Azure, or Google Cloud Platform
- Strong understanding of data modeling, ETL/ELT, and data warehousing concepts
- Experience with orchestration and streaming tools such as Apache Kafka, Airflow, and dbt
- Knowledge of data governance, security frameworks, and access control mechanisms
- Excellent problem-solving, communication, and stakeholder management skills
Benefits
- Competitive salary and benefits package
- Supportive and collaborative work environment
- Opportunities for professional growth and development
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.