Excel Data Analyst Jobs in Missouri (NOW HIRING)

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

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

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

• 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

• Bachelor's degree in data science, analytics or related field (Required)
• In lieu of the above requirements, relevant experience will be considered

• 2+ years' experience in data analysis (Preferred)
• 2+ years' experience in visualization tools (Preferred)

The benefits package aligned to this position is Professional Non-Union. Please click the link below for more details.
Click here for benefits details.