ETL / Data Engineer (BigQuery & Starburst)

ETL / Data Engineer (BigQuery & Starburst)

Location: Charlotte, NC

Hybrid

Role Summary 

We are looking for ETL/Data Engineers with strong experience in BigQuery and Starburst to design, build, and optimize scalable data pipelines supporting analytics and AI-driven use cases. 

Key Responsibilities

·       Design and develop scalable ETL/ELT pipelines for structured and semi-structured data

·   Build and optimize data ingestion, transformation, and loading processes into BigQuery

·       Develop federated query solutions using Starburst (Trino/Presto) across heterogeneous data sources

·       Implement data modeling, schema design, and partitioning strategies for performance optimization

·       Ensure data quality, validation, and governance across pipelines

·   Collaborate with data science and AI teams to enable downstream analytics and Gen AI use cases

·       Manage scheduling, orchestration, and monitoring of ETL workflows

Required Skills

·       Strong experience in Google BigQuery (data modeling, querying, performance optimization, cost management)

·       Hands-on experience with ETL/ELT pipeline development and large-scale data processing

·       Experience with Starburst / Trino / Presto for distributed query processing

·       Proficiency in Python, SQL, and Spark-based processing frameworks

·       Experience with workflow orchestration tools (Airflow, ADF, etc.)

·       Strong understanding of data warehousing concepts and data governance 

Preferred

·       Experience with cloud data platforms (Google Cloud Platform, AWS, Azure)

·       Exposure to data lakehouse architectures and federated query models

·       Understanding of supporting AI/ML and analytics workloads

Alchemy: Transforming Your Professional Vision into Reality

Since our inception in 2013, Alchemy has been dedicated to reshaping organizational performance through innovative IT services. With a vision to empower businesses seeking a transformative edge, we’ve positioned ourselves at the forefront of digitization and software modernization.

Our name reflects our mission: to transmute technology into gold-standard solutions for our esteemed clients. We proudly serve a diverse range of sectors, including IT and ITES, BFSI, Telecom and Media, Automotive, Manufacturing, Energy, Oil and Gas, Real Estate, Retail, Healthcare, and more.

With a global footprint spanning the USA, India, Europe, Canada, Singapore, Japan, and parts of Central and West Africa, we harness a unique blend of competencies, frameworks, and cutting-edge technologies. Together, we drive growth and innovation across industries, helping organizations turn their visions into reality.

Alchemy – Connecting Talent with Opportunities (Diversity, Equity and Inclusion)