What are the responsibilities and job description for the ETL / Data Engineer (BigQuery & Starburst) position at Alchemy Software Solutions LLC?
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)