Data Analyst 2

J.E. Dunn Construction Group Inc P•Kansas City, MO

About The Position

The Data Analyst 2 collects, compiles, transforms, and analyzes data, metrics, and statistics from internal and external sources to create reports and insights that inform management. The position serves as a specialist on reporting tools and dashboards within its area of specialization and supports JE Dunn’s strategy, vision, and values. It is located within a manufacturing environment. The role makes decisions within assigned areas of responsibility, recommends actions to a supervisor, and refers exceptions to the supervisor as needed. The stated career path is Senior Data Analyst. The analyst partners with business leaders to understand operational needs and produce timely, scalable reports from multiple data sources. The role supports reporting and analysis, data quality, and the use of technology and tools in daily practices across the assigned function, including by building custom reports, templates, and dashboards for strategic decision-making and day-to-day operations.

Requirements

Bachelor’s degree in data science, analytics, or a related field; relevant experience may be considered in lieu of the degree requirement.
Ability to perform work accurately, completely, and in a timely manner.
Verbal and written communication skills.
Intermediate proficiency in Microsoft Office and Microsoft Excel.
Proficiency in Power Apps and Power Automate.
Intermediate experience with Power BI.
Knowledge of SQL, including creating simple SQL queries.
Knowledge of integrations and API development.
Ability to connect to multiple data sets, import and transform data, and support data visualizations and further analysis.
Ability to deliver 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 ability to evaluate data against expected results.
Analytical thinking skills to translate data into informative visuals and reports.
Ability to communicate with varied audiences.
Ability to build relationships and collaborate with internal and external teams.
Ability to influence change through innovation and process improvement.
Time management skills.
Listening skills.

Nice To Haves

2 or more years of experience in data analysis.
2 or more years of experience with visualization tools.
Technical project management or process automation experience.

Responsibilities

Gather and analyze data from internal and external sources relevant to the supported function.
Maintain knowledge of key operational metrics within the assigned function and related teams.
Extract large data sets, and manipulate and clean data to support reporting and analysis.
Use data visualization tools such as Power BI or Tableau to communicate metrics and insights to management.
Audit data, sources, and processes for compliance with data privacy regulations and best practices.
Support leadership with scheduled and ad-hoc reporting requests.
Assist, as appropriate, with developing or revising data analytics strategy within the function in support of the organizational data strategy.
Build tools and processes to improve data management and reporting efficiency under leadership direction.
Document historical reporting, parameters, and datasets to enable time-series comparisons.
Partner with business leaders to understand operational needs and build timely, scalable reports using various data sources.
Advise team members on available data resources and tools and assist them with finding, cleaning, and analyzing raw data.
Identify relevant data sets for the area of specialization and build reports and dashboards for strategic decisions and daily operations.
Partner with the internal data consulting team on large-scale or complex business data requests.
Advise on best practices for integrating technology and tools into daily practices across the assigned function.
Build custom reports and templates for team members as needed.
Use reporting knowledge to recommend data applicable to the operations of assigned functions.
Partner with data analytics professionals across the organization to improve data quality in various systems.