Software Engineer Developer

Andrew Allen

Data & Software Engineer

SKILLS & TOOLS

mobile: 425-***-****

email: ***************@*****.***

social: linkedin.com/in/andrewjeffreyallen

< / > : github.com/andrewjeffallen

6+ years: Python, SQL, Linux,

Git, Docker, Tableau

5+ years: AWS, Snowflake, ETL, Postgres,

Agile, Data Lake/Warehouse

4+ years: dbt, PySpark, IaC & Terraform,

CI/CD, Energy Markets/Trading

3+ years: DataDog, CircleCI, Kubernetes,

Argo, Kustomize, Looker

2+ years: Kafka, Prometheus, Grafana

1+ years: Go, Scala, Kotlin

Cal Poly, San Luis Obispo

MS Industrial Engineering

- Specialization in Data Science and Optimization

BS Industrial Engineering

- Statistics Minor, Extra CS + Math courses

Masters Thesis - ML Time Series Forecasting

• Developed a scalable and accurate ML-based

forecasting model that provided valuable insights for decision-making in the energy industry, contributing to improved operational efficiency and cost savings.

Founder & Software Developer - NightDog Energy LLC

• Developed, deployed, and maintained the core

product software infrastructure using AWS services

(EC2, ECS, ECR, Lambdas), Snowflake, Docker, and

Python.

• Created data pipeline for analyzing utility data from energy smart meters, leveraging AWS ECS, Docker,

dbt, and Snowflake. Developed a Python integration for SkyFoundry’s analytics platform.

Senior Software Engineer - Data & ML Engineering Sept 2023 - Present Fluence Energy San Diego, CA

• Continuation of previous role; promoted to team lead responsible for three data engineers that maintain data platform ingestion, data service reliability, ML data operations, and data migration services.

• Implemented platform-wide data engineering initiatives, driving standardization and simplification of Python libraries, job scheduling, and data management utilities.

• Collaborated with data scientists, engineers, and energy subject matter experts to gather requirements and design ETL solutions for integrating new energy market data sources.

• Provided DataOps/DevOps support and consultation to non-technical stakeholders and data power users, ensuring efficient data management practices and enhancing overall system performance.

• Improved and maintained both the backend and data infrastructure for internally-used optimization applets that perform battery revenue forecasting and simulation.

• Promote a data-driven culture by providing guidance and consultation on industry-leading data storage, database management, and analytics best practices.

• Supported commercial and business development by delivering product demos and proof- of-concept data products to engage prospective customers. Data Engineer - Data & ML Engineering February 2022 - Sept 2023 Fluence Energy San Diego, CA

• Developed and designed robust ETL processes, data architecture, APIs, and cloud infrastructure to support the backend for ML-based, algorithmic trading software for assets participating in wholesale electricity markets.

• Constructed end-to-end data pipelines enabling real-time ingestion of energy market price data for accurate forecasting and optimization tasks.

• Developed a unified data model that accelerated product market entry by 7x, optimizing workflows and reducing time-to-market.

• Led a small team of contractors to migrate legacy, low-code ETL SaaS product to an in-house framework using Python, dbt, Argo, Kubernetes, and AWS, ensuring seamless integration of new and migrated data features while maintaining high standards. Data Engineer August 2020 – October 2021

Slalom Consulting LLC Denver, CO

• Led a successful migration and modernization project for a Fortune 100 Telecoms client, transitioning their data systems from legacy platforms to Snowflake and AWS, resulting in improved scalability, performance, and cost-efficiency of their data infrastructure.

• Implemented a robust data warehouse solution from the ground up for a client in manufacturing industry, leveraging AWS S3, Glue, Redshift, Python, and dbt. Developed and optimized ETL processes to ensure efficient data extraction, transformation, and loading, enabling streamlined data management and analytics for various manufacturing use cases.

• Collaborated closely with stakeholders to understand business requirements and translate them into effective data models, ensuring the data warehouse architecture aligned with the client's specific needs and allowed for insightful reporting and analysis.

• Developed a web-based data catalog tool using Python, dbt, Terraform, and Docker that allowed business users to view a comprehensive inventory of data, lineage, dependencies, and metadata.

• Provided guidance and recommendations on data engineering best practices, including data ingestion, data quality, and data security, ensuring compliance and adherence to industry standards throughout the project lifecycle.

Snowflake SnowPro Core

Tableau Desktop Certified Associate

EDUCATION

CERTIFICATIONS

PROJECTS

CONTACT RELEVANT EXPERIENCE

Contact this candidate