Amy Wilder

About

I am a data analyst & engineer, a puzzle-solver, and a creative thinker who believes that having fun and doing great work are not mutually exclusive. I bring years of experience in figuring out data, databases, and data flow, making it fit together in new ways to answer questions, solve problems, or optimize processes. I'm the go-to person for understanding and making things happen. An accomplished IT professional with over twenty years of experience in information systems specializing in business information and data flow needs, designing and developing solutions. Expertise in data modeling, conversion, analysis, database design, integration, transformation, and ETL processes. Skilled at translating between functional and technical users and collaborating successfully with all levels of colleagues across the organization. I have led data initiatives across multiple industries, including partnerships with Looker/LookML, Snowflake, and dbt to deliver scalable analytics platforms.

Experience

• Staff Analytics Engineer · Untitled Data Company05-01-2025

  Contract work ingesting, modeling, and analyzing data. Example projects: ● Build a new dashboard using Hex for a B2B Saas company ● Build new dbt models to calculate performance indicators such as Monthly Returning Revenue and subscriber churn for a subscription-based organization ● Enhance a dbt project to allow standardization of reporting to external clients for a Fintech Technologies used: dbt Core, dbt Cloud Fusion, Hex, Snowflake, GCP

• Staff Analytics Engineer · Scopely11-01-2024 – 05-01-2025

  Build scalable and efficient data models to process event data for a large mobile gaming company ● Build and enhance dbt models ● Optimize BigQuery processing ● Provide mentorship and consultation to teammates Technologies used: dbt, BigQuery, SQL, Looker, Python, git, CI/CD, Airflow, GCP

• Sr Analytics Engineer · Brooklyn Data Co. (a Velir company)10-01-2021 – 11-01-2024

  As a data consultant, my primary responsibility was to build scalable and efficient data models using dbt; my experience has spanned across the data pipeline from setting up data ingestion tools to developing dashboards. ● Develop data pipelines and analytics solutions for clients in the healthcare, nonprofit, retail, and finance sectors, ranging from initial tooling for startups to improving pipelines for Fortune 500 clients. ● Use dbt core and/or dbt cloud to transform, document, test, and orchestrate data models ● Serve as a client lead for teams of data engineers, analytics engineers, and/or data analysts ● Configure Snowflake and other systems’ roles and permissions to ensure privacy and compliance with industry regulations and best practices ● Provide mentorship and consultation to teammates Technologies used: Snowflake, dbt, BigQuery, Fivetran, Meltano, SQL, Tableau,

• Insight Data Engineer · PayNearMe03-01-2021 – 10-01-2021

  As half of a newly-formed Data Team, I owned all aspects of supporting our BI tool, Looker, including designing and testing new views, models, and internal-facing dashboards as well as customer-facing embedded dashboards. I also helped plan a new Snowflake enterprise data warehouse and build out ETL/ELT data pipelines with XPlenty, use dbt to transform data, and design and build datamarts for specific business areas. Technologies used: Snowflake, Looker, LookML, dbt, XPlenty, SQL

• Senior Reporting Data Analyst · Simple Finance06-01-2019 – 03-01-2021

  As part of a 5-person Analytics team, I supported our company-wide self-service reporting initiative by providing training and mentorship for users of our BI solution, Chartio. I developed and implemented changes to our underlying data warehouse. I partnered closely with our Fraud team to develop operational reports as well as analyses of fraudulent activity. Technologies used: AWS PostGreSQL, Chartio, Python, Jira, Confluence, Scrum, PowerBI

• Data Analysis Manager · MarketShare (acquired by Neustar, Inc. in 2015)2014-02-01 – 2019-06-01

  As part of the Data Management Team at MarketShare, an industry-leading provider of marketing mix modeling, attribution, and optimization analysis, I led data analysis engagements for a variety of Fortune 500 companies in the consumer products, automotive, finance and banking, and entertainment/media industries. Collaborating with global, cross-functional teams, typically on 3-5 projects at any given time, my primary responsibilities included analyzing, processing, transforming, and manipulating client and third party raw data to prepare it for further time-series analysis and modeling and timely client software delivery. Technologies used: SAS & SAS Enterprise Guide, SQL, AWS, Databricks, Spark, Python, Tableau, Agile software development, Atlassian Confluence & JIRA.

• Senior Systems Developer · Capella University2005-10-01 – 2014-01-01

  Served various roles including database and data warehouse developer, data conversion/ETL developer, business intelligence analyst, report developer, and business analyst. Contributed to ERP implementation of PeopleSoft Campus Solutions, including data conversion and integration work. Technologies used: PL/SQL, Oracle databases, SQL Server databases, SQL Server Reporting Services, PeopleSoft, SharePoint.

• Programmer/Analyst · University of St.Thomas1991-01-01 – 2005-01-01

  Served in a variety of information technology roles focused on transforming and synthesizing data into usable information for decision-makers. Technologies used: PL/SQL, Unix and VMS shell scripting, FOCUS, SPSS

Education

• University of MinnesotaMaster's Degree, Educational Psychology, Statistics and Research Design Emphasis
• University of St. ThomasBachelor's Degree, Computer Science

Similar talent on Pangea

Meghana G.Senior Data Engineer | Analytics Engineering & ELT Pipelines (dbt, Snowflake, AWS)Boston, MAShivakumar P.Analytical Data Professional | Data Validation, ETL & Scalable Data Pipelines | Python, SQL, Snowflake, dbt & Looker & BI DashboardsBoston, MAaabhinav kumar S.Data Analyst with 4+ Years of Experience in Data Modeling, Dashboard Development, and Strategic Insights.United StatesSarah S.Data Analyst | Driving Data-Driven Decisions |Colorado Springs, CO