Riley Powell

Data Analyst • Data Engineer • Backend Engineer • Denver, CO, US

Alteryx

Data Science

Web Scrapping

Data Cleaning

NoSQL

ETL

pandas

Data Analysis

MongoDB

Databases

SQL

Database Design

T-SQL

Object-oriented programming

SQLite

scikit-learn

Matplotlib

Programming

Jinja

Python

Available for hire fromNegotiable

Full-Time Roles

Contracts

I have expertise with Python and SQL along with a deep understanding of advanced practices for both, I have also worked with NoSQL, R, AWS, and others

Are you looking to hire a new tech expert for a data centered role? Look no further than the new Riley Powell™ this model is fresh from the factory and comes with preset Python and SQL understanding. With experience in data modeling in relational databases, creating automation solutions with Python, and building ETL pipelines. These units are fully capable of operating independently while maintaining their projects but tend to thrive when put in a team dynamic. In the past these models have been implemented at universities, fast-paced high-growth tech startups, and even very early stage Saas startups.

Projects

Contract management web app

• Implemented ETL pipelines and SQL logic to support the data that the backend calls using Python, Pandas, SSMS. • Built the backend using Python, Flask framework, SQLAlchemy, Jinja. • Designed user interface using Jinja, CSS, HTML, and JavaScript.See More

Work History

Data Engineer

Fixed Point AnalyticsDec 2023 - Present • 10 mos• Design Saas frontend and build backend infrastructure using R Shiny and MongoDB. • Maintain and update ETL procedures as well as implement new pipelines as needed. • Research novel solutions for ad hoc requests using Python, R, SQL, MongoDB, Cloud services. • Manage projects independently and meet consistent timelines. • Communicate with stakeholders and clients. • Perform data gathering and cleaning.

Data Analyst II

Dish NetworkJan 2022 - Jun 2023 • 1 yr 6 mos• Created and maintained ETL pipelines using Pandas, Numpy, and a variety of libraries and technologies. • Writing complex ad hoc SQL queries using CTE's, window functions, multiple joins, date time manipulations, and groupings. • Oversaw automation and design of contract awards process resulting in total contract savings of over $17 million. • Led small teams in creating data driven projects utilizing various technologies including Python, SQL, Alteryx, and AWS. • Maintained and managed MSSQL Database. Duties include data integrity, creating stored procedures, adding triggers, forming table relationships • Perform data mining and web scraping. • Pursued and investigated areas needing improvement and implemented solutions resulting in reduced hours on manual tasks, increased efficiency, and improved data integrity.

Machine Learning Intern

University of New HampshireOct 2019 - Oct 2020 • 1 yr 1 mo• Developed a classification model to identify astrophysical events. • Implemented an ensemble model to predict the occurrence of events from time-series data. • Gained professional experience with Python, SciKit-Learn, Pandas, NumPy.

Education

University Of New Hampshire

Bachelors Degree, Engineering PhysicsAug 2017 - May 2021

Similar Pangeans

How Pangea Works

Effortlessly discover top talent

We’ve distilled the candidate search from endless hours down to just a few minutes. Using Pangea’s AI-powered search tools, you can find top fractional talent able to take on your next project. Our system looks at your company’s niche and your needs to find the perfect match faster than any traditional hiring platform.

Start working with talent today

The top talent on Pangea is ready to get started with you right now. You can message or hire a candidate right from their profile page and start assigning work as soon as they respond. And the best part? Pangea’s fractional contract structure lets you start small and ramp up as your needs change, keeping your costs manageable and your team’s capabliities flexible.

Track work and invoices in one place

Assign tasks, track progress, and complete invoices all on Pangea. We’ve combined every part of the hiring process into one platform to eliminate the miscommunication that’s unavoidable on other freelance platforms. We even send out 1099s to your contractors at the end of the year!

Talk with a Talent Expert

Members of our team are available to help you speed through the hiring process.

Available Now

Book a Call