AI Solutions Data Analyst Location: Kansas City, MO, US, 64106 **Best People + Right Culture. These are the driving forces behind JE Dunn's success.** **By hiring inspired people, giving them interesting and challenging work, enabling them with innovative tools, and letting them share in the company's rewards, we've found a sustainable way to grow in our industry for the last 100+ years.** **Our diverse teams around the country strive to enrich lives through inspired people and places everyday, and we need inspired people like you to join us in building authentic partnerships.** **Role Summary** The Data Analyst 2 will collect, compile, transform, and analyze data, metrics, and statistics from various internal and external sources to create reports and insights to inform management. This role will also act as a specialist on reporting tools and dashboards within the area of specialization. All activities will be performed in support of the strategy, vision and values of JE Dunn. + Autonomy & Decision-Making: Makes decisions on assigned areas of responsibility, provides recommendations to supervisor and refers all exceptions to supervisor, as needed. + Career Path: Senior Data Analyst **Key Role Responsibilities - Core** _DATA ANALYST FAMILY - CORE_ + Gathers and analyzes data from a variety of internal and external sources dependent on function supported (e.g. HRIS, CRM, Databases etc.) + Maintains knowledge of key operational metrics within the assigned function and other related teams + Extracts large data sets from various sources to facilitate reporting and analysis, manipulating and cleaning data as needed + Utilizes data visualization tools such as Power BI or Tableau to effectively communicate metrics and insights to management + Audits data, data sources and processes ensuring compliance with data privacy regulations and best practices + Supports leadership with both scheduled and ad-hoc reporting requests + May assist with developing or revising data analytics strategy within the defined function to support the broad organizational data strategy + Builds tools and processes to improve data management and reporting efficiency under direction from leadership + Documents historical reporting, parameters and datasets to allow time-series comparisons **Key Role Responsibilities - Additional Core** _DATA ANALYST 2_ In addition, this role will be responsible for the following: + Partners with business leaders to understand operational needs and build timely and scalable reports using various data sources + Advises team members on data resources and tools available, assisting with finding, cleaning, and analyzing raw data for use + Identifies relevant data sets for area of specialization building reports and dashboards applicable to both strategic decision making and day-to-day operations + Partners with internal data consulting team on large scale or complex business data requests + Advises on best practices for integrating technology and tools into daily practices across assigned function + Builds custom reports and templates for use by team members as needed + Uses knowledge of reporting to make recommendations on data applicable to the operations of assigned functions + Partners with data analytics professionals across the organization to enhance data quality in various systems **Knowledge, Skills & Abilities** + Ability to perform work accurately and completely, and in a timely manner + Communication skills, verbal and written + Proficiency in MS Office - Intermediate + Proficiency in MS Excel - Intermediate + Proficiency in Power Apps and Power Automate + Experience in Power BI- Intermediate + Knowledge of SQL, including creating simple SQL queries + Knowledge of integrations and API development + Ability to connect to multiple data sets, import data, and transform the data to support data visualizations and further analyses + Proficiency in delivering data visualizations to internal customers based on project requirements + Ability to compile statistics and prepare statistical reports + Ability to prioritize multiple projects + Attention to detail and the ability to evaluate data against expected results + Ability to think analytically for translating data into informative visuals and reports + Ability to communicate to various audiences + Ability to build relationships and collaborate within a team, internally and externally + Ability to influence change through innovation and process improvement + Time Management Skills + Listening Skills **Education** + Bachelor's degree in data science, analytics or related field (Required) + In lieu of the above requirements, relevant experience will be considered **Experience** + 2+ years' experience in data analysis (Preferred) + 2+ years' experience in visualization tools (Preferred) **Working Environment** + Must be able to lift up to 10 pounds + Typically travel is not required + Normal office en