Senior Data Analyst
United States
● Problem framing, assessment of in-place processes that need improvement or correction. Gathering of such information required to build the scope, communicating between multiple levels of management, to formulate a resolution and the implementation thereof.● Creation and maintenance of dashboards for daily management, migration of data between systems.● Large reduction in administrative effort by use of SQL for mass data updates.● Reporting directly to Executives, Management, and teams with insight and intelligence on the health of the business using proven processes and algorithms, performance and various departmental KPIs (Key Performance indicators) with existing and incoming data.● Ad hoc reporting for financial, operational, and sales use. Ensuring information is actionable, for decision-making.● Mass updates of data for cleanup and transform section of ETL processes –provides cleaner and more long-term evolutionary data for dependable dashboards.● Troubleshooting and utilizing Microsoft Dynamics CRM to visualize data and create solutions to complex sales and operations processes using workflows.● Management of IT support consultants hired for projects and general support● Planning and implementation of company software (Dynamics GP, Key2Act/Wennsoft Signature products, eOne Smart Connect). This includes mass data migration.● Management of project budget, review of invoices, and validation of cost incurred from consultant hours billed to company● Documenting feature requirements and learning business processes and workflows to best accommodate effectiveness and efficiency in business activities.● Building architecture of data and import structures for migration of data to new system (SQL)● Software training and communication of data structures for users of company data● Interaction with users to understand gaps in learning. Refining approach to efficiently train users and fill in learning gaps.