Job Title: Senior Data Engineer (Remote – PST Hours) Location: Remote (Must be authorized to work in the U.S. and able to support Pacific Time hours) We are seeking a Senior Data Engineer to support a large-scale initiative focused on designing, building, and deploying multiple data pipelines and a robust ELT (Extract, Load, Transform) system. The goal is to ingest, validate, and manage high-volume data from multiple sources related to electric vehicle (EV) charging infrastructure. The engineered pipelines will enable secure ingestion, transformation, and daily refresh of data used for internal analytics and dashboard reporting. The data supports various state-funded programs and includes sensitive information like geolocation and telematics data for compliance and performance monitoring. Key Responsibilities • Design and implement scalable data pipelines for high-volume, real-time data ingestion. • Develop and maintain ELT processes using dbt, Snowflake, Python, and AWS technologies. • Ensure high standards of data quality, security (including PII), and cost optimization. • Support geocoding workflows to enrich address data with latitude and longitude coordinates. • Build models using Data Vault 2 and Star Schema designs. • Optimize Snowflake performance and manage incremental refresh strategies. • Collaborate with cross-functional teams to ensure data usability and accessibility for analytics. Required Qualifications • Minimum 4+ years of experience in authoring and monitoring data pipelines. • At least 3 years of hands-on experience with: • Snowflake, dbt, Python, AWS services (SES/SNS, Lambda using Boto3, file systems). • Micro-batch and near real-time ingestion techniques. • Data modeling (Data Vault 2, Star Schema). • Geocoding workflows within ELT pipelines. • Snowflake incremental refreshes and cost optimization for large datasets. • Handling PII and sensitive data in secure data environments. • Data quality frameworks and management practices. • Bachelor's or advanced degree in Computer Science, Engineering, Information Systems, Math, or related field. • Note: Equivalent experience may be considered in place of a degree. Completion of a Data Engineering bootcamp + 1 year of experience may also be considered.