Data Analyst

E-Solutions Group - Chicago, IL

Full-time

Chicago, IL

Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services

About the position

The Data Analyst position is a critical role within our organization, focusing on enhancing data collection and storage procedures while ensuring data quality. The successful candidate will collaborate closely with data engineers, data modelers, data architects, and technical subject matter experts to perform comprehensive data analysis. This role requires a deep understanding of the insurance industry, particularly in areas such as Underwriting, Claims, Finance, or Operations, to effectively evaluate changes to source systems and their impacts on the data and reporting landscape. In this position, you will be responsible for developing processes and procedures that ensure the integrity and quality of data. You will work alongside business analysts and technical experts to understand source systems and assist in the analysis of data integration and transformation. Your ability to communicate complex requirements clearly and concisely will be essential as you support teams with data requirements, source-to-target mappings, and other data-oriented deliverables. Additionally, you will consult with data and business owners to identify all facets of data issues, helping to generate solutions while understanding the potential impacts on processes and systems across the organization. Participation in discovery meetings, providing estimates, analyzing and validating project requirements, and performing impact analysis will be key responsibilities. You will also troubleshoot job failures with developers and support the development and monitoring of data quality and governance processes, identifying operational gaps that could affect business usage.

Responsibilities

• Perform data analysis and collaborate with data engineers, data modelers, data architects, and technical subject matter experts to enhance data collection and storage procedures.
• Prepare data quality analysis and reports, ensuring the development of processes and procedures necessary for quality data.
• Evaluate changes to source systems and assess their impacts on the data and reporting landscape.
• Work closely with business analysts and technical subject matter experts to understand source systems and assist in data integration and transformation analysis.
• Support teams with data requirements, source-to-target mappings, and other data-oriented deliverables.
• Consult with data/business owners and teammates to identify all facets of a data issue and generate solutions, understanding potential impacts to processes and systems.
• Work directly with business executives to identify areas for improvement.
• Participate in discovery meetings, provide estimates, analyze and validate project requirements and technical specifications, perform impact analysis, and document key issues.
• Troubleshoot job failures with developers as necessary.
• Support the development and monitoring of data quality and data governance processes.
• Identify operational gaps in delivery based on potential business usage.

Requirements

• Bachelor's Degree or equivalent work experience.
• Experience in primary commercial and specialty insurance with a focus on data or business analysis.
• Specific domain expertise in insurance areas such as Underwriting, Claims, Finance, or Operations.
• Understanding of insurance KPIs and experience in their implementation.
• Demonstrated analytical and problem-solving skills.
• Knowledge of data warehousing, business analysis tools, and data management techniques.
• Ability to work in a fast-paced environment, juggle multiple priorities, and be adaptive to change.
• Ability to quickly assimilate data and communicate complex requirements and issues clearly and concisely.
• Ability to analyze the root cause of a problem and demonstrate good sense when determining impact.
• Effectively work in a collaborative environment across functional teams.
• Excellent organizational, multi-tasking, and time management skills.
• Strong interpersonal communication skills and presentation skills.
• Demonstrated expertise in Power BI and report modeling or equivalent skills in similar data visualization tools.
• Working experience in Snowflake and its associated technologies such as snowpipe, snowpark, etc.
• Understanding of data profiling techniques.
• Strong knowledge of relational databases, SQL, and Python.