MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious
1

Data Analyst (VBA, Excel) - BHJOB2052)17044

Location Sandy Springs, United States
Posted 11-October-2020
Description

Data & Business Analyst

Exciting opportunity for a Data & Business Analyst to join a progressive international company with a 1st class work environment.

RESPONSIBILITIES:

Spend 70% of the time working with Excel to extract, transform, and report on data. The other 30% is gathering requirements, setting up new customers, working with Developers, supporting reports, and assisting with Power BI dashboards using pre-built templates.Developing VBA code and scripts in ExcelMeet with internal customers (sales team) and external clientsto gather requirements. 90% of the time will be with internal customers.Developcustomer reports (Excel) and Power BI BusinessIntelligence dashboardsusing pre-built templates.Analyzethe business requirements and assist the development team with understanding the business requirements.Review and evaluate data collected through task analysis, business process, surveys, and workshops.Collaborate and consult with the development team during development to ensure the customers needs are met.Developdetailed requirement specificationdocuments, user interface guides,and functional specification documents.Communicateeffectively with external clients and internal teams to deliver the products functional requirements (system workflow, reports, and specs).Documentthe acquired results of analysis and workflows as well as obtainsign-off from the appropriate client and stakeholders.Coordinatewith the team testing the software todetermine issues in services and software.Manage change requests.

This is a direct-hire position in the Sandy Springs / Dunwoody area. We are currently working 100% remote until next year. Excellent work environmentincluding flex hours, on-site gym, game room, and a top-notch restaurant. When we return to the office, you will have the opportunity to telecommute up to two days a week with manager approval. Fantastic opportunity to learn Power BI if you do not have that experience.

REQUIRED SKILLS:

Junior (including recent grads) to mid-levelAdvanced Excel experience, including pivot tables, FORMULA, LOOKUP, TEXT Functions, Macros, etc.VBA coding and scripting experience inExcel (Not executing scripts. Must have experience developing VBA code and scripts yourself)Understanding of ETLAbility to gather and document business requirementsExperience developing reportsA passion for learning new technologies and toolsData analysisSelf-motivated and managedTeam PlayerAnalytical mindsetExcellent communication skillsCollaborative personality

PREFERRED SKILLS:

Power BI (highly preferred)

Must be authorized to work in the U.S. / Sponsorships are not available Contact

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url