JOB DESCRIPTION
Essential Duties & Responsibilities
Performs a combination of duties in accordance with departmental guidelines :
Specialized expertise designing, implementing, developing and maintaining dashboards and apps, developing and executing data mapping and transformation processes and requirements within and between applications and data sources across CNA;
rationalizing and analyzing large amounts of data across multiple sources. Creates and implements testing methods and procedures as appropriate.
- Collaborates with management, technical staff and subject matter advisors to understand business issues, troubleshoot problems and develop and recommend cost-effective data solutions for data anomalies.
- Conducts data analysis, develops and executes requisite changes to implement approved requests, ensuring that new requirements comply with CNA’s data policy and / or reporting needs.
Crafts high level design of data solutions. Consults with relevant stakeholders to analyze dashboard usage and capabilities, identifies associated risks, resolves problems and recommends and / or executes resolutions.
Tests changes prior to deployment into production environment as appropriate.
- Ensures data integrity by developing and executing necessary processes and controls around the flow of data. Performs data cleansing to ensure quality of data output.
- Utilizes technology to analyze data and / or metrics from applicable systems to review data processes, identify issues, determine actions to resolve or escalate problems that require data, system or process improvements.
- Conducts training and coaching of users on features and functions of dashboard and other related tools / reports.
- Leads data related research and root cause analysis activities, provides correction specifications, and escalates issues as appropriate.
- Works with technical and non-technical stakeholders on various analyses and research, and participates in and / or may lead special projects as appropriate.
- Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications;
establishing personal networks; participating in professional societies.
May perform additional duties as assigned.
Reporting Relationship
Typically reports to Director or above
Skills, Knowledge & Abilities
- Deep analytical, integrative and problem-solving skills with proven ability to manipulate and analyze high-volume, high-dimensionality data from varied sources.
- Solid communication, interpersonal, influencing and presentation skills to work effectively among all levels of internal / external stakeholders.
- Strong ability to multitask in a fast-paced, dynamic work environment.
- Ability to work independently as well as collaboratively in a team environment.
- Skillful at learning new system applications / functions.
- Readily adapts to change.
Education & Experience
- Bachelor’s degree in related discipline or equivalent work experience.
- Typically a minimum of five to seven years of experience in data / statistical analysis, data architecture, data modeling and business intelligence.
- Advanced skill and experience with Microsoft Power BI and Microsoft Power Apps, with a minimum of five years of experience blending and analyzing multiple data sets, building reporting pipelines and dashboards and utilizing analysis and reporting / visualization tools.
- Applicable certifications preferred.