Amy Wilder
@amywilder
Accomplished IT professional specializing in database development and analytics.
What I'm looking for
I am an accomplished IT professional with over twenty years of experience in database development and analytics. My focus has always been on helping organizations transform their data into useful information for decision-making. I excel at analyzing existing data flows and sources while understanding business needs and pain points. My expertise lies in designing and developing scalable data solutions that meet business requirements and solve complex problems.
Throughout my career, I have built scalable and efficient data models for various industries, including healthcare, finance, and gaming. I have a proven track record of mentoring and consulting teammates, ensuring that we work collaboratively to achieve our goals. My technical skills include extensive SQL and PL/SQL development, data warehouse design, and proficiency in tools like dbt, BigQuery, and Looker. I am passionate about translating technical concepts for functional users and thrive in environments that encourage innovation and teamwork.
Experience
Work history, roles, and key accomplishments
Staff Consultant
Andersen Consulting
Served as a Staff Consultant, gaining foundational experience in consulting. Contributed to various projects within the firm.
Staff Consultant
Andersen Consulting
Worked as a Staff Consultant, contributing to client projects and gaining foundational consulting experience. Engaged in various aspects of business and technology consulting.
Various Positions
University of St. Thomas
Held numerous positions including Associate Director of Institutional Research, Assistant Director for Enrollment Operations, and Senior Application Programmer Analyst. Contributed to various aspects of university operations and data management.
Independent Contractor, ERP Program
Capella University
Part of a team implementing a new Oracle-based enterprise system. My role grew and evolved to providing consultation and leadership across many areas.
Independent Contractor, ERP program
Capella University
Part of a team implementing a new Oracle-based enterprise system. Provided consultation and leadership across many areas of the ERP program.
Senior Systems Developer/Analyst
Capella University
Helped implement an Operational Data Store on Oracle 11g and an Enterprise Data Warehouse (EDW) housed on SQL Server. This role followed the successful implementation of a new ERP system.
Senior Systems Developer/Analyst
Capella University
Helped implement an Operational Data Store on Oracle 11g, as well as an Enterprise Data Warehouse (EDW) housed on SQL Server. Contributed to the successful implementation of a new ERP system.
Senior Data Specialist
Neustar MarketShare
Feb 2014 - Jun 2019 (5 years 4 months)
Led data analysis engagements for Fortune 500 companies, collaborating with global, cross-functional teams on multi-week projects. Analyzed, processed, transformed, and manipulated client and third-party raw data for time-series analysis and modeling, working closely with statisticians to ensure accurate insights.
Senior Data Specialist
Neustar MarketShare
Feb 2014 - Jun 2019 (5 years 4 months)
Led data analysis engagements for a variety of Fortune 500 companies in various industries. Analyzed, processed, transformed, and manipulated client and third party raw data to prepare it for further time-series analysis and modeling.
Senior Application Programmer Analyst
University of St. Thomas
Held various roles including Associate Director of Institutional Research and Assistant Director for Enrollment Operations. Focused on application programming and analysis within the university setting.
Senior Reporting Data Analyst
Simple Finance
Jun 2019 - Mar 2021 (1 year 9 months)
Supported and evangelized data self-service efforts by leading widespread adoption of the BI tool, Chartio. Enhanced the Redshift reporting data layer by developing new tables and/or modifying existing logic in the data warehouse pipeline, and supported Fraud operations by conducting SQL analyses.
Senior Reporting Data Analyst
Simple Finance
Jun 2019 - Mar 2021 (1 year 9 months)
Supported and evangelized data self-service efforts by leading widespread adoption of the BI tool, Chartio. Enhanced the Redshift reporting data layer by developing new tables and/or modifying existing logic in the data warehouse pipeline.
Insights Data Engineer
PayNearMe
Mar 2021 - Oct 2021 (7 months)
Owned all aspects of the BI tool, Looker, including designing and testing new views, reports, and dashboards using LookML. Built ETL/ELT data pipelines from production databases or external data services to Snowflake, used dbt to transform data, and designed and built datamarts for specific business areas.
Senior Analytics Engineer
Brooklyn Data Co.
Oct 2021 - Nov 2024 (3 years 1 month)
Developed data pipelines and analytics solutions for clients in various sectors, ranging from initial tooling for startups to improving pipelines for Fortune 500 clients. Configured Snowflake and other systems' roles and permissions to ensure privacy and compliance.
Insights Data Engineer
PayNearMe
Mar 2021 - Oct 2021 (7 months)
Owned all aspects of the BI tool, Looker, including designing and testing new views, reports, and dashboards using LookML. Built ETL/ELT data pipelines from production databases or external data services to Snowflake.
Senior Analytics Engineer
Brooklyn Data Co.
Oct 2021 - Nov 2024 (3 years 1 month)
Developed data pipelines and analytics solutions for clients across healthcare, nonprofit, retail, and finance sectors. Used dbt core and/or dbt cloud to transform, document, test, and orchestrate data models, and configured Snowflake and other systems' roles and permissions.
Education
Degrees, certifications, and relevant coursework
University of Minnesota
Master of Arts, Educational Psychology: Statistics and Research Design
Pursued a Master of Arts degree with a strong emphasis on Statistics and Research Design. Focused on advanced methodologies within Educational Psychology.
College of St. Thomas
Bachelor of Arts, Quantitative Methods/Computer Science
Completed a Bachelor of Arts degree with a major in Quantitative Methods and Computer Science. Also pursued a minor in Mathematics, building a strong foundation in analytical and computational skills.
University of St. Thomas
Bachelor of Arts, Quantitative Methods/Computer Science
Completed a Bachelor of Arts degree with a dual major in Quantitative Methods and Computer Science. Also pursued a minor in Mathematics, building a strong foundation in analytical and computational skills for problem-solving.
Availability
Location
Authorized to work in
Social media
Interested in hiring Amy?
You can contact Amy and 90k+ other talented remote workers on Himalayas.
Message AmyFind your dream job
Sign up now and join over 85,000 remote workers who receive personalized job alerts, curated job matches, and more for free!
