Associate Business Intelligence Analyst
Summary
Build and maintain BI dashboards and reports in Power BI/Tableau, analyze business data with SQL and Python, and translate insights for leadership to drive decisions.
Support business decisions by providing quantitative and qualitative data analysis and reporting of patterns, insights, and trends to leadership via dashboards and reports. Analyze business problems and issues using business intelligence tools that incorporate data from internal and external sources. Entry level professional with developing skill set and a basic understanding of procedures and analysis techniques.
Responsibilities• Follow standard procedures to create and/or update basic reports and dashboards• Identify trends or patterns and help prepare ongoing reports and data visualizations in order to support business decision• Contribute to reports that show key performance indicators, identify areas of improvement into current operations, and display root cause analysis of problems• Partner with leaders and senior staff to define specifications for reports and analysis based on business needs and required or available data elements• Support and participate in team projects and initiatives• Utilize and adhere to data governance documents and procedures; alert supervisors if any inconsistency or inaccuracy is discovered during the course of reporting or analysis• Collect, aggregate, and analyze data from multiple sources, including structured and unstructured data sets, to drive insights into business performance• Identify, analyze, and interpret trends or patterns and prepare ongoing reports and data visualizations in order to support business decisions• Develop, maintain, and manage reports, dashboards, and BI solutions Produce actionable reports that show key performance indicators, identify areas of improvement into current operations, and display root cause analysis of problems• Use analytics and metrics to improve processes and provide data-driven forecasts of potential costs, risks, and profits of new business initiatives• Provide reporting solutions and respond to ad-hoc report requests within the business area• Create specifications for reports and analysis based on business needs and required or available data elements
Qualifications• Bachelor's Degree in Business Administration, Statistics, or related field• 1-5 years of experience in data analysis and reporting• Proficiency in SQL, including query optimization and performance tuning• Experience designing scalable dashboards and self-service reporting solutions (Power BI or Tableau)• Proven ability to translate ambiguous business problems into clear analytical requirements, success metrics, and reporting solutions• Moderate skill using business intelligence applications and/or cloud services• Moderate knowledge of reporting capabilities of existing ERP, CRM and/or database software vendors• Moderate skill in complex data manipulation across multiple tables• Effective data integration, cleaning and validation skills• Skill communicating data analysis and visualizations to nontechnical and senior audiences• Experience with data analysis tools and programming languages such as Python• Research skills• Interpersonal skills