Data & Excel Automation Specialist

Data & Excel Automation Specialist Brownsville, TX Job Details $15 an hour 19 hours ago Qualifications Performance dashboard reports Data model design Dashboard development Data modeling Data Integration (Data management) Automation Technical documentation Data reporting Mid-level Scalable systems Financial analysis Technical solutions implementation Analysis skills Solution architecture design Decision making User support Macros VBA Scalability Excel formulas Training Power Pivot Data-driven decision making Excel data analysis Full Job Description Excel & Automation Specialist Are you an Excel power user who loves building smart, automated solutions that make work easier and reporting faster? Do you enjoy transforming messy data into clean dashboards and actionable insights? We're looking for an Excel & Automation Specialist who thrives on solving operational problems with advanced Excel tools. In this role, you'll design scalable Excel-based solutions, automate reporting workflows, and support business decision-making through insightful analysis Key Responsibilities Develop and maintain advanced Excel models, dashboards, and automated reports using Power Query, Power Pivot, dynamic formulas, and VBA/macros Design custom reporting solutions that integrate data from multiple systems and sources Build automated workflows to reduce manual data processing and improve accuracy Create and maintain standardized reporting templates and tools for internal teams Analyze operational, inventory, and financial data to support business decisions Partner with operations and management to understand reporting needs and translate them into technical solutions Document processes, data logic, and tools; provide training and ongoing support to internal users Core Technical Skills & Qualifications Advanced Microsoft Excel expertise, including: Power Query (ETL) Power Pivot & data modeling VBA/macros Complex formulas (INDEX/MATCH, XLOOKUP, dynamic arrays) PivotTables and dashboards Strong understanding of data structures, reporting logic, and automation design Experience working with large datasets and multiple data sources Proven ability to build scalable, maintainable Excel-based reporting solutions Strong analytical mindset with attention to detail and accuracy