Data Engineer with Snowflake

## About the Role As a Data Engineer with Snowflake at Nearshore Business Solutions, you will play a pivotal role in designing and implementing scalable data infrastructure, including data privacy features and multi-party collaboration solutions. Your work will directly impact the company's ability to process and analyze large volumes of data efficiently and securely. You will be part of a growing team that values innovation and collaboration.

The role of a data engineer is crucial in today's data-driven world. With the exponential growth of data, companies need skilled professionals who can design, build, and maintain large-scale data systems. As a data engineer at Nearshore Business Solutions, you will have the opportunity to work on complex projects, develop your skills, and contribute to the company's success.

The team you will be working with is a dynamic group of professionals who are passionate about data engineering and collaboration. You will have the chance to work closely with cross-functional teams, including engineering and analytics, to support data accessibility, reliability, and operational efficiency.

## What You Will Do - Design and implement scalable data privacy features and secure multi-party collaboration solutions, including data clean rooms and query constraints - Build, optimize, and maintain Snowflake-based data warehouse architectures, ELT pipelines, and high-performance data structures - Develop and manage robust data pipelines using SQL, Python, AWS Lambda, Airflow, and Redshift - Implement data governance, quality controls, and security measures to protect sensitive and financial data, including PII - Create scalable solutions for processing and transforming large datasets exceeding 200B+ records - Optimize Snowflake performance through advanced tuning, partitioning, Streams, SnowPipes, Views, and stored procedures - Collaborate with cross-functional engineering and analytics teams to support data accessibility, reliability, and operational efficiency - Support CI/CD initiatives and deployment automation using Jenkins and modern SDLC practices

## What We Are Looking For - 4+ years of experience as a Data Engineer or Software Engineer - Strong proficiency in SQL and Python for large-scale data processing and transformation - Hands-on expertise with the Snowflake ecosystem, including SnowPipes, Streams, Views, performance tuning, data modeling, and ELT pipelines - Experience with AWS services, including Lambda, Airflow, and Redshift - Solid understanding of data warehouse concepts, scalable data architecture, and storage optimization - Experience implementing complex SQL stored procedures and managing enterprise-scale datasets - Familiarity with CI/CD pipelines, Jenkins, and software development lifecycle best practices - Ability to work effectively within U.S. business hours and collaborate with distributed teams

## Nice to Have - Experience building and maintaining APIs using Node.js and Next.js - Familiarity with Swagger/OpenAPI specifications - Exposure to AI concepts and modern data collaboration technologies - Experience with data visualization and analytics platforms

## Benefits and Perks - Competitive salary and benefits package - Opportunity to work with cutting-edge technologies and innovative solutions - Collaborative and dynamic work environment - Professional development and growth opportunities - Flexible working hours and remote work arrangements - Access to a global network of professionals and experts in the field - Comprehensive health insurance and wellness programs - Generous paid time off and vacation days - Retirement savings plan and financial planning resources

• Be prepared to provide examples of your experience with Snowflake and cloud data engineering. Showcase your skills in designing and implementing scalable data infrastructure and multi-party collaboration solutions.
• Highlight your proficiency in SQL and Python, as well as your experience with AWS services, including Lambda, Airflow, and Redshift. Be ready to discuss your approach to data governance, quality controls, and security measures.
• Make sure to research the company and its values, and be prepared to discuss how your skills and experience align with their needs.
• Consider creating a portfolio that demonstrates your expertise in data engineering, including examples of your work with Snowflake and other relevant technologies.
• When negotiating salary, be prepared to discuss your expectations and requirements, and be aware of the market rates for data engineers in the industry.
• Pay attention to the company culture and values, and be sure to ask questions about the team you will be working with and the opportunities for growth and development.