Bluelight Consulting
Data Engineer (Senior) - ETL (Python+Snowflake) - Remote, Latin América
Be an Early Applicant
Design, build, and maintain scalable ETL/ELT data pipelines using Python/PySpark and Snowflake. Implement Snowflake objects and optimizations, perform dimensional modeling, integrate data from APIs, databases, and cloud storage, enforce data quality/governance, monitor and tune workloads, and collaborate with architects and stakeholders to deliver production-ready data solutions.
Bluelight is a leading software consultancy dedicated to designing and developing innovative technology that enhances users' lives. With a steadfast commitment to delivering exceptional service to our clients, Bluelight excels in its focus on quality and customer satisfaction. Our mission is not only to create cutting-edge applications but also to foster a collaborative and enriching work environment where each team member can grow and thrive. With a presence across the United States and Central/South America, Bluelight is in an exciting phase of expansion, continually seeking exceptional talent to join its dynamic and diverse community.
We are looking for a skilled individual to join our rapidly growing team at Bluelight. This position is ideal for someone who thrives in a fast-paced, dynamic environment where everyone's opinions and efforts are valued and appreciated. You will have the opportunity to contribute to challenging and meaningful projects, developing high-quality applications that stand out in the market. We value continuous learning, personal growth, and hard work, offering a collaborative environment that promotes professional development. If you are passionate about software development and eager to be part of a growing software consultancy, we invite you to apply and join us on this exciting journey.
What we are looking for
- Education & Experience
- Education: Bachelor’s degree in Computer Science, Information Technology, Data Engineering, or a related field (or equivalent professional experience).
- Core Experience: Proven experience developing end-to-end data pipelines extracting/transforming/loading data from REST APIs, relational databases, cloud storage, and flat files.
- Snowflake Proficiency: Demonstrated hands-on experience with virtual warehouses, streams, tasks, stages, Snowpipe, secure data sharing, and performance optimization.
- SQL: Advanced SQL development skills with the ability to write complex queries, tune performance, and optimize large-scale workloads.
- Data Modeling: Experience with dimensional modeling techniques (star schemas, fact tables, dimension tables).
- Cloud & DevOps:
- Familiarity with cloud-based data ecosystems, particularly Microsoft Azure.
- Managing source code and CI/CD pipelines using Git and Azure DevOps (or similar).
- Soft Skills & Practices:
- Strong analytical, problem-solving, and detail-oriented mindset.
- Excellent verbal and written communication skills; ability to collaborate in a fast-paced environment with evolving priorities.
- Knowledge of data integration best practices, data governance, and enterprise data management.
- Preferred / Nice-to-Have
- Certifications: SnowPro, Azure Data Engineer Associate, or equivalent cloud data platform certifications.
- Advanced Tech: Big data technologies, machine learning, data science platforms, or advanced analytics.
- BI Tools: Power BI, Tableau, or similar visualization platforms.
- Methodologies: Agile delivery frameworks and DevOps practices.
- Preferred Tech Stack Summary
- Core: Snowflake, Python/PySpark, SQL
- Cloud & Orchestration: Azure Data Lake Storage (ADLS), Azure Data Factory, Azure Key Vault
- DevOps & Infrastructure: Git, Azure DevOps, CI/CD, Infrastructure as Code (Terraform preferred)
- Integration & Analytics: REST APIs, Power BI
Responsibilities
- Data Engineering & ETL Development
- Design, develop, and maintain scalable ETL/ELT pipelines using Python (PySpark), Snowflake, and cloud-native technologies.
- Build reliable, efficient, and reusable data ingestion, transformation, and loading processes.
- Snowflake Data Platform & Warehousing
- Utilize Snowflake’s architecture to design, build, and optimize modern cloud data solutions.
- Implement and manage Snowflake objects (databases, schemas, tables, views, streams, tasks, stages, stored procedures).
- Leverage virtual warehouses, data sharing, time travel, and automated scaling to balance performance and cost efficiency.
- Apply dimensional modeling (star schemas, facts, dimensions) to build scalable enterprise data warehouses.
- Data Integration & Modeling
- Extract and ingest structured and semi-structured data from REST APIs, relational databases, SaaS apps, flat files, and cloud storage.
- Develop robust ingestion frameworks.
- Collaborate with data architects and stakeholders to create logical and physical data models aligned with business goals.
- Cloud Architecture & Standards
- Contribute to modern data platform concepts (data lakes, lakehouses, data mesh architectures, enterprise data catalogs).
- Support integration between Snowflake and cloud-native services (primarily Azure).
- Establish and enforce data engineering standards and best practices.
- Quality, Governance & Security
- Implement automated data quality controls, validation frameworks, and monitoring processes.
- Support data governance initiatives and maintain adherence to organizational standards.
- Ensure data security, privacy, and regulatory compliance (access controls, masking policies, industry best practices).
- Optimization, Operations & Maintenance
- Monitor and optimize Snowflake workloads, ETL/ELT processes, and SQL queries to meet SLAs.
- Analyze warehouse utilization and recommend performance and cost-efficiency improvements.
- Monitor pipelines, diagnose performance issues, and implement long-term solutions; support production environments and incident resolution.
- Maintain comprehensive documentation for pipelines, flows, transformations, data models, and operational processes.
- Collaboration
- Partner with cross-functional teams (data architects, data scientists, analysts, business stakeholders) to understand requirements and provide technical expertise.
Company Benefits
- Competitive salary and bonuses, including performance-based salary increases.
- Generous paid-time-off policy
- Flexible working hours
- Work remotely
- Continuing education, training, conferences
- Company-sponsored coursework, exams, and certifications
Being a consultant in our team is a fun, challenging, and rewarding career choice. Your contributions are highly valued by clients, and the work you do often has a direct and significant impact on their business.
You will have the opportunity to work on a variety of projects for our incredible clients, which will accelerate your career growth. You’ll collaborate with modern technologies and work alongside some of the best professionals in the industry!
If you’re eager to be part of an exciting, challenging, and rapidly growing consultancy, we encourage you to apply. #LI-Remote
Similar Jobs
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Drive new business and expand existing enterprise accounts across Central America. Build executive relationships, develop account plans, lead virtual teams, qualify and forecast opportunities, and close enterprise security deals while collaborating with internal partners to meet quota.
Top Skills:
MeddicMiller-HeimanSalesforceTas
Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Lead business development and account ownership for Mastercard Services with direct revenue targets. Hunt and close opportunities with financial institutions, fintechs and merchants. Serve as primary client-facing contact with C-suite stakeholders, drive end-to-end sales, partner with account and client services teams, and coach project teams to deliver high-quality analyses, recommendations, and presentations.
AdTech • Artificial Intelligence • Marketing Tech • Software
Edit high-volume short-form paid social ads (UGC, demos, podcast clips) optimized for Meta, TikTok, and YouTube Shorts. Produce multiple variations, iterate using retention and CPA data, collaborate with strategists and producers, manage project files, and stay current on short-form trends and ad specs.
Top Skills:
Adobe After EffectsAdobe Premiere ProCapcutMeta (Facebook) AdsTiktokYoutube Shorts
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
