Kelly Anderson, CPA, MCSE, Developer in Laguna Beach, CA, United States
Kelly is available for hire
Hire Kelly

Kelly Anderson, CPA, MCSE

Verified Expert  in Engineering

Data Engineer and Developer

Location
Laguna Beach, CA, United States
Toptal Member Since
January 19, 2024

Kelly is a data analyst and engineer whose career began in accounting and finance. Over the past 20 years, he has worked for large companies like Netflix, CBRE, and Thomson Reuters. He enjoys all things data and has passed 12 professional exams, helping him keep up with new tools and technologies. This background and continuing education have enabled Kelly to contribute to many successful projects and solutions—including automating the delivery of 1+ million rent statements in eight years.

Availability

Part-time

Preferred Environment

SQL, Python, Tableau, Pandas, SQL Server Integration Services (SSIS), Visual Basic for Applications (VBA), T-SQL (Transact-SQL), SQL Server Reporting Services (SSRS)

The most amazing...

...thing I've developed is a data-driven SSRS report, which automated the delivery of over 1 million tenant rent statements in eight years.

Work Experience

Production Finance Tax and Vendor Data Engineer (Contract)

2021 - 2024
Netflix
  • Maintained and enhanced data pipelines and reports crucial for compliance with regulatory requirements.
  • Collaborated closely with production finance and corporate finance teams to manage and reconcile vendor data across all Netflix productions, concurrently developing processes for aggregating vendor taxable data.
  • Facilitated data analysis, aggregation, and reporting to support key reporting requirements with the IRS—demonstrating my strong SQL and Python skills and a deep understanding of accounting and finance fundamentals.
Technologies: Python, PostgreSQL, Pandas, Tableau, Data Engineering, Data Analysis, Data Pipelines, Apache Airflow, Databases, Data Matching, ETL, Excel 365

Business Systems Advisor | Senior Business Systems Analyst

2005 - 2021
CBRE
  • Developed ETL scripts and SSIS packages to create data pipelines for moving financial information between accounting systems and internal and external data warehouses for reporting and integrations.
  • Executed large-scale data modeling, conversions, integrations, analytics, and visualizations using SQL Server technologies and reporting tools in conjunction with the internal accounting system called MRI Software.
  • Designed, developed, and implemented a custom SSRS solution using data-driven subscriptions that successfully delivered 14,000+ emailed tenant statements monthly.
Technologies: SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Python, Tableau, Data Engineering, Data Analysis, Data Pipelines, Business Requirements, Databases, Data Matching, ETL, Excel 365, APIs

Test Data Pipeline in Snowflake

https://github.com/anderskd12/Snowflake-Data-Pipeline-Project-using-DBT-Python-Streams-Tasks/
A project I developed to showcase how we can create a Snowflake database and pipeline using dbt, Python within Snowflake, and Snowflake streams and tasks. We created a data warehouse and a pipeline using dbt to transform the data to a format usable in a reporting and BI tool.
1996 - 2001

Bachelor's Degree in Accounting and Management Information Systems

University of Wisconsin–Eau Claire - Eau Claire, Wisconsin, USA

MARCH 2023 - MARCH 2025

SnowPro Core Certification

Snowflake

NOVEMBER 2018 - PRESENT

MCSE: Data Management and Analytics

Miscrosoft

MAY 2003 - PRESENT

Certified Public Accountant

Wisconsin Department of Safety and Professional Services

Libraries/APIs

Pandas

Tools

Tableau, Apache Airflow

Storage

Databases, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Pipelines, PostgreSQL, SQL Server Analysis Services (SSAS)

Languages

SQL, Visual Basic for Applications (VBA), T-SQL (Transact-SQL), Python, Snowflake

Paradigms

ETL

Industry Expertise

Accounting

Other

Data Matching, Excel 365, Data Engineering, Data Analysis, Business Requirements, Data Build Tool (dbt), Finance, Information Systems, APIs, MRI Software

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring