Heather Sorrells

Heather Sorrells Email and Phone Number

Data Engineer | Analytics Engineer | SQL | Snowflake | dbt | Python | Bringing accounting experience and business insights to data engineering teams @ FortyAU
Heather Sorrells's Location
Harrisburg, South Dakota, United States, United States
Heather Sorrells's Contact Details
About Heather Sorrells

Hello! My name is Heather and I am a data engineer that loves working in Snowflake and dbt!Let me share just a little bit about my journey so far...After 20 years of bookkeeping, I originally returned to college to get my degree in accounting, but I graduated with a degree in Management of Information Systems and Business Analytics. During my studies, I found that I loved solving data questions with SQL. As I completed my last course, I enrolled in a full-stack web development bootcamp to try something more technical. Yep, you guessed it. I found that I loved to code and learn new languages!I would love to tell you more about my favorite project with Slalom Build where I improved a client's QE process for deploying Airflow pipelines then led other devs through the staging process during zero-day vulnerability deployments! Or maybe you might want to hear more about how I built an in-house app using PowerAutomate, Excel, and OfficeScripts. Or better yet, I could share about my time at Tackle and how I migrated dbt models from Redshift to Snowflake, converted existing SQL queries to dbt, and even began optimizing the query structures for better performance!Over the past few years, I proved to be adaptable and agile as I pivoted with changing project priorities and quickly learned new software. My willingness to document processes, comment code, and create readmes increases collaboration and knowledge transfer with my teams. My easygoing nature helps me to roll with the punches as I work with my team to tackle unexpected challenges. My grit and determination to solve puzzles and reach my goals (whether in coding, education, or life) keeps me motivated to continuously learn and grow as a data engineer. Oh, and my team tells me that I am always smiling!Life changes are never easy and take many unexpected turns along the way, but the biggest lesson that I have learned from my journey is to have the confidence to pursue goals that seem impossible and have the courage to try something different.When I began my journey, I had no idea at the time that it would lead me into data engineering! I am so glad that I did! I love working as a data engineer!!SKILLS:SQL, Snowflake, dbt, Python, AWS, GCP, Azure, CircleCi, Fivetran, Airflow, Rio, DataDog

Heather Sorrells's Current Company Details
FortyAU

Fortyau

View
Data Engineer | Analytics Engineer | SQL | Snowflake | dbt | Python | Bringing accounting experience and business insights to data engineering teams
Heather Sorrells Work Experience Details
  • Fortyau
    Data Engineer
    Fortyau May 2023 - Present
    Nashville, Tennessee, Us
    - Data Pipelines: Built and maintained AWS cloud native data pipelines using TypeScript Lambdas deployed with Pulumi CI/CD pipelines to pull data from partner APIs and write responses to either DynamoDB or S3 buckets then migrate that data into Snowflake raw, integrated and presentation layers.- Data Migration: Utilized both AWS Schema Conversion Tool and Data Migration Service to migrate legacy MS SQL Server data systems into AWS Aurora Postgres databases. - Documentation: Documented how to build AWS cloud native data pipelines using TypeScript Lambdas, DynamoDB, S3 buckets, Pulumi, and Snowflake.
  • Tackle.Io
    Data Engineer
    Tackle.Io Jul 2022 - Mar 2023
    Remote, Us
    - Data Migration: Built and maintained dbt data models in Redshift and Snowflake published via CircleCI pipelines. Assisted with data migration work from Redshift to Snowflake.- Data Monitoring: Developed data pipeline monitoring alerts in Datadog by parsing application logs. Integrated alerts into Slack.- Data Optimization: Monitored query performance during our data migration from Redshift to Snowflake to make sure we had parity or better. Optimized SQL queries in Redshift and Snowflake to improve run times and reduce computation costs.- Documentation: Developed and documented alert procedures in Confluence for on-call shift changes. Documented data application architecture and common problems or questions in Confluence to help "pay it forward" to other members of the team.
  • Slalom Build
    Data Engineer
    Slalom Build Jun 2021 - Jun 2022
    Seattle, Washington, Us
    - Pipeline Migration: Tasked in a QE role to document and assume QE duties from the client. Increased resilience of stage deployment process by improving CI/CD testing suite in Rio. Executed deployment from Dev to Staging Airflow pipelines during feature deployments and log4j security vulnerability remediation work. Improved efficiency and data quality by researching and recommending code improvements by creating scripts and documenting processes.- Data Viz Project: Created reports using MS Report Builder and Power BI. Filled the Dev QA role which developed status tracking and executed testing and deployment of reports to client QA.- DE Buddy Project: Automated the assigning of mentors to new DE hires using MS Power Automate with SharePoint forms to collect data, Excel as DB, and Office Scripts (TypeScript).- Cloud DE Academy: a 3-week training program for new hires focused on AWS and Snowflake. Achieved AWS Certified Cloud Practitioner during 3rd week.
  • Capgemini
    Data Engineer
    Capgemini Jan 2021 - Apr 2021
    Paris, France, Fr
    - Snowflake COE group: Assisted in creating demos for Snowflake/AWS migrations- Snowflake Hackathon: Created PowerPoint presentation for potential Snowflake migration- DE Academy program: 4-week new DE hire program. Completed partner training for Snowflake.- Learn new technologies including Snowflake and Datadog
  • Trilogy Education
    Tutor - Full Stack Web Development Coding Bootcamp
    Trilogy Education Sep 2020 - Apr 2021
    Lanham, Maryland, Us
    - Provide support and guidance to the students attending various Full Stack Web Development Program operated by Trilogy Education Services.- Assist students of varying skill levels with code activities, homework, and projects related to front end, back end, and full stack development.- Reinforce lesson material presented by the lead instructor by helping students with questions and reviewing material one-on-one.
  • Trilogy Education
    Teaching Assistant - Uncc Full Stack Web Development Coding Bootcamp
    Trilogy Education Aug 2020 - Feb 2021
    Lanham, Maryland, Us
    -Assist students of varying skill levels with code activities, homework, and projects related to front end, back end, and full stack development-Update and maintain class repository hosted on Gitlab, manage distribution of class materials-Take attendance and work with the instructor to approve and track remote requests and absences-Answer & research student questions, be available for help during daily office hours before and after class
  • Laughing Out Loud, Llc
    Assistant Bookkeeper
    Laughing Out Loud, Llc Jan 2017 - Aug 2017
    * Company is a parent corporation for truck stop plaza, two restaurants, a bar, and a hotel.* Hired for daily cash deposits and A/P for one restaurant, but promoted to handling all A/P and to assist prepping payroll within three months.* Improved efficiency & organization by updating all filing systems and paperwork flow.* Assigned special projects such as becoming a ProctorU proctor to certify restaurant personnel and learning how to program a label maker with Excel import to train deli personnel and general manager on usage and operation.
  • Hilltop National Bank
    Trust Operations Clerk
    Hilltop National Bank Mar 2015 - Jan 2017
    * Updated the official employee handbook for Trust Operations Trading Desk and created a detailed Trading Desk How-To manual with procedures, protocols, and graphics.* Hired as the primary trader for money market accounts and trained as backup trader for mutual fund accounts within 4 months.* Reduced the backlog of document scanning from one year down to one week within 6 months once assigned.
  • Foss Motors
    Office Manager
    Foss Motors May 2010 - Sep 2014
    * Promoted to office manager within the first year which allowed me to implement employee cross-training and development of position duty handbooks.* Hired as “Cashier” and promoted to “In-House Financing Accounts Manager” within 3 months.* Reconciled over 200 in-house financing accounts to establish a reconcilable ledger for active accounts.* Reduced completion time of end-of-month duties from 10 days to 3 days.

Heather Sorrells Skills

Accounts Payable Payroll Office Management Accounts Receivable Spreadsheets Administrative Assistants Quickbooks Outlook Office Administration Invoicing Accounting Bookkeeping Data Entry Budgets Microsoft Word Customer Service Microsoft Excel Administrative Assistance Employee Benefits Management Microsoft Office Microsoft Powerpoint Leadership Time Management

Heather Sorrells Education Details

  • Colorado State University Global
    Colorado State University Global
    Management Information Systems And Business Analytics
  • University Of North Carolina At Charlotte
    University Of North Carolina At Charlotte
    Full-Stack Web Development
  • Casper College
    Casper College
    Economics

Frequently Asked Questions about Heather Sorrells

What company does Heather Sorrells work for?

Heather Sorrells works for Fortyau

What is Heather Sorrells's role at the current company?

Heather Sorrells's current role is Data Engineer | Analytics Engineer | SQL | Snowflake | dbt | Python | Bringing accounting experience and business insights to data engineering teams.

What is Heather Sorrells's email address?

Heather Sorrells's email address is he****@****ank.com

What is Heather Sorrells's direct phone number?

Heather Sorrells's direct phone number is +130725*****

What schools did Heather Sorrells attend?

Heather Sorrells attended Colorado State University Global, University Of North Carolina At Charlotte, Casper College.

What are some of Heather Sorrells's interests?

Heather Sorrells has interest in Economic Empowerment, Education, Science And Technology, Disaster And Humanitarian Relief, Animal Welfare.

What skills is Heather Sorrells known for?

Heather Sorrells has skills like Accounts Payable, Payroll, Office Management, Accounts Receivable, Spreadsheets, Administrative Assistants, Quickbooks, Outlook, Office Administration, Invoicing, Accounting, Bookkeeping.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.