Riley Powell

Riley Powell

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

3 yrs experience · Denver, CO · 30-40 hrs/week

About

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.

Skills

AIAlteryxAnalytical ThinkingAnalyticsApache SparkData AnalysisData CleaningData ScienceDatabase DesignDatabasesETLJinjaMachine LearningMatplotlibMongoDBNoSQLPlotlyPowerBIProgrammingPythonRSQLSQLiteT-SQLWeb Scrappingpandasscikit-learn

Experience

  • Data Engineer · Fixed Point Analytics12-01-2023

    • 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 Network01-01-2022 – 06-01-2023

    • 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 Hampshire10-01-2019 – 10-01-2020

    • 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.

  • Senior Analyst · Republic Services10-01-2024

    Communicate with field users, leadership, and technical developers to coordinate data driven projects. Work primarily in Snowflake, SQL Server, and Python building data. Create dashboards for field users in PowerBI ensuring data integrity and user access.

Education

  • University Of New HampshireBachelors Degree, Engineering Physics

Similar talent on Pangea

Hire Riley through Pangea

Describe your project to the Pangea agent — see if Riley is a fit, with transparent pricing and interviews booked straight onto your calendar. No contact details change hands until you hire.

See if Riley is a fit