Autumn E. Atchley

Autumn E. Atchley

Lead Technical Business Analyst / Data Engineer
United States of America

نبذة عني

Lead Technical Business Analyst / Data Engineer with experience in data migration, ETL, data governance, and enterprise analytics across automotive, healthcare, financial services, and retail environments. Experienced wi…

الخبرة

Data Engineer

Lithia
Oct 2021 - حتى الآن · 4 سنوات 8 أشهر

• Migrate large data sets in Azure Data Factory and Snowflake environments, using technologies including Data Factory pipelines, Azure cloud tools, and various external vendor data ingestion technologies (API, SFTP, CSV, JSON, etc.)
• Led a QA team on an enterprise dashboard project testing data, views, stored procedures, and user interfaces.
• Develop a tagging and identification system of PII data in Snowflake, including development of role strategies and user access reporting.
• Built large ETL processes that managed telemetry data for a subsidiary and ingested data from multiple payment vendors.
• Implemented data governance procedures for handling sensitive information (PII) using Snowflake profiling tools.
• Extensive craftsmanship with SQL and ANSI SQL.

Lead Technical Business Analyst / Data Engineer

Lithia Motors, Remote
حتى الآن

Migrate large data sets in Azure Data Factory and Snowflake environments, using technologies including Data Factory pipelines, Azure cloud tools, and various external vendor data ingestion technologies (API, SFTP, CSV, JSON, etc.)
Led a QA team on an enterprise dashboard project testing data, views, stored procedures, and user interfaces.
Develop a tagging and identification system of PII data in Snowflake, including development of role strategies and user access reporting.
Built large ETL processes that managed telemetry data for a subsidiary and ingested data from multiple payment vendors.
Implemented data governance procedures for handling sensitive information (PII) using Snowflake profiling tools.
Extensive craftsmanship with SQL and ANSI SQL.

Project Manager / Senior Business Analyst

University of St. Augustine for Health Sciences, Remote

Managed complex data flow integrations and data migrations for four teams.
Ensured architectural compliance for existing data sets and cross-organization data sharing.
Created and enforced enterprise-wide data governance process flows for handling sensitive information.
Responsible for gathering requirements, building project plans and writing user stories in Jira.
Engineered financial models and reporting using SQL, Snowflake, and Power BI.
Performed deep analytics from non-standard data sets across multiple systems, vendors, and teams.

Senior Data Strategy Consultant

Ford Motor Company, Dearborn, MI

Managed multiple teams’ data flow processes and workflows.
Established best practices for enterprise data governance.
Mobilized a strategic initiative to build an Electronic Data Catalog in Informatica.
Coordinated training for tools such as Informatica’s product suite and Rally by CA Agile.
Managed internal technology budget and managed staffing resources.
Drove KPI initiatives with supporting data.

Information Technology Manager

Muffler Man, Southgate, MI

Provided multi-site franchise leadership and hands-on support for technical operations.
Managed staffing, technology, and inventory budgets.
Conducted in-depth data modeling and to identify problems in each practice area.
Implemented cloud-based software to track inventory, parts, and accounting.
Restructured ETL between franchisees and corporate using SQL through API gateway.

Data Solution Architect

Quicken Loans, Detroit, MI

Launched both a company-wide data dictionary and a metadata management system using Collibra.
Supported and improved mortgage origination systems as well as servicing systems.
Led development of RESTful web services to integrate data sources.
Facilitated implementation of Amazon Web Services (AWS) for multiple product lines.
Constructed data infrastructure for Super Bowl-scale product Rocket Mortgage.
Actively involved in recruiting, interviewing, and mentoring data engineers and architects.

Director, Financial Data Analytics

AlixPartners, LLP, Southfield, MI

Created financial reporting analysis using Hyperion Smartview and SAP Business Objects.
Created and reconciled financial statements and mappings using HFM and SQL.
Directed and developed global reporting systems software implementation.
Built a complex data warehouse that sourced data from thousands of sources.

IT Manager

Infinity Homes & Co., via Adea Systems, LLC, Novi, MI

Supported company networks and infrastructure.
Ensured all systems, servers, email servers and networks ran efficiently.
Built and expanded closed-captioned monitoring system.
Created stable VPN and networking for remote workers.

IT Manager

Ecology Coatings, via Adea Systems, LLC, Bloomfield Hills, MI

Ran all servers, including backups, disaster recovery, uptime, etc.
Provided technical support for users and systems.
Achieved organic SEO placement in Google search results for specific keywords.
Assisted General Counsel with SOX compliance for the company's IPO.

المهارات

البيانات الضخمة هادوب (Hadoop) سكالا سبارك أباتشي هايف أباتشي بيغ خدمات أمازون ويب (AWS) كافكا نوسكيو إل ردشفت (خدمة قاعدة بيانات) إس 3 (خدمة تخزين البيانات على الإنترنت) Azure Data Factory Snowflake SQL ANSI SQL API SFTP CSV JSON Data Governance PII ETL Telemetry Data Jira Power BI Informatica Rally by CA Agile Budget Management Staffing Data Modeling Cloud Computing Amazon Web Services (AWS) RESTful Web Services Collibra Metadata Management Hyperion Smartview SAP Business Objects HFM Data Warehouse VPN Networking SEO SOX Compliance SSIS Relational Modeling Enterprise Modeling Conceptual Modeling Logical Modeling Physical Modeling ElasticSearch Elastic Cloud SQL Server Postgres Riak (Basho) Neo4j MongoDB DynamoDB Redis TSQL PL/SQL
الإبلاغ عن هذا الملف الشخصي؟