Expert Excel / Power Query
Core
Design and implement a consolidated Excel file from multiple distinct sources, automating the process via Power Query to manage critical business data.
Role type
Data automation specialist (Excel/Power Query)
Builds
Consolidated data files and automated data refresh processes
Domain
Business operations / Data management
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Advanced Excel functions, complex formulas, Power Query, data consolidation, data automation, data integrity verification, process documentation
Preferred skills
Process optimization, internal user training
Responsibilities
Consolidate multiple Excel files from different workstations into a single file, use Power Query to merge sources and automate updates, ensure reliability and consistency of consolidated data, document procedures and train internal users, propose process optimizations
Seniority
Mid-level, hands-on IC