Checking job availability...
Original
Simplified
________________________________________ Job Summary: We are seeking a highly skilled Technical Consultant with expertise in VBA, Excel Macro development, and Power BI to support automation, reporting, and dashboarding requirements for business functions. The ideal candidate will have hands-on experience building and optimizing automation solutions using VBA, and developing data visualizations and reports using Power BI for informed decision-making. ________________________________________ Key Responsibilities: • Develop, maintain, and enhance VBA-based tools, Excel macros, and automation scripts for business operations. • Work closely with business users to gather requirements and translate them into efficient, scalable Excel/VBA tools. • Design and develop interactive and visually compelling Power BI dashboards and reports from various data sources (Excel, SQL, etc.). • Ensure data accuracy, performance optimization, and user-friendly layouts for reports and tools. • Conduct data analysis and modeling to support business reporting needs and KPIs. • Troubleshoot and resolve issues related to VBA scripts, formulas, and BI data refreshes. • Collaborate with IT and business stakeholders to enhance data automation and analytics capabilities. ________________________________________ Required Skills & Experience: • 5+ years of hands-on experience in VBA (Visual Basic for Applications) and Excel macro development. • Strong experience in Power BI dashboard design, DAX functions, and data transformation using Power Query. • Proficient in advanced Excel functions, formulas, pivot tables, and scripting. • Experience working with data from SQL Server, Excel, Access, or cloud data sources. • Ability to communicate effectively with both technical and non-technical stakeholders. • Strong problem-solving and debugging skills. ________________________________________ Preferred Qualifications: • Knowledge of automation tools such as Power Automate, Alteryx, or similar is a plus. • Understanding of data governance, security, and performance optimization in reporting. • Bachelor's degree in Computer Science, Information Systems, or a related field. • Certification in Power BI or Microsoft Excel Expert will be an advantage.