Overview: The Business Intelligence Analyst helps advance the Company Analytics Department initiative to deliver data-driven-decisions to our clients through continual improvement of existing and future programs.
The Business Intelligence Analyst is part of a team that works with internal and external stake holders to collect, model, and analyze data generated by our field sales and merchandising teams.
This position is fully remote role.
Required: -Experience with GIS/Geospatial tools such as ESRI ARCGIS, QGIS, and/or E-Spatial
– PowerBI or similar application
– Dashboarding experience
– Experience with large data sets/databases
– Solid understanding of VLOOKUPS and advanced Excel functions will be needed.
Preferred: Knowledge of Predicative Analytics, such as multiple linear regression analysis Job Contact: modonnell2020companies.com Duties and Responsibilities: Job Description:Work in partnership with the Director of Analytics to build new dashboards and reports while optimizing existing reportsManage regular data refreshes of client dashboards and reportsWork with internal and external leaders to identify opportunities for improvement of key business metrics and overall program performanceCollaborate cross-functionally with program managers, Information Services (IS) team members, and client data providers to collect, clean, and analyze dataEstablish KPIs to benchmark existing program performance and measure the effectiveness of new business decisionsStructure large data sets, create data visualizations, and extrapolate information that can be converted into actionable client recommendationsStrategically think though data flow, form a plan of action to troubleshoot any issues, and iterate on the plan as neededCreate client facing reports and presentations suggesting new strategies that will improve overall program performancePerformance Measurements:Completion of projects within set timeline expectationsAccurate and consistent delivery of technical dataQualifications:RequiredBachelor’s degree in relevant programs; business, analytics, economics, etc.Minimum of 3 years’ experience gathering and analyzing dataProficiency in Excel, Power BI (or similar BI tool), Power Query, and PowerPointAnalytically minded with excellent problem-solving skillsKnowledge of data query, cleaning, and transformationAbility to interpret, visualize, and deliver clear and concise recommendations to key stake holdersAttention to detailStrong written and verbal communication skillsTeam player mentalitySelf-starter with a commitment to continuous learning and improvementAbility to adapt to a client-driven work environmentPreferredCoding skills in SQL, Python, and/or RProficient in statistical analysis platformsTechnical writing skills