Data Analyst 2

About the Role

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.

Key Responsibilities

• Gathers and analyzes data from a variety of internal and external sources dependent on function supported (e.g., HRIS, CRM, Databases).
• Maintains knowledge of key operational metrics within the assigned function and other related teams.
• Extracts large data sets from various sources, 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.
• 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.

Requirements & Tech Stack

• 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 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.

Qualifications

• 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).